RE: Trouble.. Standby Database. Urgent!!

<SPAN

class=816091009-06062001>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.
<SPAN

class=816091009-06062001> 
<SPAN

class=816091009-06062001>Check if the file missed by Oracle exists on the standby site archive directory.
<SPAN

class=816091009-06062001> 
<SPAN

class=816091009-06062001>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 :-((
<SPAN

class=816091009-06062001> 
<SPAN

class=816091009-06062001>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.
<SPAN

class=816091009-06062001> 
<SPAN

class=816091009-06062001>HTH,
<SPAN

class=816091009-06062001> 
<SPAN

class=816091009-06062001>Tamas Szecsy

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Saurabh Sharma   [mailto:ssharma1_at_fcsltd.com]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.
5. startup nomount                            ok
6. alter database mount standby database.      ok
7. 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 face=Courier color=#0000ff 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