RMAN

From: Yustiono <tekait11_at_bni.co.id>
Date: Tue, 27 Mar 2001 19:03:48 -0800
Message-ID: <F001.002D9A72.20010327182544@fatcity.com>

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). Received on Tue Mar 27 2001 - 21:03:48 CST