APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 34,994 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    November 2012
    M T W T F S S
    « Aug   Apr »
     1234
    567891011
    12131415161718
    19202122232425
    2627282930  
  • Archives

  • Authors

Recover Database using RMAN

Posted by appsinfo on November 22, 2012

 Oracle Database full Restore using RMAN

Scenario #: Let’s say your database is crashed due to some reason and you are not able to access the database or all data files were deleted or OS file system was restored due to crash or you attempted cloning and the clone failed and would like to restore from previous/last valid available full backup.

 Ideal Pre-Requisite: 

  • Valid full database backup available – controlfiles, datafiles, archivelogs
  • All OS file system and mounts points have been restored (LINUX or UNIX) 

Steps to Restore 

  • Create a directory on linux/unix machine  “mkdir restore” /U01/DEV/rman_backup/restore 
  • Locate the control file; we usually backup the control file in the same location along with data backup. 
  • Restore the control file

                 Connect to the database in nomount 

                $ sqlplus / as sysdba

                SQL> shutdown immediate OR shutdown abort

                SQL> startup nomount

                SQL> show parameter control_files

                SQL> exit

                $ rman target /

                …

                Connected to target database <SID> (not mounted)

                RMAN> restore controlfile from ‘/U01/DEV/rman_backup/controlfile_name.ctlbkup’; 

  • Restore the database

                                 RMAN> alter database mount;

                                RMAN> restore database;

                                RMAN> recover database;

                                RMAN> alter database open resetlogs;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: