{"id":735,"date":"2018-05-21T14:09:33","date_gmt":"2018-05-21T06:09:33","guid":{"rendered":"http:\/\/www.821121.com\/?p=735"},"modified":"2020-12-04T11:11:55","modified_gmt":"2020-12-04T03:11:55","slug":"oracle-rman%e5%a4%87%e4%bb%bd%e8%84%9a%e6%9c%ac","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=735","title":{"rendered":"ORACLE RMAN\u5907\u4efd\u811a\u672c"},"content":{"rendered":"

RMAN\u5168\u5907\u811a\u672c
\nexport today=date +%Y%m%d%H%M<\/code>
\nexport NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
\nexport MYPATH=\/backup\/rman\/"$ORACLE_SID"\/"$today"
\nif [[ ! -e "$MYPATH" ]]
\nthen
\nmkdir -p "$MYPATH";
\nfi<\/p>\n

$ORACLEHOME\/bin\/rman target \/ log=$MYPATH\/full<\/em>"$ORACLESID"<\/em>"$today".log <<EOF
\nrun{
\nallocate channel c1 device type disk;
\nallocate channel c2 device type disk;
\nallocate channel c3 device type disk;
\nallocate channel c4 device type disk;
\nbackup as compressed backupset full database tag 'dbfull' format '$MYPATH\/%d-%T-%U.full';
\nsql 'alter system archive log current';
\nbackup archivelog all format '$MYPATH\/%d-%T-%U.arc' delete input;
\nbackup current controlfile format '$MYPATH\/%d-%T-%U.ctf';
\nbackup spfile format '$MYPATH\/%d-%T-%U.spt';
\ncrosscheck backup;
\ncrosscheck archivelog all;
\ndelete noprompt expired backup;
\ndelete noprompt expired archivelog all;
\ndelete noprompt obsolete;
\nrelease channel c1;
\nrelease channel c2;
\nrelease channel c3;
\nrelease channel c4;
\n}
\nexit;
\nEOF<\/p>\n","protected":false},"excerpt":{"rendered":"

RMAN\u5168\u5907\u811a\u672c export today=dat<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"class_list":["post-735","post","type-post","status-publish","format-standard","hentry","category-34"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=735"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/735\/revisions"}],"predecessor-version":[{"id":737,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/735\/revisions\/737"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=735"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}