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
|
- RE: Trouble.. Standby Database. Urgent!! Saurabh Sharma
- RE: Trouble.. Standby Database. Urgent!! Szecsy Tamas
- Re: Trouble.. Standby Database. Urgent!! Joseph S. Testa
- RE: Trouble.. Standby Database. Urgent!! Kevin Lange