\u7248\u672c11.2.0.1=>11.2.0.4
\n\u5e73\u53f0CentOS5.9=>redhat6.4
\nexport ORACLE_SID=ORCL<\/p>\n
rman
\nstartup nomount<\/p>\n
\u9996\u5148\u6062\u590dpfile\uff1b
\nrestore spfile from ‘\/sadfasdf\/asdfasdf’;
\n\u4e4b\u540e\u6062\u590dcontrol
\nrestore controlfile from ‘\/sadfasdf\/asdfasdf’;
\n\u6307\u5b9a\u5907\u4efd\u7247\u4f4d\u7f6e
\ncatalog start with ‘\/asdfasdf\/asdfasdf’
\n\u68c0\u67e5\u5907\u4efd\u6709\u6548\u6027
\ncrosscheck backup;
\n\u5220\u9664\u65e0\u6548\u7684\u5907\u4efd\u7247
\ndelete expired backup;<\/p>\n
\u68c0\u67e5\u5f52\u6863\u6709\u6548\u6027
\ncrosscheck archivelog all;
\n\u5220\u9664\u65e0\u6548\u7684\u5f52\u6863
\ndelete expired archivelog all;
\n\u6062\u590d\u6587\u4ef6
\nrun{
\nSET newname FOR DATAFILE 1 TO ‘\/oradata2\/ORCL\/datafile\/system.256.819216263’;
\nSET newname FOR DATAFILE 2 TO ‘\/oradata2\/ORCL\/datafile\/sysaux.257.819216265’;
\nSET newname FOR DATAFILE 3 TO ‘\/oradata2\/ORCL\/datafile\/undotbs1.258.819216265’;
\nSET newname FOR DATAFILE 4 TO ‘\/oradata2\/ORCL\/datafile\/users.259.819216265’;
\nSET newname FOR DATAFILE 5 TO ‘\/oradata2\/ORCL\/datafile\/undotbs2.267.819216517’;
\nSET newname FOR DATAFILE 6 TO ‘\/oradata2\/ORCL\/datafile\/data01.dbf’;
\nSET newname FOR DATAFILE 7 TO ‘\/oradata2\/ORCL\/datafile\/users01.dbf’;
\nSET newname FOR DATAFILE 8 TO ‘\/oradata2\/ORCL\/datafile\/index01.dbf’;
\nrestore database ;
\nswitch datafile all;
\n}<\/p>\n
\u79fb\u52a8redo<\/p>\n
SELECT \u00a0‘ALTER DATABASE RENAME FILE ‘||chr(39)||MEMBER||CHR(39)||’ TO ‘||CHR(39)||REPLACE( MEMBER,’+DATA\/zyhlj’,’\/oradata2\/ORCL’ )||CHR(39)||’;’ FROM \u00a0v$logfile;<\/p>\n
\u8fd8\u539farchivelog<\/p>\n
restore archivelog from sequence 8549 thread 1 until sequence 8568 thread 1;–sequence \u4ece\u5907\u4efd\u7247\u4e2d\u627e\u5230<\/p>\n
restore archivelog from sequence 8549 thread 2 until sequence 8568 thread 2;–sequence \u4ece\u5907\u4efd\u7247\u4e2d\u627e\u5230<\/p>\n
recover database using backup controlfile until cancel;<\/p>\n
alter database open resetlogs;<\/p>\n
shut immediate;<\/p>\n
startup upgrade;<\/p>\n
@?\/rdbms\/admin\/catupgrd.sql<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7248\u672c11.2.0.1=>11.2.0.4 \u5e73\u53f0Cent …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[2],"tags":[],"class_list":["post-114","post","type-post","status-publish","format-standard","hentry","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7zRbQ-1Q","_links":{"self":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=114"}],"version-history":[{"count":6,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/114\/revisions"}],"predecessor-version":[{"id":128,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/114\/revisions\/128"}],"wp:attachment":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}