DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3


  1. #1
    Join Date
    Nov 2000
    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

    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

    OCP-DBA 8.

  2. #2
    Join Date
    Apr 2002
    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.

    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):

    David Simpson
    David Simpson

  3. #3
    Join Date
    Dec 2001
    Keene, NH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width