From rgramolini@tax.state.vt.us Wed, 28 Mar 2001 07:39:33 -0800 From: "Ruth Gramolini" Date: Wed, 28 Mar 2001 07:39:33 -0800 Subject: Re: RMAN Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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" 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@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@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@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@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).