Re: RMAN and Archive log backups

Stephen wrote:
> I am struggling to find the right restore and recover syntax for RMAN
> on Oracle 9i. I am not using a recovery catalog. I am backing up to
> disk. I would be grateful for any help.
>
> I have restored my spfile, control files and datafiles. I cannot get
> rman to restore and recover archive log backups. I assume it is
> because the archive log backups were done after the control file was
> backed up. The control file I have restored predates the archive log
> backups I want to restore and recover.
>

What exactly were the commands you used on your backup? Why don't you post the script?

With 9i, if you do a backup database and use the include control file command, the control file is backed up before the database ( and archive logs ) ... so the backup doesn't have that info.

With 10.x at some point they fixed this so that control file backup is taken later and should include other missing information.

I hope this is your test database. Once you have restored the control file(s) and if you are not using a recovery catalog I don't see how you are going to get back the archive logs. If this is a production system probably you should open up a service request with oracle support right now. Received on Mon Sep 25 2006 - 08:32:10 CDT