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: standby_archive_dest in standby DB

RE: standby_archive_dest in standby DB

From: Rahul <rahul_at_ratelindo.co.id>
Date: Wed, 6 Dec 2000 10:24:31 +0700
Message-Id: <10701.123746@fatcity.com>


Cyril,
in recovery mode, the standby DB will not generate any logs of it's own, right ?
only when i open the DB (read-write) the LOG_ARCHIVE_DEST will be used to archive the logs..
Why oracle recommends keeping the dirs same ?

> ----------
> From: Cyril Thankappan[SMTP:cyril_thank_at_rediffmail.com]
> Sent: Tuesday, December 05, 2000 2:03 PM
> To: rahul_at_ratelindo.co.id; ORACLE-L_at_fatcity.com
> Subject: Re: standby_archive_dest in standby DB
>
> Hi!
>
> Keep LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST
> different (preferably!)
>
> Regards
>
> ------------- Original Message --------------
> Rahul <rahul_at_ratelindo.co.id> wrote:
> To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> From:Rahul <rahul_at_ratelindo.co.id>
> Date:Mon, 04 Dec 2000 21:00:26 -0800
> Subject:standby_archive_dest in standby DB
>
> List, i'm about to create a standby DB in 8.1.5 (AIX),
> i have a doubt about the online redo logs of the standby,
>
> i have defined a remote destination in the primary DB
> log_archive_dest_2 = "service=STDBY OPTIONAL reopen=60"
>
> my questions are..
> 1) the logs from the primary will be copied to the dir specified
> by the param "standby_archive_dest" of the standby machine, correct ?
>
> 2) as the standby DB is also in ARCHIVELOG mode, what should be the
> "LOG_ARCHIVE_DEST" in the standby db ? same as the STANDBY_ARCHIVE_DEST" ?
>
>
> 3) my dir structure is different ( but the datafile name are same) on
> both
> machines,
> will i HAVE to use DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT ?
>
> TIA
>
> Rahul
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> 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).
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
> Participate in crazy auctions at http://auctions.rediff.com/auctions/
Received on Tue Dec 05 2000 - 21:24:31 CST

Original text of this message

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