Search This Blog

Total Pageviews

Tuesday 4 June 2013

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

 

 


Finished recover at 04-JUN-13
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/vihaan/redo01.log'

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 2 thread 1: '/u01/oracle/oradata/vihaan/redo02.log'

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/vihaan/redo03.log'

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 4 thread 0: '/u01/oracle/oradata/vihaan/stdby_redo03.log'

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 5 thread 0: '/u01/oracle/oradata/vihaan/stdby_redo02.log'

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 6 thread 0: '/u01/oracle/oradata/vihaan/stdby_redo01.log'

RMAN-05535: WARNING: All redo log files were not defined properly.
Finished Duplicate Db at 04-JUN-13







include following fake parameter LOG_FILE_NAME_CONVERT in parameter file

LOG_FILE_NAME_CONVERT=('/u01/oracle/oradata/vihaan','/u01/oracle/oradata/vihaan','/u01/oracle/oradata/vihaan','/u01/oracle/oradata/vihaan','/u01/oracle/oradata/vihaan','/u01/oracle/oradata/vihaan')


then run dulicate command

-bash-3.2$ rman target 'sys/sys@prim' auxiliary 'sys/sys@stdy'

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 4 19:32:44 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: VIHAAN (DBID=1621693558)
connected to auxiliary database: VIHAAN (not mounted)

RMAN> DUPLICATE DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;




media recovery complete, elapsed time: 00:00:03
Finished recover at 04-JUN-13
Finished Duplicate Db at 04-JUN-13 <<<<<<<<<<<<<<<<<<<<



-bash-3.2$ ls -ltr *.log
-rw-r----- 1 oracle oinstall 52429312 Jun 4 19:34 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Jun 4 19:35 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Jun 4 19:35 redo03.log
-rw-r----- 1 oracle oinstall 52429312 Jun 4 19:35 stdby_redo02.log
-rw-r----- 1 oracle oinstall 52429312 Jun 4 19:35 stdby_redo01.log
-rw-r----- 1 oracle oinstall 52429312 Jun 4 19:38 stdby_redo03.log

Oracle DBA

anuj blog Archive