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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).