Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9iR2 backup/recovery problem

Re: Oracle 9iR2 backup/recovery problem

From: Ronald Rood <devnull_at_ronr.nl>
Date: 2 Apr 2004 06:44:21 -0800
Message-ID: <67ce88e7.0404020644.677ed085@posting.google.com>


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.



http://ronr.nl/unix-dba Received on Fri Apr 02 2004 - 08:44:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US