RE: Trouble.. Standby Database. Urgent!!

[Szecsy Tamas]

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 AM To: Multiple recipients of list ORACLE-L Subject: 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 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