From ssharma1@fcsltd.com Wed, 06 Jun 2001 01:16:50 -0700
From: "Saurabh Sharma" <ssharma1@fcsltd.com>
Date: Wed, 06 Jun 2001 01:16:50 -0700
Subject: Trouble.. Standby Database. Urgent!!
Message-ID: <F001.0031D772.20010606002038@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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.
<FONT color=#0000ff face=Courier 
size=2>here are the actual errors..
 
SVRMGR> recover standby 
database;ORA-00279: change 708915 generated at 06/06/01 12:19:56 needed for 
thread 1ORA-00289: suggestion : 
D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-00280: change 708915 for 
thread 1 is in sequence #505 Specify log: {<RET>=suggested | 
filename | AUTO | CANCEL}autoORA-00308: cannot open archived log 
'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-27041: unable to open 
fileOSD-04002: unable to open fileO/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