Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Trouble.. Standby Database. Urgent!!
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
Received on Wed Jun 06 2001 - 03:16:50 CDT