Re: Oracle 9iR2 backup/recovery problem

news_holger_at_yahoo.com (Klaus) wrote in message news:<981f8cae.0403312240.2528c239_at_posting.google.com>...
> Hi, i have some problems testing backup/recovery.
> Situation:
> - database is in archivelog mode.
> - i did a hot backup (rman) of the whole database and
> of the archivelogs to a disk file (controlfile
> autobackup is on).

Hi Klaus,

the database just wants to have the next archivelog because it want's to do a complete recovery. Go in sqlplus and 'recover database until cancel' and cancel the recovery. Now you should be able to open the database.
The logfiles you are missing can be found in the original database's log_archive_dest_N and you can copy them to the copy database's log_archive_dest_N to be used for recovery. since you wanted to do an incomplete recovery you should have set 'set until X' where X can be a time, seq# or whatever you want to use to mark the end point for the recovery.

Ronald.