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: RMAN

Re: RMAN

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 28 Mar 2001 07:39:33 -0800
Message-ID: <F001.002DA06A.20010328054051@fatcity.com>

I put mine right before I do an archivelog backup, which I do at the end of my level 0 and level 1 backups.

But if I was not doing an archivelog backup I would not even archive my current log because there would be no reason to do so,.

HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, March 27, 2001 9:25 PM

> Dear DBAs,
>
> I found this RMAN command on Oracle8i Backup Recovery documentation. This
is
> used to backup all data files and controlfiles.
>
> run {
> allocate channel ch1 type disk;
> backup database;
> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; # archives current redo log
> sql 'ALTER SYSTEM ARCHIVE LOG ALL'; # archives all un-archived redo logs
> }
>
> My question is, why they put sql commands to archives current redo log and
> unarchived redo logs, after the "backup database" command? Why not before
> the "backup database" command? Will RMAN execute it as a transaction for
all
> commands in curly bracket?
>
> TIA
>
> Yustiono
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yustiono
> INET: tekait11_at_bni.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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).
Received on Wed Mar 28 2001 - 09:39:33 CST

Original text of this message

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