RMAN procedure

[NDT]

Guys, I need a huge favor from all of the RMAN experts in here. I have a test database and a seperate catalog database. After registering the db, I used rman script to backup up the whole test db (also included the "using include controlfile" clause). As soon as the RMAN backup process done, I shut down my test database and deleted all of my current logs files, all archived files, all controlfiles and all datafiles--basically I deleted everything. My goal was to connect to RMAN and use the backup set created previously to recover all the files however the recovery was unsuccessfully. I was able to recover all of the control files and the dbfs files but I couldn't start my test db.. so I'm not sure if RMAN can recover the db based on the scenerio above...any ideas, if possible can you provide me a procedure ?? Thanks

[marist89]

Sure it can. What error messages are you getting?

[NDT]

Originally posted by marist89
Sure it can. What error messages are you getting?

This was the procedure I used to recover the whole db:

In RMAN:

1. startup nomount
2. restore controlfiles <--- successful
3. alter db mount
4. restore database <--- all dbf files recovered
5. recover database

and I got these error in step 5:

RMAN> run {
2> recover database;
3> }

RMAN-03022: compiling command: recover

RMAN-03022: compiling command: recover(1)
RMAN-03023: executing command: partial resync

RMAN-03022: compiling command: recover(2)

RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery

RMAN-03022: compiling command: recover(4)
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover(4)
RMAN-06054: media recovery requesting unknown log: thread 1 scn 323901

RMAN>


Any ideas?? Thanks

[marist89]

You've got to restore your archived log files also.

[NDT]

Originally posted by marist89
You've got to restore your archived log files also.

Still no luck, same errors as above, I did run the command 'alter system archive log current' before I backed up the log files. I notice that all the files are there (recovered) except the redo files. Btw, this is the RMAN command I used to backup the archive log files:

backup
Format....
archivelog all;

is this the command to use?? THanks


[Edited by NDT on 01-26-2002 at 07:20 PM]