On 1/5/06, Luc Demanche <lucdemanche@(protected)> wrote: > > Hi all, > > Here is the way I have created my standby database > On the primary site: > 1- alter tablespace ... begin backup > 2- copy the datafiles to the standby site > 3- alter tablespace ... end backup > 4- copy the redo log files > 5- alter database create standby controlfile as .... > 6- copy the standby controlfile to the standby site > > On the standby site: > 7- startup nomount > 8- alter database mount standby database > > Everything is fine. > > From the primary db > - select max(sequence#) from v$log_history = 599 > > From the standby db: > - select max(sequence#) from v$log_history = 598 > > I'm ready to apply the archived log #599 on the standby db > When I issue > - recover standby database, he ask me for the archive log #546 !!!! > > SQL> recover standby database; > ORA-00279 (See ORA-00279.ora-code.com): change 82413819 generated at 12/24/2005 23:02:55 needed for > thread 1 > ORA-00289 (See ORA-00289.ora-code.com): suggestion : G:\ARCH\PROD\PROD001546.ARC > ORA-00280 (See ORA-00280.ora-code.com): change 82413819 for thread 1 is in sequence #546 > > In my alert log file I have: > ALTER DATABASE RECOVER standby database > Wed Jan 04 15:36:36 2006 > Media Recovery Start > Starting datafile 1 recovery in thread 1 sequence 588 > Datafile 1: 'G:\ORACLE\ORADATA\STBY\SYSTEM01.DBF' > Starting datafile 2 recovery in thread 1 sequence 588 > Datafile 2: 'G:\ORACLE\ORADATA\STBY\UNDOTBS01.DBF' > Starting datafile 3 recovery in thread 1 sequence 588 > Datafile 3: 'G:\ORACLE\ORADATA\STBY\DRSYS01.DBF' > Starting datafile 4 recovery in thread 1 sequence 588 > Datafile 4: 'G:\ORACLE\ORADATA\STBY\EXAMPLE01.DBF' > Starting datafile 5 recovery in thread 1 sequence 546 > Datafile 5: 'H:\ORACLE\ORADATA\STBY\INDX01.DBF' > Starting datafile 6 recovery in thread 1 sequence 588 > Datafile 6: 'G:\ORACLE\ORADATA\STBY\ODM01.DBF' > Starting datafile 7 recovery in thread 1 sequence 546 > Datafile 7: 'H:\ORACLE\ORADATA\STBY\TOOLS01.DBF' > Starting datafile 8 recovery in thread 1 sequence 546 > Datafile 8: 'H:\ORACLE\ORADATA\STBY\USERS01.DBF' > Media Recovery Log > ORA-279 (See ORA-279.ora-code.com) signalled during: ALTER DATABASE RECOVER standby database ... > Wed Jan 04 15:40:11 2006 > ALTER DATABASE RECOVER CANCEL > The archive log with sequence 546 was created 2 weeks ago ...... > My question is: > Why he needs the archived log file #546 .... that archived log file is on > tape offsite > Even if I recreated my standby db, he always ask for that archived log > file #546 > > What can I do on the primary db ? > > Thanks > -- > Luc Demanche > Oracle DBA > (514) 867-9977 >
-- Welcome! Home: http://www.anysql.net/en/
<div>copy the two data file from primary again.</div> <div> </div> <div>Datafile 7: 'H:\ORACLE\ORADATA\STBY\TOOLS01.DBF'<br>Datafile 8: 'H:\ORACLE \ORADATA\STBY\USERS01.DBF'<br> </div> <div>The the standby will not prompt to log 546</div> <div><br><br> </div> <div><span class="gmail_quote">On 1/5/06, <b class="gmail_sendername">Luc Demanche</b> <<a href="mailto:lucdemanche@(protected)">lucdemanche@(protected)< /a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid"> <div>Hi all,</div> <div> </div> <div>Here is the way I have created my standby database</div> <div>On the primary site:</div> <div>1- alter tablespace ... begin backup</div> <div>2- copy the datafiles to the standby site</div> <div>3- alter tablespace ... end backup</div> <div>4- copy the redo log files</div> <div>5- alter database create standby controlfile as ....</div> <div>6- copy the standby controlfile to the standby site</div> <div> </div> <div>On the standby site:</div> <div>7- startup nomount</div> <div>8- alter database mount standby database</div> <div> </div> <div>Everything is fine.</div> <div> </div> <div>From the primary db</div> <div>- select max(sequence#) from v$log_history = 599</div> <div> </div> <div>From the standby db:</div> <div> <div>- select max(sequence#) from v$log_history = 598</div> <div> </div> <div>I'm ready to apply the archived log #599 on the standby db</div> <div>When I issue</div> <div>- recover standby database, he ask me for the archive log #546 !!!!</div> <div> </div> <div>SQL> recover standby database;<br>ORA-00279 (See ORA-00279.ora-code.com): change 82413819 generated at 12/24/2005 23:02:55 needed for thread 1<br>ORA-00289 (See ORA-00289.ora-code.com): suggestion : G:\ARCH \PROD\PROD001546.ARC<br>ORA-00280 (See ORA-00280.ora-code.com): change 82413819 for thread 1 is in sequence #546 </div> <div> </div> <div>In my alert log file I have:</div> <div>ALTER DATABASE RECOVER standby database <br>Wed Jan 04 15:36 :36 2006<br>Media Recovery Start<br>Starting datafile 1 recovery in thread 1 sequence 588<br>Datafile 1: 'G:\ORACLE\ORADATA\STBY\SYSTEM01.DBF'<br>Starting datafile 2 recovery in thread 1 sequence 588 <br>Datafile 2: 'G:\ORACLE\ORADATA\STBY\UNDOTBS01.DBF'<br>Starting datafile 3 recovery in thread 1 sequence 588<br>Datafile 3: 'G:\ORACLE\ORADATA\STBY \DRSYS01.DBF'<br>Starting datafile 4 recovery in thread 1 sequence 588<br> Datafile 4: 'G:\ORACLE\ORADATA\STBY\EXAMPLE01.DBF'<br>Starting datafile 5 recovery in thread 1 sequence 546<br>Datafile 5: 'H:\ORACLE\ORADATA\STBY\INDX01 .DBF'<br>Starting datafile 6 recovery in thread 1 sequence 588<br>Datafile 6: 'G :\ORACLE\ORADATA\STBY\ODM01.DBF' <br>Starting datafile 7 recovery in thread 1 sequence 546<br>Datafile 7: 'H: \ORACLE\ORADATA\STBY\TOOLS01.DBF'<br>Starting datafile 8 recovery in thread 1 sequence 546<br>Datafile 8: 'H:\ORACLE\ORADATA\STBY\USERS01.DBF'<br> Media Recovery Log <br>ORA-279 (See ORA-279.ora-code.com) signalled during: ALTER DATABASE RECOVER standby database ...<br>Wed Jan 04 15:40:11 2006<br>ALTER DATABASE RECOVER CANCEL <br clear="all"></div> <div>The archive log with sequence 546 was created 2 weeks ago ......</div> <div>My question is:</div> <div>Why he needs the archived log file #546 .... that archived log file is on tape offsite</div> <div>Even if I recreated my standby db, he always ask for that archived log file #546</div> <div> </div> <div>What can I do on the primary db ?</div> <div> </div> <div>Thanks<br>-- <br>Luc Demanche<br>Oracle DBA<br>(514) 867-9977 </div></div> </blockquote></div><br><br clear="all"><br>-- <br>Welcome!<br>Home: <a href= "http://www.anysql.net/en/">http://www.anysql.net/en/</a>
