Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Recovery Manager and Media Management software

Recovery Manager and Media Management software

From: <cemail_at_sprintmail.com>
Date: Tue, 29 Aug 2000 15:35:11 -0700
Message-Id: <10603.115795@fatcity.com>


I am confused about how Recovery Manager works with Media Management software.

I am using Recovery Manager with Recovery Catalog and Veritos.  Suppose I am running hot backups and then shut down the database and do a cold backup. Then I want to do a test restore from a hot backup, how can I know that what is put back on disk is from the hot backup and not the cold backup?

To do the hot backup, I am doing something like this:

Run {
Allocate channel t1 type ‘SBT_TAPE’;
  Backup full

      Fileperset 2
      Format ‘RIGNS_full.%n.%s.%p’
      (database);

To restore the database, I want to do something like this:

Run {
  Allocate channel t1 type ‘SBT_TAPE’;
   Allocate channel d1 type disk;

   Restore controlfile to
‘/disk1/oradata/RIGNS/control01.ctl

    replicate controlfile

             from ‘disk1/oradata/RIGNS/control01.ctl’;     sql ‘alter database mount’;
    restore (database);

       recover database;
    sql ‘alter database open’;
    }



Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! Received on Tue Aug 29 2000 - 17:35:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US