This content has been marked as final. Show 9 replies
i have issued a RECOVER DATABASE before RESTORE DATABASE , but :
RMAN> recover database ;
Starting recover at 25-AUG-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=541 devtype=DISK
starting media recovery
unable to find archive log
archive log thread=1 sequence=2597
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of recover command at 08/25/2008 09:02:57
RMAN-06054: media recovery requesting unknown log: thread 1 seq 2597 lowscn 324447380
if i shoud determine "scn" in 'set until' , where i can find that ?
You should be doing a RESTORE before a RECOVER .
The simplest way to check log sequence numbers is to look at the alert.log file which shows the log sequence numbers when you did the backup . A RECOVER would be rolling forward from the backup until the lastest archivelog (or online redo log if available).
If you will specify set until clause it will become incomplete recovery. If that is exaclty what you need then go on otherwise you will need all archived redo logs and redo logs for complete recovery.
You can check backups first like this:
RMAN> list backup of archivelog from sequence <some_number>;
If you have backups you can kick off restore & recover process:
RMAN> restore archivelog from sequence <some_start_number>;
Now it is possible to initiate recovery.