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

Home -> Community -> Usenet -> c.d.o.tools -> Re: PLEASE HELP: ORACLE 8i STANDBY DATABASE

Re: PLEASE HELP: ORACLE 8i STANDBY DATABASE

From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Thu, 26 Jul 2001 13:07:15 +0400
Message-ID: <9jombk$4jm$1@news247.cnt.ru>

Hello!

DBA-Jim <jbizzaro_at_jackpot.com> ñîîáùèë â íîâîñòÿõ ñëåäóþùåå:d612576.0107251631.ae8dde_at_posting.google.com...
> Hello database comrades,
>
> I'm getting a strange error when I try to place an Oracle standby
> database in managed recovery mode by issuing "RECOVER MANAGED STANDBY
> DATABASE" . Please review the following sequence of events I took
> below. For some reason it tries to restore the next available log
> instead of waiting for the next one to come via the service hence
> "MANAGED" mode. Please help!
>
> I have followed the standard steps:
>
> 1) Created the Standby Datafies.
>
> 2) Created the Standby Control File.
>
> 3) Transferred the files to the standby site
>
>
> Entries in the INIT file:
>
> log_archive_start = false
>
> log_archive_dest_1 = "location=G:\Oracle\archive"
>
> standby_archive_dest = "G:\Oracle\archive"

If you want support managed standby database, you must type: log_archive_dest_2 (may be standby_archive_dest right, but I not see) = "SERVICE=YOU_STANDBY_SERVICE (other optional parameters)" Where YOU_STANDBY_SERVICE - tnsnames alias for your standby database.

Best regards!
Yaroslav.

>
> log_archive_format = ODB1_%S.ARC
>
> log_archive_trace = 100
>
>
> Sequence of events leading to error:
>
> SQL> startup nomount pfile=e:\oracle\admin\pfile\initSTANDBY.ora;
> ORACLE instance started.
>
> Total System Global Area 304280844 bytes
> Fixed Size 70924 bytes
> Variable Size 287260672 bytes
> Database Buffers 16777216 bytes
> Redo Buffers 172032 bytes
> SQL> alter database mount standby database;
>
> Database altered.
>
> SQL> Recover standby database;
> ORA-00279: change 15742701 generated at 07/25/2001 17:02:25 needed for
> thread 1
> ORA-00289: suggestion : G:\ORACLE\ARCHIVE\DB1_00105.ARC
> ORA-00280: change 15742701 for thread 1 is in sequence #105
>
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> auto
> ORA-00279: change 15742924 generated at 07/25/2001 17:08:30 needed for
> thread 1
> ORA-00289: suggestion : G:\ORACLE\ARCHIVE\DB1_00106.ARC
> ORA-00280: change 15742924 for thread 1 is in sequence #106
> ORA-00278: log file 'G:\ORACLE\ARCHIVE\DB1_00105.ARC' no longer needed
> for this recovery
>
>
> ORA-00279: change 15742926 generated at 07/25/2001 17:08:33 needed for
> thread 1
> ORA-00289: suggestion : G:\ORACLE\ARCHIVE\DB1_00107.ARC
> ORA-00280: change 15742926 for thread 1 is in sequence #107
> ORA-00278: log file 'G:\ORACLE\ARCHIVE\DB1_00106.ARC' no longer needed
> for this recovery
>
>
> ORA-00308: cannot open archived log 'G:\ORACLE\ARCHIVE\DB1_00107.ARC'
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> *********** ??????????? ***********
>
> SQL> Recover managed standby database;
> ORA-00308: cannot open archived log 'G:\ORACLE\ARCHIVE\DB1_00107.ARC'
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> *********** ??????????? ***********
>
>
>
> Thanks so much,
>
>
> JB
Received on Thu Jul 26 2001 - 04:07:15 CDT

Original text of this message

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