Re: Restore using RMAN question

Yes, you will be able to restore and roll-forward upto the last archivelog that you have backed-up.
(provided that your backups were completed *before* you switched to NOARCHIVELOG
and "bounce"d the database).

It doesn't matter thatn you switched to NOARCHIVELOG after that.

Hemant
At 10:20 PM Sunday, J. Dex wrote:
>I am learning RMAN and I am not sure if it will be possible to do a
>restore in a particular scenario. I was doing RMAN incremental level 0
>hot backups on the database while it was in archivelogmode. In order to
>do a dataload, a backup was taken and then the database was bounced and
>restarted in noarchivelog. If I wanted to go back and do a restore only
>up to the point that the last hot backup was taken (prior to the bounce
>and the dataload), is that possible in RMAN? Or, will that now be
>impossible because the database has been running in noarchivelogmode? I
>would only want to restore up to the point where the last backup was taken
>and not up to the current state.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

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