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
 

Reply via email to