| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN full backup Vs Incremental level 0
You have to have an incremental level 0 in order to restore you database. If you are going to do backups once daily then you should do a level 0 one the first day of your cycle and then incremental backups after that. There are many levels of incremental and you should read about them to find out which would be right for your operation. If you have time to do a level 0 each day then that would be the best way.
We used to to do a level 1 after users went home and before nightly processin and a level 0 each morning. We backup the archivlogs each time and put one days backups on tape.
HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Wednesday, February 06, 2002 4:01 PM
Hi
I would like to know what are the advantages /disadvantages of full backups
vs. incremental level 0 backups.Which one should be done if we decide to
take backups only once daily?
How is the recovery operation going to be affected if we choose either? for
e.g if i decided to do incremental level 0 backups daily ,and if recovery is
needed, then will i be able to restore the level 0 incremental and recover
till the current point in time?
Is there any other issue which would help decide whether full backups or incremental level 0 backups are better?
TIA
--
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 Thu Feb 07 2002 - 09:22:01 CST
 |
 |