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

Thread: RMAN RECOVERY

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


  2. #2
    Join Date
    Apr 2002
    Posts
    28
    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
    David Simpson
    www.dotcomsolutionsinc.net

  3. #3
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

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