Re: Trouble.. Standby Database. Urgent!!

has log 505 made it over to the standby yet, you should start reading the docs, if log 505 is not there yet, than that is the way its SUPPOSED to work.

joe
> Saurabh Sharma wrote:
>
> hi all,
>
> I need ur help urgently. i've created a standby database with the
> below mentioned steps..
>
> 1. copied consistent backup of datafiles folder to standby site.
> 2. created standby control file and sent to target location.
> 3. switch logfile current and copied to target.
> 4. copied init.ora and changed parameters for standby.
>
> at the standby site.
> 1. startup nomount ok
> 2. alter database mount standby database. ok
> 3. recover standby database
> ... this last recovery statement is giving lot of msgs like..log
> applied..
> then same logfile not needed for this recovery.
> can not open file..etc.
>
> I'm copying the archived log from primary to standby
> standby_archive_dest location.
> here are the actual errors..
>
> SVRMGR> recover standby database;
> ORA-00279: change 708915 generated at 06/06/01 12:19:56 needed for
> thread 1
> ORA-00289: suggestion : D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001
> ORA-00280: change 708915 for thread 1 is in sequence #505
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> auto
> ORA-00308: cannot open archived log
> 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
>
> has anybody any idea of what's causing this problem. what i feel is
> there i may have wrongly configured the standby_archive_dest in
> init.ora at standby.
>
> any help is greatly appreciated.
>
> thanks.
>
> saurabh sharma
>

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  INET: teci_at_the-testas.net

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).