{"id":1018,"date":"2019-12-11T09:35:44","date_gmt":"2019-12-11T01:35:44","guid":{"rendered":"http:\/\/www.821121.com\/?p=1018"},"modified":"2020-12-11T09:46:53","modified_gmt":"2020-12-11T01:46:53","slug":"12c%e6%96%b0%e7%89%b9%e6%80%a7repair-datafile%e3%80%81repair-pluggable-database","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1018","title":{"rendered":"12C\u65b0\u7279\u6027:repair datafile\u3001repair pluggable database"},"content":{"rendered":"

12C\u65b0\u7279\u6027repair datafile\u3001repair pluggable database\u662f\u4ece12.2\u5f00\u542f\u7684\u65b0\u7279\u6027\u3002\u4fee\u590d\u6570\u636e\u5e93\u53d8\u7684\u7b80\u5355\u5f88\u591a\u3002<\/p>\n

\u5907\u4efd\u6570\u636e\u5e93<\/h2>\n
RMAN> backup as compressed backupset  incremental level=0  database format '\/rmanbackup\/rman0_%d_%s_%T' tag='level0' plus archivelog;<\/code><\/pre>\n
\u4e00\u3001repair datafile<\/h2>\n
1\u3001\u5236\u9020\u574f\u5757\uff1a<\/h3>\n
SQL> alter database datafile '+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927' offline;\n\nDatabase altered.\n\nSQL>  alter database datafile '+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927' online;\n alter database datafile '+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927' online\n*\nERROR at line 1:\nORA-01113: file 14 needs media recovery\nORA-01110: data file 14:\n'+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927'<\/code><\/pre>\n
2\u3001\u4fee\u590d\u574f\u5757<\/h3>\n
[oracle@cat1 ~]$ rman target \/\n\nRecovery Manager: Release 19.0.0.0.0 - Production on Fri Dec 11 09:01:03 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: WHS1 (DBID=2406852607)\n\nRMAN> repair datafile 14;  \n\nStarting restore at 11-DEC-20\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=408 instance=whs11 device type=DISK\n\nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00014 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927\nchannel ORA_DISK_1: reading from backup piece \/rmanbackup\/rman0_WHS1_30_20201211\nchannel ORA_DISK_1: piece handle=\/rmanbackup\/rman0_WHS1_30_20201211 tag=LEVEL0\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:45\nFinished restore at 11-DEC-20\n\nStarting recover at 11-DEC-20\nusing channel ORA_DISK_1\n\nstarting media recovery\nmedia recovery complete, elapsed time: 00:00:00\n\nFinished recover at 11-DEC-20\n\nRMAN> <\/code><\/pre>\n
3\u3001datafile online<\/h3>\n
SQL> alter database datafile '+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927' online;\n\nDatabase altered.\n\nSQL> <\/code><\/pre>\n
\u4e8c\u3001repair pluggable database<\/h2>\n
1\u3001\u5220\u9664PDB\u7684\u6570\u636e\u6587\u4ef6<\/h3>\n
\u5173\u95edCDB<\/p>\n
srvctl stop database -d whs1<\/code><\/pre>\n
\u5220\u9664PDB\u7684\u6570\u636e\u6587\u4ef6<\/p>\n
ASMCMD> cd +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/\nASMCMD> rm USERS.278.1057318927<\/code><\/pre>\n
\u5f00\u542fcdb<\/p>\n
SQL> STARTUP<\/code><\/pre>\n
\u5f00\u542fPDB\uff0c\u62a5\u9519<\/p>\n
SQL> alter pluggable database PDB1_WHS open;\nalter pluggable database PDB1_WHS open\n*\nERROR at line 1:\nORA-01157: cannot identify\/lock data file 14 - see DBWR trace file\nORA-01110: data file 14:\n'+DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927'<\/code><\/pre>\n
2\u3001\u4fee\u6539\u6570\u636e\u5e93<\/h3>\n
[oracle@cat1 admin]$ rman target \/\n\nRecovery Manager: Release 19.0.0.0.0 - Production on Fri Dec 11 09:27:30 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: WHS1 (DBID=2406852607)\n\nRMAN> repair pluggable database PDB1_WHS;\n\nStarting restore at 11-DEC-20\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=286 instance=whs11 device type=DISK\nExecuting: alter database datafile 10 offline\nExecuting: alter database datafile 11 offline\nExecuting: alter database datafile 12 offline\nExecuting: alter database datafile 13 offline\nExecuting: alter database datafile 14 offline\n\nchannel ORA_DISK_1: starting datafile backup set restore\nchannel ORA_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_DISK_1: restoring datafile 00010 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/system.274.1057318913\nchannel ORA_DISK_1: restoring datafile 00011 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/sysaux.275.1057318911\nchannel ORA_DISK_1: restoring datafile 00012 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/undotbs1.273.1057318911\nchannel ORA_DISK_1: restoring datafile 00013 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/undo_2.277.1057318927\nchannel ORA_DISK_1: restoring datafile 00014 to +DATA1\/WHS1\/B4D31742116320ECE0532900A8C025DC\/DATAFILE\/users.278.1057318927\nchannel ORA_DISK_1: reading from backup piece \/rmanbackup\/rman0_WHS1_30_20201211\nchannel ORA_DISK_1: piece handle=\/rmanbackup\/rman0_WHS1_30_20201211 tag=LEVEL0\nchannel ORA_DISK_1: restored backup piece 1\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:45\nFinished restore at 11-DEC-20\n\nStarting recover at 11-DEC-20\nusing channel ORA_DISK_1\n\nstarting media recovery\n\narchived log for thread 1 with sequence 46 is already on disk as file +DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_1_seq_46.363.1058863555\narchived log for thread 1 with sequence 47 is already on disk as file +DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_1_seq_47.362.1058865109\narchived log for thread 1 with sequence 48 is already on disk as file +DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_1_seq_48.359.1058865961\narchived log for thread 2 with sequence 16 is already on disk as file +DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_2_seq_16.364.1058863557\narchived log for thread 2 with sequence 17 is already on disk as file +DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_2_seq_17.278.1058865957\narchived log for thread 2 with sequence 18 is already on disk as file +DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_2_seq_18.361.1058865959\narchived log for thread 2 with sequence 19 is already on disk as file +DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_2_seq_19.360.1058865959\narchived log file name=+DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_1_seq_46.363.1058863555 thread=1 sequence=46\narchived log file name=+DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_2_seq_16.364.1058863557 thread=2 sequence=16\narchived log file name=+DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_1_seq_47.362.1058865109 thread=1 sequence=47\narchived log file name=+DATA1\/WHS1\/ARCHIVELOG\/2020_12_11\/thread_2_seq_17.278.1058865957 thread=2 sequence=17\nExecuting: alter database datafile 10 online\nExecuting: alter database datafile 11 online\nExecuting: alter database datafile 12 online\nExecuting: alter database datafile 13 online\nExecuting: alter database datafile 14 online\nFinished recover at 11-DEC-20\n\nRMAN> <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
12C\u65b0\u7279\u6027repair datafile\u3001rep<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,39],"tags":[],"class_list":["post-1018","post","type-post","status-publish","format-standard","hentry","category-oracle-12c","category-39"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1018","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=1018"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1018\/revisions"}],"predecessor-version":[{"id":1022,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1018\/revisions\/1022"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1018"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}