How to create log and standby log files manually in standby database after primary backup restoration
STANDBY LOGS
Get relevant details from primary side
SQL> select GROUP#,BLOCKSIZE,THREAD# from v$standby_log;
GROUP# BLOCKSIZE THREAD#
---------- ---------- ----------
9 512 1
10 512 1
11 512 1
12 512 1
13 512 1
14 512 2
15 512 2
16 512 2
17 512 2
18 512 2
10 rows selected.
GROUP# BLOCKSIZE THREAD#
---------- ---------- ----------
9 512 1
10 512 1
11 512 1
12 512 1
13 512 1
14 512 2
15 512 2
16 512 2
17 512 2
18 512 2
10 rows selected.
Remove or drop already registered files
ALTER DATABASE CLEAR LOGFILE GROUP 11;
ALTER DATABASE DROP STANDBY LOGFILE GROUP 11;
ALTER DATABASE DROP STANDBY LOGFILE GROUP 11;
Change to STANDBY_FILE_MANAGEMENT=MANUAL
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;
Add standby log files
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 11 ('/home/app/oracle/oradata/group_13.671.929171715','/data/app/oracle/oradata/CCORA12C/group_13.361.929171713') SIZE 512M;
Change to STANDBY_FILE_MANAGEMENT=AUTO
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;
LOGS
Get relevant details from primary side
SQL> select GROUP#,THREAD#,MEMBERS from v$log;
GROUP# THREAD# MEMBERS
---------- ---------- ----------
1 1 2
6 1 2
5 1 2
2 1 2
7 2 2
8 2 2
3 2 2
4 2 2
Remove or drop already registered files
ALTER DATABASE DROP LOGFILE GROUP 1;
Add log files
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 1 ('/home/app/oracle/oradata/group_1.260.926202925','/home/app/oracle/oradata//group_1.347.926202923') SIZE 512M;
Comments