Refresh or Clone the Database

1. Check the backup successful or not on that day.

         Ram> list backup;
         Sql> v$backupset;
         $cd  /NSR/appslog

2. Check the database size in Production,file system and space availiability on Dev box.
3. Identify the control file backup in production,check the datafile, temp file and redolog locations.
4. Drop the database in Dev box, if it is already exists.

            a. Put the database in mount with restriction.
               Sql>alter system enable restrict session
            b. drop the database.

5. Start the database in “nomount”
6. Restore the control file ( which you have identify )

        Rman>run
            {
              allocate channel ch1 type sbt=‘tape’;
              allocate channel ch2 type sbt=‘tape’;
              arguments (NSR_SERVER=networker server name,
                         NSR_CLIENT=production server name,
                         NSR_POOL=pool name);
            restore control file from ‘C_DBID_DATE’;
             release ch1;
             release ch2;
          }

7. Open the database in mount, if it is not mount after restoring of control file.

 
           Sql> startup mount

8. Restore the database.

        rman>run
            {
              allocate channel ch1 type sbt=‘tape’;
              allocate channel ch2 type sbt=‘tape’;
              arguments (NSR_SERVER=networker server name,
                         NSR_CLIENT=production server name,
                         NSR_POOL=pool name);
             restore database;
             release ch1;
             release ch2;
          }

9. Restore the archive logs all

         rman>  run
               {
              allocate channel ch1 type sbt=‘tape’;
              allocate channel ch2 type sbt=‘tape’;
              arguments (NSR_SERVER=networker server name,
                         NSR_CLIENT=production server name,
                         NSR_POOL=pool name);
             restore archivelog all;
             release ch1;
             release ch2;
              }

10. Recover database using backup control file untill cancel.

        rman>recover database using backup controlfile untill cancel; 

11.Open the database with resetlogs.

       Sql> alter database open resetlog

12. Check the datafile online or not

        Sql>select file_name,status from dba_data_files;

13. Add the temp file in Dev box.

       Sql>alter tablespace temp add temfile ‘location’ size 10g;