Re: Standby Database Error

Nope u do not have to copy the online redologfiles to the standby, this has to be done only in the case of switch over from production to the standby database.
The online redos are only read when the database is getting opened it will not be read during recovery until and unless u specify the online redo log file during recovery or u specify recover database command at this moment if it has applied all the archive logs it will check the online redologs and recover complete from it.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, August 21, 2001 12:22 PM

> I was able to configure the standby database.I am not clear about the redo
> log files.Oracle
> Standby database creation dod doesn't talk of moving the redo log files.Do
> we have to move
> the redo log files from the primary database to the standby database.But
the
> standby database
> iw working fine and i open it in READ only mode to check if the data is in
> sync with the primary database
> and i found it to be good.
>
> When I give selct member from v$logfile; it lists the redo logs but
actually
> no files
> exist in that directory.
>
> Should we move the redo logs also to the standby database from the primary
> database.
>
> Thanks
> Ravindra
>
> -----Original Message-----
> Basavaraja
> Sent: Friday, August 10, 2001 6:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I am getting the following error when applying the archive files from the
> production database
> to the standby database.I just configured the standby database and was
> applying the archive
> files from production.
>
> This error appeared after processing many archive files
>
> ORA-00308: cannot open archived log
> '/u03/ora/app/admin/sentica/arch/Prod_arch_1_9823.arc'
> ORA-27046: file size is not a multiple of logical block size
> Additional information: 1
>
> What could be the problem.?
>
> Thanks
> Ravindra
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ravindra Basavaraja
> INET: ravindra_at_sentica.com
>
> 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: ListGuru_at_fatcity.com (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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ravindra Basavaraja
> INET: ravindra_at_sentica.com
>
> 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: ListGuru_at_fatcity.com (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: arunc
  INET: arun_k_c_at_hotmail.com

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: ListGuru_at_fatcity.com (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).