Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> FW: standby database in managed recovery mode

FW: standby database in managed recovery mode

From: Richard Huntley <rhuntley_at_mindleaders.com>
Date: Thu, 03 May 2001 09:35:32 -0700
Message-ID: <F001.002F8955.20010503092102@fatcity.com>

> 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: rhuntley_at_mindleaders.com
> MindLeaders (www.mindleaders.com)
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Huntley
  INET: rhuntley_at_mindleaders.com

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: ListGuru_at_fatcity.com (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).
Received on Thu May 03 2001 - 11:35:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US