Backup Recovery   «Prev 

Recovering Database (line mode)

  1. You have connected to both RMAN and the target database by using RMAN as the User Name, RMAN as the Password, and BACKUP as the Host String. At the RMAN prompt, you have started the script and allocated the channel (C1) to back up the database. Now restore the database by typing RESTORE DATABASE and pressing Enter.
  2. We have released the channel and closed the statement for you by adding the end bracket. Now execute the statement by pressing Enter.
  3. We have released the channel and closed the statement for you by adding the end bracket. Now execute the statement by pressing Enter.
  4. RMAN now displays the result of executing the statement. Now that the database is recovered, open it by typing 
    ALTER DATABASE OPEN
    ; and pressing Enter.
  5. Now you can see that the database has been opened. This is the end of the simulation. Click Exit.

Recovery Manager in Command-line Mode

Recovery Manager in command-line mode is an Oracle9i tool that manages backing up, restoring, and recovering files. Recovery Manager is automatically installed with Oracle Utilities. Recovery Manager uses a special PL/SQL interface to the server for invoking backup functions. This interface operates invisibly; you will interface only with a command line.
When RMAN needs to resynchronize from a read-consistent version of the control file, it creates a temporary snapshot control file. The default location of this file on Windows is ORACLE_BASE\ORACLE_HOME\database\sncfSID.ora. You must clearly understand the command-line syntax described in Oracle9i Recovery Manager Reference before using this tool. Backing up to tape requires an optional MML from a third-party vendor.