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@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting