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: [Q] question about RMAN full backup?

RE: [Q] question about RMAN full backup?

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 25 May 2005 14:37:23 -0400
Message-ID: <00cb01c56158$ca9759a0$8459000a@vttaxnet.tax.state.vt.us>

Here are my commands to do a level 0 backup and backup the archivelogs then delete them. These are from OEM job which runs the backups.

run {

allocate channel Channel4 type disk format '/dbback/db_%sYOUR_DBNAME_%p';
allocate channel Channel1 type disk format '/dbback/db_%sYOUR_DBNAME_%p';
allocate channel Channel2 type disk format '/dbback/db_%sYOUR_DBNAME_%p';
allocate channel Channel3 type disk format '/dbback/db_%sYOUR_DBNAME_%p';
backup incremental level 0

   ( database include current controlfile );

backup ( archivelog all delete input );

}

HTH,
Ruth
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of dba1 mcc Sent: Wednesday, May 25, 2005 2:31 PM
To: oracle-l_at_freelists.org
Subject: [Q] question about RMAN full backup?

I look RMAN document and have some confuse about "full backup" and "incremental backup 0". Book say "full backup and incremental level 0 backup all blocks containing data" It also say "full backup can NOT be used in an incremental backup strategy".

My questions are:

  1. which RMAN command for "full baclup" and which command for "incremental level 0 backup"?
  2. If "full backup" can NOT use on incremental strategy, what purpose for "full backup"?
  3. Ramn command "backup database plus archivelog" is "full backup" or "incremental level 0 backup"?

Thanks.



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 25 2005 - 14:42:11 CDT

Original text of this message

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