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

Thread: Rman restore

  1. #1
    Join Date
    Feb 2001
    Posts
    119
    I have done a rman offline backup of my database which was in noarchivelog mode.

    The back went successfully .

    The backup was done under the file name D:\BACKUP\DF_ORCL_1_1


    How do i restore the database in the same server ...

    I need the complete procedure to do the restore of the database in the same server..


    RMAN> list backupset of database;

    RMAN-03022: compiling command: list

    List of Backup Sets
    Key Recid Stamp LV Set Stamp Set Count Completion Time
    ------- ---------- ---------- -- ---------- ---------- ----------------------
    25 1 420861650 0 420861608 1 05-FEB-01

    List of Backup Pieces
    Key Pc# Cp# Status Completion Time Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    26 1 1 AVAILABLE 05-FEB-01 D:\BACKUP\DF_ORCL_1_1

    List of Datafiles Included
    File Name LV Type Ckp SCN Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    1 D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 0 Full 300675 05-FEB-01
    2 D:\ORACLE\ORADATA\ORCL\RBS01.DBF 0 Full 300675 05-FEB-01
    3 D:\ORACLE\ORADATA\ORCL\USERS01.DBF 0 Full 300675 05-FEB-01
    4 D:\ORACLE\ORADATA\ORCL\TEMP01.DBF 0 Full 300675 05-FEB-01
    5 D:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 0 Full 300675 05-FEB-01
    6 D:\ORACLE\ORADATA\ORCL\INDX01.DBF 0 Full 300675 05-FEB-01
    7 D:\ORACLE\ORADATA\ORCL\DR01.DBF 0 Full 300675 05-FEB-01

    RMAN>

  2. #2
    Join Date
    Nov 2000
    Posts
    245

    from rman,

    run {
    allocate channel d1 type disk;
    restore (database);
    release channel d1;
    }

  3. #3
    Join Date
    Feb 2001
    Posts
    129
    Mount the Database and then do the Rman Restore.

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