Standby Database - real time log apply, with ORA-38500 error Options

[haider]

This is oracle 10gR2. I want to implement real time application of redo logs on my physical standby db. i give following command but it failed with ora38500 error. what is wrong here..


SQL> alter database recover managed standby database using current logfile;
alter database recover managed standby database using current logfile
*
ERROR at line 1:
ORA-38500: USING CURRENT LOGFILE option not available without stand

[JGarmany]

This is oracle 10gR2. I want to implement real time application of redo logs on my physical standby db. i give following command but it failed with ora38500 error. what is wrong here..
SQL> alter database recover managed standby database using current logfile;
alter database recover managed standby database using current logfile
*
ERROR at line 1:
ORA-38500: USING CURRENT LOGFILE option not available without stand

I think the rest of the error says that you need standby redo logs on the standby database.

http://www.remote-dba.cc/10g_399.htm

http://www.dba-oracle.com/t_standby_redo_log_recovery.htm

John

[Guest_ora11g_*]

ERROR at line 1:
ORA-38500: USING CURRENT LOGFILE option not available without stand

Yes,

You need to have standby redologs in order for you to use redo apply OR sql apply using current logfile.