RMAN Restoration on different Server as well as same Mount Point for Oracle APPS

Please Visit http://www.conacent.com/?page_id=218

RMAN Restoration on different Server as well as same Mount Point for Oracle APPS

1. if mount point is not same in target server change the /etc/fstab and restart the server.

2. Copy db backup file system from source server to target server as well as rman backup files.

2. Clone the database technology Stack.
    $su - oracln
    $cd $ORACLE_HOME/appsutil/clone/bin
    $perl adcfgclone.pl dbTechStack

3. Connect to RMAN utility.
    $RMAN target /

4. Startup Database to nomount state.
    RMAN>startup nomount;

5. Restore controlfile from the rman backup file system
    RMAN> restore controlfile from '/data2/rman_archive/autobackup_control_files';  [Latest control file]

6. Database need to be startup to mount state.
    RMAN> alter database mount;

7. Restore database from rman backup file.
    RMAN> restore database;  /  restore database until time "to_date('01-OCT-2012 23:45:00','dd-mon-rrrr hh24:mi:ss')";
    RMAN> recover database;  /  recover database until time "to_date('01-OCT-2012 23:45:00','dd-mon-rrrr hh24:mi:ss')";
    RMAN> alter database open resetlogs;



Please give your feedback if any thing is not correct. Your feedback is valuable.