Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Trouble.. Standby Database. Urgent!!

RE: Trouble.. Standby Database. Urgent!!

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 06 Jun 2001 08:17:01 -0700
Message-ID: <F001.0031E1CF.20010606071557@fatcity.com>

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 ??  "<FONT face=Courier>D:\ORACLE\ORA81\DATABASE\ARCHIVE"   It seems a straight forward error .... it can't find the file ARC00505.001 in the above directory.  
<FONT face=Courier color=#0000ff
size=2> 
It
does not say the file is corrupt or mangled in any way ..... just that it can not find it.
<FONT face=Courier color=#0000ff
size=2> 
<FONT face=Courier color=#0000ff
size=2>Definitely check the archive log destination parameter and make sure it is set to what you wanted.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Saurabh Sharma   [mailto:ssharma1_at_fcsltd.com]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.
  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
     
Received on Wed Jun 06 2001 - 10:17:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US