Previous Topic: Oracle Recovery Manager Restore

Next Topic: Restore to a Particular Point in Time

Connect to Recovery Manager and Restore

You can use the following procedure to connect to recovery manager.

To connect to Recovery Manager at the command line and restore database objects

  1. Log in on the computer on which the option is running. Use a user ID with administrator privileges.
  2. From the Windows Start button menu, start a command prompt session.
  3. Enter the following command:
    rman nocatalog
    

    The Recovery Manager starts in the command prompt window, and the command line prompt becomes RMAN>.

  4. Enter the following commands to back up the database instance named test.

    Note: In the following command, the @instance_name parameter is required only if you have multiple database instances.

    connect target system/manager@test
    RMAN> run {
    

    The program provides numbered prompts for each of the following entries:

    2> allocate channel dev1 type 'sbt_tape';
    3> restore database;
    4> release channel dev1;
    5> }
    

    The restore begins and the progress of the restore is displayed in the command prompt session. When the restore is complete, you can continue to work with RMAN, or you can exit the command prompt session.