This content has been marked as final. Show 9 replies
Be careful, it is against Metalink's terms of service to copy material to outside sources.
Don't see much harm in that one as it is just a detailed error description as would be found in RMAN documentation if it was decent enough.
But duly noted and edited.
As this was an online backup, you should have issued a RECOVER DATABASE between the RESTORE DATABASE and OPEN RESETLOGS. I don't see a RECOVER DATABASE
(probably issued with a SET UNTIL clause as well ?)
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.
So you need to specify either "from sequence 2597" or "from scn 324447380" in your rman commands.
hi guys, i have a similar problem, in my own case, the archivelogs are missing, as in they are lost, so i cannot apply them, is there some sort of solution or the database is not recoverable...?thanks in advance for your help.