Re: FW: standby database in managed recovery mode

2001-05-04 Thread Jyoti Randive

Check the size of the archive log which it complains on primary.I have seen situation when the log has transmitted partially and the recovery comes to a standstill.
After getting all the archives properly, run a 
>recover automatic standby database;
then try to put it in managed recovery mode.
HTH.
Jyoti
 Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jyoti Randive
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


FW: standby database in managed recovery mode

2001-05-03 Thread Richard Huntley

> Suggestions anyone??  I'm attempting to get a standby database to run in
> managed recovery mode, so that the archived logs 
> are automatically applied, however, when running the command 'recover
> managed standby database' I receive the following error message:
> SVRMGR> recover managed standby database;
> ORA-00308: cannot open archived log
> '/u03/apps/oracle/admin/db/arch/1_194.arc'
> ORA-27037: unable to obtain file status
> SVR4 Error: 2: No such file or directory
> Additional information: 3
> 
> This is after I've brought the primary and standby up to the same max
> recid number in the v$log_history.  I have attempted to rebuild the
> standby database and also to execute the command 'recover standby database
> until cancel' after confirming that all archived log files were in the
> proper location, however I'm always prompted for the next archive log
> which doesn't exist yet and I can't get into "managed" recovery mode.
> I've also went to the primary database, forced a log switch and then
> applied the newest archived log file, but that hasn't worked either.  
> 
> 
> Richard Huntley
> Software Developer
> Phone: (800) 223-3732  (614) 880-1817
> E-mail: [EMAIL PROTECTED]
> MindLeaders (www.mindleaders.com)
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Huntley
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).