Oracle 12.2 ORA-01113 ORA-01110 recover after normal shutdown
Oracle Linux 7.1資料庫為Oracle 12.2.0.1 RAC，資料庫啟用了歸檔，在手動關閉資料庫後啟動資料庫時提示PDB庫有資料檔案需要進行介質恢復
[grid@jytest1 ~]$ srvctl stop database -db jy [grid@jytest1 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLE ora.CRS.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLE ora.DATA.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLE ora.FRA.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLE ora.LISTENER.lsnr ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLE ora.TEST.dg ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLE ora.chad ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLE ora.net1.network ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLE ora.ons ONLINE ONLINE jytest1 STABLE ONLINE ONLINE jytest2 STABLE ora.proxy_advm OFFLINE OFFLINE jytest1 STABLE OFFLINE OFFLINE jytest2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE jytest1 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE jytest2 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE jytest2 STABLE ora.MGMTLSNR 1 ONLINE ONLINE jytest2 169.254.237.250 88.8 8.88.2,STABLE ora.asm 1 ONLINE ONLINE jytest1 Started,STABLE 2 ONLINE ONLINE jytest2 STABLE 3 ONLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE jytest2 STABLE ora.jy.db 1 OFFLINE OFFLINE Instance Shutdown,ST ABLE 2 OFFLINE OFFLINE Instance Shutdown,ST ABLE ora.jy.jy_srv.svc 1 OFFLINE OFFLINE STABLE ora.jytest1.vip 1 ONLINE ONLINE jytest1 STABLE ora.jytest2.vip 1 ONLINE ONLINE jytest2 STABLE ora.mgmtdb 1 ONLINE ONLINE jytest2 Open,STABLE ora.qosmserver 1 ONLINE ONLINE jytest1 STABLE ora.scan1.vip 1 ONLINE ONLINE jytest1 STABLE ora.scan2.vip 1 ONLINE ONLINE jytest2 STABLE ora.scan3.vip 1 ONLINE ONLINE jytest2 STABLE --------------------------------------------------------------------------------
提示PDB的資料檔案需要進行介質恢復，檔案號是38
[grid@jytest1 ~]$ srvctl start database -db jy PRCR-1079 : Failed to start resource ora.jy.db CRS-5017: The resource action "ora.jy.db start" encountered the following error: ORA-01113: file 38 needs media recovery ORA-01110: data file 38: '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649' . For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/jytest2/crs/trace/crsd_oraagent_oracle.trc". CRS-2674: Start of 'ora.jy.db' on 'jytest2' failed CRS-5017: The resource action "ora.jy.db start" encountered the following error: ORA-01113: file 38 needs media recovery ORA-01110: data file 38: '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649' . For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/jytest1/crs/trace/crsd_oraagent_oracle.trc". CRS-2674: Start of 'ora.jy.db' on 'jytest1' failed CRS-2632: There are no more servers to try to place resource 'ora.jy.db' on that would satisfy its placement policy
對38號檔案執行介質恢復
[oracle@jytest1 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 13 17:47:55 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 8794848 bytes Variable Size 1610616096 bytes Database Buffers 520093696 bytes Redo Buffers 7979008 bytes Database mounted. ORA-01113: file 38 needs media recovery ORA-01110: data file 38: '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649' SQL> recover datafile 38; Media recovery complete.
在對38號檔案進行介質恢復後開啟CDB時提示39號檔案也需要進行介質恢復
SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 39 needs media recovery ORA-01110: data file 39: '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649'
如是執行recover database命令來對CDB進行介質恢復並開啟CDB
SQL> recover database; Media recovery complete. SQL> alter database open; Database altered.
在開啟JYPDB時提示PDB的45號檔案需要進行介質恢復
SQL> alter pluggable database jypdb open; alter pluggable database jypdb open * ERROR at line 1: ORA-01113: file 45 needs media recovery ORA-01110: data file 45: '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783'
如是對45號檔案進行介質恢復，雖然介質恢復成功但在開啟jypdb時仍然提示需要進行介質恢復
SQL> recover datafile 45; Media recovery complete. SQL> alter pluggable database jypdb open; alter pluggable database jypdb open * ERROR at line 1: ORA-01113: file 45 needs media recovery ORA-01110: data file 45: '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783'
如是查詢資料檔案檢查點SCN與資料檔案頭SCN，發現44與45號檔案的資料檔案檢查點SCN與資料檔案頭SCN號不一致並且資料檔案檢查點SCN比資料檔案頭SCN號大，因此需要進行日誌檔案來進行恢復。但在執行recover datafile命令成功後，開啟JYPDB時仍然提示需要進行介質恢復。
SQL> select FILE#, CHECKPOINT_CHANGE#,LAST_CHANGE# from v$datafile; FILE# CHECKPOINT_CHANGE# LAST_CHANGE# ---------- ------------------ ------------ 1 176117998 3 176117998 4 176117998 5 1449535 1449535 6 1449535 1449535 7 176117998 8 1449535 1449535 9 176117998 38 176098593 176098593 39 176098593 176098593 40 176098593 176098593 FILE# CHECKPOINT_CHANGE# LAST_CHANGE# ---------- ------------------ ------------ 41 176098593 176098593 42 176098593 176098593 43 176098593 176098593 44 176098593 175898322 45 176098593 175898322 46 21664676 21664676 47 21664676 21664676 48 21664676 21664676 49 21664676 21664676 50 21664676 21664676 51 21664676 21664676 22 rows selected. SQL> select FILE#,CHECKPOINT_CHANGE# from v$datafile_header; FILE# CHECKPOINT_CHANGE# ---------- ------------------ 1 176117998 3 176117998 4 176117998 5 1449535 6 1449535 7 176117998 8 1449535 9 176117998 38 176098593 39 176098593 40 176098593 FILE# CHECKPOINT_CHANGE# ---------- ------------------ 41 176098593 42 176098593 43 176098593 44 175898322 45 175898322 46 21664676 47 21664676 48 21664676 49 21664676 50 21664676 51 21664676 22 rows selected.
如是打算重建控制檔案再執行介質恢復，下面先備份控制檔案到跟蹤檔案，在跟蹤檔案中有重建控制檔案的相關命令
SQL> alter database backup controlfile to trace as '/tmp/ctl.txt'; Database altered.
關閉RAC資料庫
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down.
將RAC資料庫啟動到nomount狀態
SQL> STARTUP NOMOUNT ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 8794848 bytes Variable Size 1610616096 bytes Database Buffers 520093696 bytes Redo Buffers 7979008 bytes
重建控制檔案，提示資料庫不是排他模式，也就是說在RAC環境不能重建控制檔案
SQL> CREATE CONTROLFILE REUSE DATABASE "JY" NORESETLOGS ARCHIVELOG 2 MAXLOGFILES 192 3 MAXLOGMEMBERS 3 4 MAXDATAFILES 1024 5 MAXINSTANCES 32 6 MAXLOGHISTORY 292 7 LOGFILE 8 GROUP 1 '+DATA/JY/ONLINELOG/group_1.261.961976319' SIZE 200M BLOCKSIZE 512, 9 GROUP 2 '+DATA/JY/ONLINELOG/group_2.302.961976321' SIZE 200M BLOCKSIZE 512, 10 GROUP 3 '+DATA/JY/ONLINELOG/group_3.263.961976697' SIZE 200M BLOCKSIZE 512, 11 GROUP 4 '+DATA/JY/ONLINELOG/group_4.262.961976705' SIZE 200M BLOCKSIZE 512, 12 GROUP 6 ( 13 '+DATA/JY/ONLINELOG/group_6.280.972435899', 14 '+FRA/JY/ONLINELOG/group_6.354.972435909' 15 ) SIZE 200M BLOCKSIZE 512 16 -- STANDBY LOGFILE 17 DATAFILE 18 '+DATA/JY/DATAFILE/system.317.962209603', 19 '+DATA/JY/DATAFILE/sysaux.298.962209605', 20 '+DATA/JY/DATAFILE/undotbs1.277.962209605', 21 '+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675', 22 '+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675', 23 '+DATA/JY/DATAFILE/users.301.962209605', 24 '+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675', 25 '+DATA/JY/DATAFILE/undotbs2.312.962209605', 26 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649', 27 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649', 28 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649', 29 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649', 30 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649', 31 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609', 32 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353', 33 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783', 34 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409', 35 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409', 36 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409', 37 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409', 38 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409', 39 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409' 40 CHARACTER SET ZHS16GBK 41 ; CREATE CONTROLFILE REUSE DATABASE "JY" NORESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-12720: operation requires database is in EXCLUSIVE mode
修改資料庫為排他模式
SQL> show parameter cluster NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cdb_cluster boolean FALSE cdb_cluster_name string jy cluster_database boolean TRUE cluster_database_instances integer 2 cluster_interconnects string SQL> alter system set cluster_database=false scope=spfile sid='*'; System altered.
重啟資料庫到nomount狀態
SQL> shtudown immediate SP2-0734: unknown command beginning "shtudown i..." - rest of line ignored. SQL> shutdown immediate ORA-01507: database not mounted ORACLE instance shut down. SQL> STARTUP NOMOUNT ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 8794848 bytes Variable Size 1459621152 bytes Database Buffers 671088640 bytes Redo Buffers 7979008 bytes
重建控制檔案
SQL> CREATE CONTROLFILE REUSE DATABASE "JY" NORESETLOGS ARCHIVELOG 2 MAXLOGFILES 192 3 MAXLOGMEMBERS 3 4 MAXDATAFILES 1024 5 MAXINSTANCES 32 6 MAXLOGHISTORY 292 7 LOGFILE 8 GROUP 1 '+DATA/JY/ONLINELOG/group_1.261.961976319' SIZE 200M BLOCKSIZE 512, 9 GROUP 2 '+DATA/JY/ONLINELOG/group_2.302.961976321' SIZE 200M BLOCKSIZE 512, 10 GROUP 3 '+DATA/JY/ONLINELOG/group_3.263.961976697' SIZE 200M BLOCKSIZE 512, 11 GROUP 4 '+DATA/JY/ONLINELOG/group_4.262.961976705' SIZE 200M BLOCKSIZE 512, 12 GROUP 6 ( 13 '+DATA/JY/ONLINELOG/group_6.280.972435899', 14 '+FRA/JY/ONLINELOG/group_6.354.972435909' 15 ) SIZE 200M BLOCKSIZE 512 16 -- STANDBY LOGFILE 17 DATAFILE 18 '+DATA/JY/DATAFILE/system.317.962209603', 19 '+DATA/JY/DATAFILE/sysaux.298.962209605', 20 '+DATA/JY/DATAFILE/undotbs1.277.962209605', 21 '+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675', 22 '+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675', 23 '+DATA/JY/DATAFILE/users.301.962209605', 24 '+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675', 25 '+DATA/JY/DATAFILE/undotbs2.312.962209605', 26 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649', 27 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649', 28 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649', 29 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649', 30 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649', 31 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609', 32 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353', 33 '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783', 34 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409', 35 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409', 36 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409', 37 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409', 38 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409', 39 '+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409' 40 CHARACTER SET ZHS16GBK 41 ; Control file created.
如是查詢資料檔案檢查點SCN與資料檔案頭SCN，現在44與45號檔案的資料檔案檢查點SCN與資料檔案頭SCN號仍然不一致並且資料檔案檢查點SCN比資料檔案頭SCN號大
SQL> col name for a100 SQL> select name,checkpoint_change# from v$datafile_header; NAME CHECKPOINT_CHANGE# ---------------------------------------------------------------------------------------------------- ------------------ +DATA/JY/DATAFILE/system.317.962209603 176144167 +DATA/JY/DATAFILE/sysaux.298.962209605 176144167 +DATA/JY/DATAFILE/undotbs1.277.962209605 176144167 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675 1449535 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675 1449535 +DATA/JY/DATAFILE/users.301.962209605 176144167 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675 1449535 +DATA/JY/DATAFILE/undotbs2.312.962209605 176144167 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649 176098593 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649 176098593 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649 176098593 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649 176098593 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649 176098593 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609 176098593 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353 175898322 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783 175898322 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409 21664676 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409 21664676 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409 21664676 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409 21664676 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409 21664676 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409 21664676 22 rows selected. SQL> select name,checkpoint_change# from v$datafile; NAME CHECKPOINT_CHANGE# ---------------------------------------------------------------------------------------------------- ------------------ +DATA/JY/DATAFILE/system.317.962209603 176144167 +DATA/JY/DATAFILE/sysaux.298.962209605 176144167 +DATA/JY/DATAFILE/undotbs1.277.962209605 176144167 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675 176144167 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675 176144167 +DATA/JY/DATAFILE/users.301.962209605 176144167 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675 176144167 +DATA/JY/DATAFILE/undotbs2.312.962209605 176144167 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649 176144167 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649 176144167 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649 176144167 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649 176144167 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649 176144167 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609 176144167 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353 176144167 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783 176144167 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409 176144167 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409 176144167 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409 176144167 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409 176144167 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409 176144167 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409 176144167 22 rows selected.
對CDB執行介質恢復操作，根據提示輸入相關的歸檔日誌檔名來進行恢復並將CDB成功開啟
SQL> recover database
ORA-00279: change 175898322 generated at needed for thread 2
Specify log: {=suggested | filename | AUTO | CANCEL}
+TEST/JY/ARCHIVELOG/2019_02_13/thread_2_seq_1073.422.1000144183
ORA-00279: change 176098395 generated at 02/13/2019 17:49:43 needed for thread 2
ORA-00289: suggestion : +TEST/arch/2_1074_961976319.dbf
ORA-00280: change 176098395 for thread 2 is in sequence #1074
Specify log: {=suggested | filename | AUTO | CANCEL}
+TEST/JY/ARCHIVELOG/2019_02_13/thread_2_seq_1074.382.1000144185
ORA-00279: change 176098399 generated at 02/13/2019 17:49:45 needed for thread 2
ORA-00289: suggestion : +TEST/arch/2_1075_961976319.dbf
ORA-00280: change 176098399 for thread 2 is in sequence #1075
Specify log: {=suggested | filename | AUTO | CANCEL}
+TEST/arch/2_1075_961976319.dbf
ORA-00279: change 176098399 generated at 02/13/2019 17:49:45 needed for thread 1
ORA-00289: suggestion : +TEST/arch/1_1182_961976319.dbf
ORA-00280: change 176098399 for thread 1 is in sequence #1182
Specify log: {=suggested | filename | AUTO | CANCEL}
+TEST/arch/1_1182_961976319.dbf
ORA-00279: change 176098401 generated at 02/13/2019 17:49:45 needed for thread 2
ORA-00289: suggestion : +TEST/arch/2_1076_961976319.dbf
ORA-00280: change 176098401 for thread 2 is in sequence #1076
Specify log: {=suggested | filename | AUTO | CANCEL}
+TEST/arch/2_1076_961976319.dbf
ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE
ORA-00278: log file '+TEST/arch/2_1076_961976319.dbf' no longer needed for this recovery
ORA-00279: change 176098489 generated at 02/13/2019 17:49:50 needed for thread 1
ORA-00289: suggestion : +TEST/arch/1_1183_961976319.dbf
ORA-00280: change 176098489 for thread 1 is in sequence #1183
Specify log: {=suggested | filename | AUTO | CANCEL}
+TEST/arch/1_1183_961976319.dbf
Log applied.
Media recovery complete.
SQL> alter database open;
Database altered.
將PDB資料庫開啟
SQL> ALTER PLUGGABLE DATABASE ALL OPEN; Pluggable database altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 JYPDB READ WRITE NO
根據備份控制檔案到跟蹤檔案重建控制檔案的命令來新增臨時表空間的相關檔案
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '+DATA/JY/TEMPFILE/temp.299.961976339'; Tablespace altered. SQL> ALTER SESSION SET CONTAINER = PDB$SEED; Session altered. SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/TEMPFILE/temp.297.962209865' SIZE 67108864 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; Tablespace altered. SQL> ALTER SESSION SET CONTAINER = JYPDB; Session altered. SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/TEMPFILE/temp.276.967852391' REUSE; Tablespace altered.
將資料庫設定為叢集模式並關閉資料庫
SQL> alter system set cluster_database=true scope=spfile sid='*'; System altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down.
使用叢集命令來啟動資料庫
[grid@jytest1 ~]$ srvctl start database -db jy
將JYPDB以讀寫方式開啟
[oracle@jytest1 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 13 22:30:53 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 JYPDB MOUNTED SQL> alter pluggable database jypdb open; Pluggable database altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 JYPDB READ WRITE NO [oracle@jytest2 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 13 22:31:17 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 JYPDB MOUNTED SQL> alter pluggable database jypdb open; Pluggable database altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 JYPDB READ WRITE NO
到此資料庫的恢復操作就完成了
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26015009/viewspace-2629908/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle OCP IZ0-053 Q530(ASM Shutdown Normal)OracleASMORM
- Recover physical standby database after loss of archive log(2)DatabaseHive
- Database Startup Fails with ORA-01113, ORA-01110DatabaseAI
- ORA-01113,ORA-01110的簡單解決
- Recover database after disk loss (Doc ID 230829.1)Database
- Recover physical standby database after loss of archive log – roll forward(轉)DatabaseHiveForward
- Oracle shutdown and startupOracle
- oracle recover 原理概括Oracle
- Database Startup Fails with ORA-01113, ORA-01110 errors (Doc ID 146039.1)DatabaseAIError
- Oracle RMAN recover報錯：ORA-01547 ORA-01152 ORA-01110Oracle
- Oracle 12.2 OJVM安裝OracleJVM
- oracle shutdown 引數對比Oracle
- Oracle 12.2 建立分離JobsOracle
- oracle restore與recover的區別OracleREST
- Oracle 12.2 長識別符號Oracle符號
- Oracle Database In-Memory Certified with EBS 12.2OracleDatabase
- normal、sysdba、sysoper登陸oracle的區別理解ORMOracle
- 【Oracle】並行等待之PX Deq: Table Q NormalOracle並行ORM
- Oracle Automatic Startup and Shutdown in Linux platformOracleLinuxPlatform
- ORACLE 12.2中的更改與新功能Oracle
- Oracle 12.2 RAC on Linux Best Practice DocumentationOracleLinux
- Oracle Database 12.2本機配置ADGOracleDatabase
- Oracle 12.2 GRID的安裝方式Oracle
- oracle asm normal redundancy 模式運用於專案中OracleASMORM模式
- Oracle rman中recover和restore的區別：OracleREST
- Oracle 12c: Recover tables using RMANOracle
- Oracle 12c Recover Table New FeatureOracle
- 關於ORACLE RESTRICT模式，以及START OPEN RECOVEROracleREST模式
- 冷備手工完全恢復（recover database，recover tablespace，recover datafile）Database
- oracle truncate table recover(oracle 如何拯救誤操作truncate的表)Oracle
- Oracle 12.2之後補丁RU RUR概要Oracle
- Oracle12.2中新增的分割槽功能Oracle
- ORACLE 11G RAC 更改OCR磁碟組extenrnal 為normalOracleORM
- asm磁碟normal模式ASMORM模式
- Unable to shutdown Oracle_20091203Oracle
- Oracle 12.2 physical standby備庫收集AWR報告Oracle
- Oracle 12.2 How to Generate AWRs in Active Data Guard Standby DatabasesOracleDatabase
- 靜默安裝Oracle12.2資料庫Oracle資料庫