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

Home -> Community -> Usenet -> c.d.o.server -> Re: Standby Database - convert working standby to primary

Re: Standby Database - convert working standby to primary

From: Gump <phefford_at_gmail.com>
Date: 18 May 2006 23:27:25 -0700
Message-ID: <1148020045.345828.257990@y43g2000cwc.googlegroups.com>


More detailed instructions for the steps are as follows:

1.You can stop the shipping of logs to the standby location from primary

example:

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER; ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=''; 2.Open the standby database in read/write mode after applying all the received logs.

Alter database activate physical standby database

or

Alter database open resetlogs Received on Fri May 19 2006 - 01:27:25 CDT

Original text of this message

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