[prev in list] [next in list] [prev in thread] [next in thread] 

List:       suse-oracle
Subject:    [suse-oracle] ORA-19527: physical standby redo log must be renamed
From:       "Sergey Yudin" <sergey () ufa ! iib ! ru>
Date:       2006-04-06 13:39:04
Message-ID: 20060406133358.M37980 () ufa ! iib ! ru
[Download RAW message or body]

How to aviod ORA-19527 error on standby database ?

alert log says:

Thu Apr  6 19:22:15 2006
ALTER DATABASE CONVERT TO PHYSICAL STANDBY
Thu Apr  6 19:22:15 2006
ALTER DATABASE CONVERT TO PHYSICAL STANDBY (CCB)
Completed: ALTER DATABASE CONVERT TO PHYSICAL STANDBY
Thu Apr  6 19:22:15 2006
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM 
SESSION
Thu Apr  6 19:22:15 2006
Attempt to start background Managed Standby Recovery process (CCB)
MRP0 started with pid=30, OS id=20478
Thu Apr  6 19:22:15 2006
MRP0: Background Managed Standby Recovery process started (CCB)
Managed Standby Recovery starting Real Time Apply
 parallel recovery started with 3 processes
Clearing online redo logfile 1 /u03/oradata/CCB/online/redo01.log
Clearing online log 1 of thread 1 sequence number 105
Thu Apr  6 19:22:20 2006
Errors in file /u01/app/oracle/admin/CCB/bdump/ccb_mrp0_20478.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/u03/oradata/CCB/online/redo01.log'
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 106
Thu Apr  6 19:22:21 2006
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE 
DISCONNECT FROM SESSION

http://www.orafaq.com/parms/parm820.htm says:

ORA-19527: physical standby redo log must be renamed
Cause: An attempt to start MTTR advisory was made, which failed because either 
FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL was specified.
Action: Set FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL to 0.

I tried to do so, but this not helped:

Thu Apr  6 19:32:03 2006
ALTER DATABASE CONVERT TO PHYSICAL STANDBY
Thu Apr  6 19:32:03 2006
ALTER DATABASE CONVERT TO PHYSICAL STANDBY (CCB)
Completed: ALTER DATABASE CONVERT TO PHYSICAL STANDBY
Thu Apr  6 19:32:03 2006
ALTER SYSTEM SET fast_start_io_target=0 SCOPE=BOTH;
Thu Apr  6 19:32:03 2006
ALTER SYSTEM SET log_checkpoint_interval=0 SCOPE=BOTH;
Thu Apr  6 19:32:03 2006
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM 
SESSION
Thu Apr  6 19:32:03 2006
Attempt to start background Managed Standby Recovery process (CCB)
MRP0 started with pid=30, OS id=20669
Thu Apr  6 19:32:03 2006
MRP0: Background Managed Standby Recovery process started (CCB)
Managed Standby Recovery starting Real Time Apply
 parallel recovery started with 3 processes
Clearing online redo logfile 1 /u03/oradata/CCB/online/redo01.log
Clearing online log 1 of thread 1 sequence number 105
Thu Apr  6 19:32:08 2006
Errors in file /u01/app/oracle/admin/CCB/bdump/ccb_mrp0_20669.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/u03/oradata/CCB/online/redo01.log'
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 106
Thu Apr  6 19:32:09 2006
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE 
DISCONNECT FROM SESSION


SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

SQL>

With best regards...


-- 
To unsubscribe, email: suse-oracle-unsubscribe@suse.com
For additional commands, email: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting

[prev in list] [next in list] [prev in thread] [next in thread]