| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Standby database read only problem
It simply means the standby database is not consistent. On the primary side,
create an archived log from the current log file. ALTER SYSTEM SWITCH
LOGFILE;
On the standby server, issue:
recover standby database until cancel
When it asks for the archibvbed logs, keep on applying them till you reaches the last archived log generated above. Then issue a CANCEL. The message should say, "Medical Recovery Cancel". If this does not occur, then the standby needs to be recovered completely.
After that, issue alter database open read only; it should work.
HTH. Arup
>From: Veeraraju_Mareddi <rajuveera_at_satyam.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Standby database read only problem
>Date: Sat, 17 May 2003 04:41:37 -0800
>
>Dear Gurus,
>
>Standby database is in manager recovery mode. Everything is going
>fine.Archive logs are transfered to standby , after checkpoint.
>
>Today I wanted to check my standby database, I am trying to open read only.
>its giving error. Please suggest.
>
>
>
>
>------------------------------------------------------------------------
>SVRMGR>recover managed standby database cancel;
>Media recovery complete.
>SVRMGR> alter database open read only;
>alter database open read only
>*
>ORA-16004: backup database requires recovery
>ORA-01152: file 1 was not restored from a sufficiently old backup
>ORA-01110: data file 1: 'F:\ORACLE\ORADATA\DB1\SYSTEM01.DBF'
>----------------------------------------------------------------------------
>-----------------------
>**************************************************************************
>This email (including any attachments) is intended for the sole use of the
>intended recipient/s and may contain material that is CONFIDENTIAL AND
>PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
>distribution or forwarding of any or all of the contents in this message is
>STRICTLY PROHIBITED. If you are not the intended recipient, please contact
>the sender by email and delete all copies; your cooperation in this regard
>is appreciated.
>**************************************************************************
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Veeraraju_Mareddi
> INET: rajuveera_at_satyam.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: orarup_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Sat May 17 2003 - 22:01:40 CDT
 |
 |