{"id":7606,"date":"2018-06-20T21:28:32","date_gmt":"2018-06-20T13:28:32","guid":{"rendered":"http:\/\/rmohan.com\/?p=7606"},"modified":"2018-06-20T21:47:58","modified_gmt":"2018-06-20T13:47:58","slug":"oracle-backup-2","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=7606","title":{"rendered":"oracle xe backup"},"content":{"rendered":"<pre>ORACLE_BASE=\/u01\/app\/oracle\r\nexport ORACLE_BASE\r\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/xe\r\nexport ORACLE_HOME\r\nORACLE_SID=XE\r\nexport ORACLE_SID\r\nPATH=$ORACLE_HOME\/bin:$PATH\r\nexport PATH\r\n\r\nBKUP_DEST=\/home\/mohan\/backups\r\nfind $BKUP_DEST -name 'backup*.dmp' -mtime +10 -exec rm {} \\;\r\n\r\n\r\n\r\ncd \/home\/mohan\/backups &amp;&amp; \/u01\/app\/oracle\/product\/11.2.0\/xe\/bin\/exp schema\/password FILE=backup_`date +'%Y%m%d-%H%M'`.dmp STATISTICS=NONE\r\n\r\n\r\n<\/pre>\n<pre>startup nomount pfile=\/u01\/app\/oracle\/product\/11.2.0\/xe\/dbs\/initXE.ora\r\n\/\r\n\r\ncreate database\r\n        maxinstances 1\r\n        maxloghistory 2\r\n        maxlogfiles 16\r\n        maxlogmembers 2\r\n        maxdatafiles 30\r\n      datafile '\/u01\/app\/oracle\/oradata\/XE\/system.dbf'\r\n        size 200M reuse autoextend on next 10M maxsize 600M\r\n        extent management local\r\n      sysaux datafile '\/u01\/app\/oracle\/oradata\/XE\/sysaux.dbf'\r\n        size 10M reuse autoextend on next  10M\r\n      default temporary tablespace temp tempfile \r\n '\/u01\/app\/oracle\/oradata\/XE\/temp.dbf'\r\n        size 20M reuse autoextend on next  10M maxsize 500M\r\n      undo tablespace undotbs1 datafile '\/u01\/app\/oracle\/oradata\/XE\/undotbs1.dbf'\r\n        size 50M reuse autoextend on next  5M maxsize 500M\r\n       character set cl8mswin1251\r\n       national character set al16utf16\r\n       set time_zone='00:00'\r\n       controlfile reuse\r\n       logfile '\/u01\/app\/oracle\/oradata\/XE\/log1.dbf' size 50m reuse\r\n             , '\/u01\/app\/oracle\/oradata\/XE\/log2.dbf' size 50m reuse\r\n             , '\/u01\/app\/oracle\/oradata\/XE\/log3.dbf' size 50m reuse\r\n      user system identified by oracle\r\n      user sys identified by oracle\r\n\/\r\n\r\ncreate tablespace users\r\n       datafile '\/u01\/app\/oracle\/oradata\/XE\/users.dbf'\r\n       size 100M reuse autoextend on next 10M maxsize 11G\r\n       extent management local\r\n\/\r\n\r\nexit;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>ORACLE_BASE=\/u01\/app\/oracle export ORACLE_BASE ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/xe export ORACLE_HOME ORACLE_SID=XE export ORACLE_SID PATH=$ORACLE_HOME\/bin:$PATH export PATH BKUP_DEST=\/home\/mohan\/backups find $BKUP_DEST -name &#8216;backup*.dmp&#8217; -mtime +10 -exec rm {} \\; cd \/home\/mohan\/backups &amp;&amp; \/u01\/app\/oracle\/product\/11.2.0\/xe\/bin\/exp schema\/password FILE=backup_`date +&#8217;%Y%m%d-%H%M&#8217;`.dmp STATISTICS=NONE startup nomount pfile=\/u01\/app\/oracle\/product\/11.2.0\/xe\/dbs\/initXE.ora \/ create database maxinstances 1 maxloghistory 2 maxlogfiles 16 maxlogmembers 2 maxdatafiles 30 datafile &#8216;\/u01\/app\/oracle\/oradata\/XE\/system.dbf&#8217; size 200M reuse autoextend on next [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7606"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7606"}],"version-history":[{"count":3,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7606\/revisions"}],"predecessor-version":[{"id":7609,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7606\/revisions\/7609"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}