Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Solutions › Topic Id: 2692 | Permalink

avoid ORA-19527 set dummy log_file_name_convert

Topic ID: 2692
Created By: 2007-OCT-08 15:20:09 [Vitaliy]
Updated By: 2007-OCT-08 15:20:09 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
8409
2007-OCT-08 15:20:09
Moderator
 
 
Registered On: Mar 2006
Total Posts: 303
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