RMAN RECOVERY

[gandhi]

HI RMAN Gurus,

I have a tablespace called Ts. I had a table T in Ts. I deleted all the records in T.

I am doing the complete recovery. I had a good backup(with 1000 rows). After applying Backup from the Tape, i do the Roll Forward operation.

RMAN says I/O error. Do i need to copy the archive backup from Tape to Archive destination and do the Recovery or what?

The following is the scenario during Recovery:

RMAN> run {
2> allocate channel c1 type 'SBT_TAPE'
3> parms 'ENV=(NSR_SERVER=rs6000,NSR_DATA_VOLUME_POOL=Default)';
4> restore database;
5> recover database;
6> }

allocated channel: c1
channel c1: sid=12 devtype=SBT_TAPE
channel c1: MMS Version 2.2.0.1

Starting restore at 01-MAY-02

channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /gloqm/oradata/ORA9011/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 05/01/2002 13:37:49
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10038: database session for channel c1 terminated unexpectedly



Thanks in Advance


Gandhi
OCP-DBA 8.

[dsimpson]

Basically you need to make sure that the backup files created by RMAN are in the location where they were located when the backup was completed. If RMAN put them onto disk, then this is where you need to have them in order to perform the restore.

I have an application named Installgen which automates creating backup/recovery scripts along with creating the documentation for performing 15 different database recovery scenarios.

I have detailed instructions for handling this scenario on my website. You can view this info online via the following link, then scroll down to Recovery Scenario #8.
http://www.dotcomsolutionsinc.net/pr...very_scenarios

If it is more convenient, you may also download a demo of the Installgen application which produced this file (along with a whole set of backup, recovery and documentation files):
http://www.dotcomsolutionsinc.net/do...are/index.html

David Simpson
http://www.dotcomsolutionsinc.net

[gopi]

David,

I cannot get
http://www.dotcomsolutionsinc.net/pr...very_scenarios

it takes you right back to:

http://www.dotcomsolutionsinc.net/index.html