- 28 Sep, 2023
- 0 Comments
- 2 Mins Read
Restore Missing Datafile In Standby Database Oracle 12c
Restore Missing Datafile In Standby Database Oracle 12c
Check status of primary and standby database:
1 2 3 4 5 6 7 8 9 10 11 12 13 | @PRIMARYSQL> select DB_UNIQUE_NAME,OPEN_MODE,DATABASE_ROLE from v$database;DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE------------------------------ -------------------- ----------------PRIM READ WRITE PRIMARY@ STANDBYSQL> select name,OPEN_MODE,DATABASE_ROLE from v$database;NAME OPEN_MODE DATABASE_ROLE--------- -------------------- ----------------STANDBY READ ONLY WITH APPLY PHYSICAL STANDBY |
PLEASE NOTE : All activities need to be done on standby database.
1. CANCEL THE RECOVERY( STANDBY)
1 2 | SQL> recover managed standby database cancel;Media recovery complete. |
2 . START STANDBY IN MOUNT STAGE( IF IN READ-ONLY MODE):
1 2 3 4 5 6 7 8 9 10 11 12 13 | SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started.Total System Global Area 1.3935E+10 bytesFixed Size 6002112 bytesVariable Size 4630514240 bytesDatabase Buffers 9193914368 bytesRedo Buffers 104153088 bytesDatabase mounted. |
3. RESTORE THE DATAFILE ( STANDBY)
SYNTAX – RESTORE DATAFILE < FILE_ID> FROM SERVICE < PRIMARY DB SERVICE NAME >1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | rman target /Recovery Manager: Release 12.1.0.1.0 - Production on Tue Oct 18 18:04:15 2016Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.connected to target database: STANDBY (DBID=599956155, not open)RMAN> restore datafile 4 from service PRIM;Starting restore at 18-OCT-16using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=705 device type=DISKchannel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: using network backup set from service PRIMchannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00004 to /archive/PRIM/PRIM/users01.dbfchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01Finished restore at 18-OCT-16 |
4. START THE RECOVERY ( STANDBY)
1 2 | SQL> recover managed standby database using current logfile disconnect from session;Media recovery complete. |
5. CANCEL RECOVERY AND START DATABASE.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | SQL> recover managed standby database cancel;Media recovery complete.SQL> shutdown immediate;ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1.3935E+10 bytesFixed Size 6002112 bytesVariable Size 4630514240 bytesDatabase Buffers 9193914368 bytesRedo Buffers 104153088 bytesDatabase mounted.Database opened. |
6 . START THE RECOVERY AGAIN:
1 2 3 4 5 6 7 8 9 10 11 | SQL> recover managed standby database using current logfile disconnect from session;Media recovery complete.Now all datafiles are online :SQL> select file_name from dba_data_files;FILE_NAME--------------------------------------------------------------------------------/archive/PRIM/PRIM/system01.dbf/archive/PRIM/PRIM/sysaux01.dbf/archive/PRIM/PRIM/undotbs01.dbf/archive/PRIM/PRIM/users01.dbf |