Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Standby Database - real time log apply, with ORA-38500 error
haider
post Oct 3 2007, 02:10 PM
Post #1


Advanced Member
***

Group: Members
Posts: 73
Joined: 22-December 05
Member No.: 3,444



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
Go to the top of the page
 
+Quote Post
JGarmany
post Oct 3 2007, 02:19 PM
Post #2


Advanced Member
***

Group: Members
Posts: 359
Joined: 18-March 04
Member No.: 57



QUOTE (haider @ Oct 3 2007, 07:11 PM) *
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
Go to the top of the page
 
+Quote Post
Guest_ora11g_*
post Oct 8 2007, 11:18 PM
Post #3





Guests






QUOTE (haider @ Oct 3 2007, 07:11 PM) *
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.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd August 2014 - 08:32 PM