【Vegas改编】RMAN Catalog建立、备份及还原实施

-- Target DB ORACLE_SID=oralin CATALOG DB ORACLE_SID=oratest

******************************************************************

1. Create catalog DB and register database.
    1.1. Connect to the catalog database and Create tablespace for the catalog:

  SQL> create tablespace RMAN_ORALIN datafile '/u01/app/oracle/oradata/oratest/RMAN_ORALIN.dbf' size 50M;

           
    1.2. Create Recovery Manager User:   

SQL> CREATE USER rmanoralin  PROFILE DEFAULT IDENTIFIED BY rmanoralin DEFAULT TABLESPACE RMAN_ORALIN TEMPORARY TABLESPACE TEMP quota unlimited on RMAN_ORALIN;

            
    1.3. Grant the role and privilege to  this user to maintain the recovery catalog and perform the backup and recovery operations.
    

 

SQL> GRANT RECOVERY_CATALOG_OWNER TO rmanoralin;
SQL> GRANT CONNECT,RESOURCE TO rmanoralin;

         
    1.4. Create catalog.

$ rman catalog rmanoralin/rmanoralin msglog=rmanoralin.log     
RMAN> create catalog tablespace RMAN_ORALIN;
RMAN> exit;

       
    1.5. Check rmanoralin.log 
   
    1.6. Log in as a user with SYSDBA priviledge on the target database tp perform all the backup and recovery operations.

$ rman target / catalog rmanoralin/rmanoralin@oratest

  Recovery Manager: Release 10.1.0.2.0 - Production

 Copyright (c) 1995, 2004, Oracle.  All rights reserved.

 connected to target database: ORALIN (DBID=34306947)
 connected to recovery catalog database
  
    
1.7. Register target database in the catalog. 

 

RMAN> register database;

 database registered in recovery catalog
 starting full resync of recovery catalog
 full resync complete

*******************************************************
2. Backup databse using RMAN catalog and incremetallevel 0;

run {
         allocate channel d1 type disk;
         backup incremental level=0  filesperset 3 format '/u01/app/oracle/oradata/oralin/backup/%d.s%s.t%t.L0'
         ( database include current controlfile);
          sql 'alter system archive log current';
          sql 'alter system archive log current';
          sql 'alter system archive log current';
          backup filesperset 3 format '/u01/app/oracle/oradata/oralin/backup/ARCH.%d.s%s.t%t'
          (archivelog all delete input);
         }

       *******************************************************************************************

3. Backup database using RMAN catalog and incremetallevel 1;

    resync catalog;
    run {
         allocate channel d1 type disk;
         backup incremental level=1  filesperset 3 format '/u01/app/oracle/oradata/oralin/backup/%d.s%s.t%t.L1'
         ( database include current controlfile);
          sql 'alter system archive log current';
          sql 'alter system archive log current';
          sql 'alter system archive log current';
          backup filesperset 3 format '/u01/app/oracle/oradata/oralin/backup/ARCH.%d.s%s.t%t'
          (archivelog all delete input);
         }

        
    *******************************************************************************************
    
4. Create script and stroe in catalog db , and use store scripts to backup.
    4.1. Create script example:       

RMAN > create script level0backup {
                 allocate channel d1 type disk;
           backup incremental level=0  filesperset 3 format '/u01/app/oracle/oradata/oralin/backup/%d.s%s.t%t.L0'
           ( database include current controlfile);
           sql 'alter system archive log current';
           sql 'alter system archive log current';
           sql 'alter system archive log current';
           backup filesperset 3 format '/u01/app/oracle/oradata/oralin/backup/ARCH.%d.s%s.t%t'
           (archivelog all delete input);
                }      

       

   
    4.2. Execute script example:        

RMAN> run { execute script level0backup;};    

  
         
    *******************************************************************************************

 

5. Restore all datafile  include control file and imcomplete recovery database.
   5.1  Connect target and catalog DB.       

$ rman target / catalog rmanoralin/rmanoralin@oratest

        
   5.2   Startup nomount target DB.     

RMAN> startup nomount;

        
   5.3  restore target DB's control files.       

RMAN> restore controlfile;

                       
   5.4   Startup mount Target DB

RMAN>  sql 'alter database mount';

        
   5.5.   Restore target data files and auto-recovery database.

RMAN> restore database;
RMAN> recover database;               
RMAN> exit

              
   5.6   Incomplete recovery and open database  resset logs.

$ sqlplus / as sysdba
SQL> recover database using backup controlfile until cancel;
SQL> alter database open resetlogs;  

                

   5.7. If using a recovery catalog , register the new incarnation of the database:

RMAN> reset database;

 

 

   *******************************************************************************************       
       
6. Restore a database to a previous incarnation.
   6.1 List the incarnation of database:

RMAN> list incarnation of database;

       
   6.2 Start the instance in the NOMOUNT state:

RMAN> startup nomount;

       
   6.3 Reset the database to the previous incarnation.

RMAN> reset database to incarnation 2;

        
   6.4 Restore the control file from the previous incarnation.    

RMAN> restore controlfile;

                    
   6.5 Mount the database.   

 

RMAN> sql 'alter database mount';

  
   6.6 Restore the database. 

RMAN> restore database;

               
   6.7 Recover the database. 

RMAN>recover database;
RMAN>exit;

              
   6.8   Incomplete recovery and open database  resset logs.      

$ sqlplus / as sysdba
SQL> recover database using backup controlfile until cancel;
SQL> alter database open resetlogs;    

              

   6.9 If using a recovery catalog , register the new incarnation of the database: 

RMAN> reset database;