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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-01113,ORA-01110的簡單解決
- Oracle 12.2 OJVM安裝OracleJVM
- ORACLE ORA-01110: ORA-27072: 處理Oracle
- Oracle 12.2 RAC on Linux Best Practice DocumentationOracleLinux
- oracle truncate table recover(oracle 如何拯救誤操作truncate的表)Oracle
- [20181220]Bushy Join Trees in Oracle 12.2.txtOracle
- ORACLE 12.2中的更改與新功能Oracle
- Oracle例項關閉：SHUTDOWN: waiting for active calls to completeOracleAI
- oracle ORA-01180 ORA-01110（rman恢復問題）Oracle
- Oracle 12.2之後補丁RU RUR概要Oracle
- oracle ORA-01189 ORA-01110（控制檔案建立報錯）Oracle
- Oracle 12.2 How to Generate AWRs in Active Data Guard Standby DatabasesOracleDatabase
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- Oracle 12.2 新特性: Online PDB relocate (PDB hot move)Oracle
- Oracle 12.2 physical standby備庫收集AWR報告Oracle
- Oracle 12.2 Heavy swapping 資料庫自動關閉OracleAPP資料庫
- Oracle 12.2中的索引統計被呼叫情況Oracle索引
- cron with recover
- 12.2
- ORA-01113異常處理_一鍵重新整理Oracle資料檔案scnOracle
- 【SSL】1209旅行(normal)ORM
- Oracle standby的ORA-01578 ORA-01110 ORA-26040 坑爹的NOLOGGINGOracle
- Oracle 12.2新特性: PDB級閃回資料庫（Flashback PDB）Oracle資料庫
- Oracle 12.2 新特性 | PDB不同字符集變更深入解析Oracle
- Oracle 12.2應用PSU後資料庫無法啟動Oracle資料庫
- Oracle 12.2 RAC修改public ip address或public ip（subnet (netmask) or interface)Oracle
- oracle12.2 adg ORA-46952: standby database format mismatch for password fileOracleDatabaseORM
- 【ASK_ORACLE】安裝Oracle RAC 12.2的GI軟體時報錯CLSRSC-614Oracle
- Oracle 19c透過recover standby database from service修復GAP案例OracleDatabase
- 3.4.3 Restoring the System to Normal OperationRESTORM
- np.random.multivariate_normal()randomORM
- Oracle 12.2 新特性：線上PDB資料庫克隆(Pluggable Hot Clone)Oracle資料庫
- Will attempt to recover by breaking constraintAI
- Oracle recover current redo ORA-00600:[4193] (oracle 故障恢復current redo日誌ORA-00600:[4193]報錯）Oracle
- Linux基礎命令---shutdownLinux
- 為ExecutorService增加shutdown hookHook
- 當心ORACLE 12.2 RAC新特性引入的BUG導致ORA-4031Oracle
- ORA-00000 normal, successful completionORM