avoid ORA-19527 set dummy log_file_name_convert
|
8409
2007-OCT-08 15:20:09
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 191
|
|
You created new standby database using hotbackup script and did not create
online REDO logs. You are now trying to enable "Managed Standby Recovery" using
the following command:
alter database recover managed standby database using current logfile disconnect;
the following errors are reported in the alert log file:
Fri Oct 5 19:17:54 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_3941.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/u01/oradata/10GR2/redo01.log'
Clearing online redo logfile 1 complete
Here's a sample of complete error stack from the alert log:
MRP0: Background Managed Standby Recovery process started (10GR2)
Managed Standby Recovery starting Real Time Apply
parallel recovery started with 2 processes
Fri Oct 5 19:17:54 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_3941.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u03/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u02/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Fri Oct 5 19:17:54 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_3941.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u03/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u02/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 /u01/oradata/10GR2/redo01.log
Clearing online log 1 of thread 1 sequence number 40
Fri Oct 5 19:17:54 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_3941.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u03/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u02/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Fri Oct 5 19:17:54 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_3941.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/u01/oradata/10GR2/redo01.log'
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 42 (in transit)
Fri Oct 5 19:17:54 2007
Recovery of Online Redo Log: Thread 1 Group 4 Seq 42 Reading mem 0
Mem# 0: /u01/oradata/10GR2/stby04.log
Mem# 1: /u02/oradata/10GR2/stby04.log
Mem# 2: /u03/oradata/10GR2/stby04.log
Fri Oct 5 19:17:55 2007
Completed: alter database recover managed standby database using current logfile disconnect
SOLUTION
---------
Set DUMMY log_file_name_convert even if your standby database file structure
is exactly the same as your primary database:
SQL> alter system set log_file_name_convert='junk','junk' scope=spfile;
System altered.
SQL>
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 2029880 bytes
Variable Size 213911240 bytes
Database Buffers 109051904 bytes
Redo Buffers 2162688 bytes
Database mounted.
SQL>
SQL>
SQL>
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
SQL> !ls -l /u03/oradata/10GR2/redo03.log
-rw-r----- 1 oracle dba 52429312 Oct 8 15:12 /u03/oradata/10GR2/redo03.log
SQL>
NOTE that this time ORACLE still reported the following errors in the alert
log but it was able to clear them so next time you will not see any errors:
Mon Oct 8 15:12:29 2007
alter database recover managed standby database using current logfile disconnect
Mon Oct 8 15:12:29 2007
Attempt to start background Managed Standby Recovery process (10GR2)
MRP0 started with pid=18, OS id=4913
Mon Oct 8 15:12:29 2007
MRP0: Background Managed Standby Recovery process started (10GR2)
Managed Standby Recovery starting Real Time Apply
parallel recovery started with 2 processes
Mon Oct 8 15:12:35 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_4913.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u03/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u02/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Mon Oct 8 15:12:35 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_4913.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u03/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u02/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 /u01/oradata/10GR2/redo01.log
Clearing online log 1 of thread 1 sequence number 43
Mon Oct 8 15:12:35 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_4913.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u03/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u02/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/oradata/10GR2/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Mon Oct 8 15:12:35 2007
Completed: alter database recover managed standby database using current logfile disconnect
Mon Oct 8 15:12:40 2007
Clearing online redo logfile 1 complete
Mon Oct 8 15:12:40 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_4913.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u03/oradata/10GR2/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u02/oradata/10GR2/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/oradata/10GR2/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Mon Oct 8 15:12:40 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_4913.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u03/oradata/10GR2/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u02/oradata/10GR2/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/oradata/10GR2/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 /u01/oradata/10GR2/redo02.log
Clearing online log 2 of thread 1 sequence number 41
Mon Oct 8 15:12:40 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_4913.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u03/oradata/10GR2/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u02/oradata/10GR2/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/oradata/10GR2/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 complete
Mon Oct 8 15:12:45 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_4913.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u03/oradata/10GR2/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/u02/oradata/10GR2/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/u01/oradata/10GR2/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Mon Oct 8 15:12:45 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_4913.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u03/oradata/10GR2/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/u02/oradata/10GR2/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/u01/oradata/10GR2/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 /u01/oradata/10GR2/redo03.log
Clearing online log 3 of thread 1 sequence number 42
Mon Oct 8 15:12:45 2007
Errors in file /u01/app/oracle/admin/10GR2/bdump/10gr2_mrp0_4913.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u03/oradata/10GR2/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/u02/oradata/10GR2/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/u01/oradata/10GR2/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 complete
Mon Oct 8 15:12:49 2007
Recovery of Online Redo Log: Thread 1 Group 5 Seq 43 Reading mem 0
Mem# 0: /u01/oradata/10GR2/stby05.log
Mem# 1: /u02/oradata/10GR2/stby05.log
Mem# 2: /u03/oradata/10GR2/stby05.log
If you shutdown immediate and restart managed recovery there will be no errors
in the alert log - here's an example:
Mon Oct 8 15:22:12 2007
alter database recover managed standby database using current logfile disconnect
Mon Oct 8 15:22:12 2007
Attempt to start background Managed Standby Recovery process (10GR2)
MRP0 started with pid=18, OS id=4957
Mon Oct 8 15:22:12 2007
MRP0: Background Managed Standby Recovery process started (10GR2)
Managed Standby Recovery starting Real Time Apply
parallel recovery started with 2 processes
Mon Oct 8 15:22:17 2007
Recovery of Online Redo Log: Thread 1 Group 5 Seq 43 Reading mem 0
Mem# 0: /u01/oradata/10GR2/stby05.log
Mem# 1: /u02/oradata/10GR2/stby05.log
Mem# 2: /u03/oradata/10GR2/stby05.log
Mon Oct 8 15:22:18 2007
Completed: alter database recover managed standby database using current logfile disconnect