RE: Trouble.. Standby Database. Urgent!!
Actually there may be no problem at all. Your standby
database might be up to date, the last available archive log file has been
applied to your standby database and Oracle tried to apply the next archive log
file 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001 and did not find it, since
you did not copied it to the standby server or it does not even exist - yet - in
the primary site.
Check if the file missed by Oracle exists on the
standby site archive directory.
Actually if you use managed standby database, Oracle
can transfer the archived logs to the standby database through SQLNet and can
make the standby database applie them automatically. But you will need
Enterprise Edition Licences to do this:-((
If you move the archived log files from the primary
site to the standby manually, it can work very well too, without additional
licence fees. In this case create soma batch files for moving the files and
applying them to the standby site. The triggering of the batch files can be
achieved by OS specific scheduling commands. Actually we implemented it
this way and it's working fine for us.
HTH,
Tamas Szecsy
-Original Message-From: Saurabh Sharma
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 10:21
AMTo: Multiple recipients of list ORACLE-LSubject:
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.
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 #505Specify 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
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 nomountok
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: Trouble.. Standby Database. Urgent!!
We use
standby databases as well and our method is prety muc as yours is. So, my
biggest question is . is that the correct directory for the Archive Files
??? and did you actually copy the files to that directory ?? "D:\ORACLE\ORA81\DATABASE\ARCHIVE" It seems a straight
forward error it can't find the file ARC00505.001 in the above
directory.
It
does not say the file is corrupt or mangled in any way . just that it can
not find it.
Definitely check the archive log destination parameter and make sure it
is set to what you wanted.
-Original Message-From: Saurabh Sharma
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 3:21
AMTo: Multiple recipients of list ORACLE-LSubject:
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.
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 #505Specify 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
