Use Oracle RMAN for tablespace-based recovery

The following articles mainly describe how to use Oracle RMAN to restore table space, we use the example case to describe Oracle RMAN recovery based on the relevant tablespace. The following describes the relevant content for your reference only:

1. view the backup file

Copy code $ rman target/

 
 

  
  
Recovery Manager: Release 10.1.0.2.0 - 64bit Production  
  
  
 
  
  
Copyright (c) 1995, 2004, Oracle. All rights reserved.  
  
  
 
  
  
connected to target database: EYGLE (DBID=1337390772)  
  
  
 
  
  
RMAN> list backup of datafile 1;  
  
  
List of Backup Sets 
  
  
===================  
  
  
BS Key Type LV Size Device Type Elapsed Time Completion Time  
  
  
------- ---- -- ---------- ----------- ------------ ---------------  
  
  
17 Full 131M DISK 00:01:50 29-MAR-05  
  
  
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20050329T065513  
  
  
Piece Name: /data5/flash_recovery_area/EYGLE/backupset/  
  
  
2005_03_29/o1_mf_nnndf_TAG20050329T065513_14k2tmx7_.bkp  
  
  
List of Datafiles in backup set 17  
  
  
File LV Type Ckp SCN Ckp Time Name  
  
  
---- -- ---- ---------- --------- ----  
 
 

1 Full 10605717 29-MAR-05/opt/oracle/oradata/eygle/system01.dbf
2. mount the database

Copy code

 
 

  
  
Oracle RMAN> startup mount;  
  
  
connected to target database (not started)  
  
  
Oracle instance started  
  
  
database mounted  
  
  
Total System Global Area 314572800 bytes  
  
  
Fixed Size 1301704 bytes  
  
  
Variable Size 261890872 bytes  
  
  
Database Buffers 50331648 bytes  
  
  
Redo Buffers 1048576 bytes 
 
 

3. Restore data files

Copy the code Oracle RMAN> restore datafile 1;
 

 
 

  
  
Starting restore at 30-MAR-05  
  
  
allocated channel: ORA_DISK_1  
  
  
channel ORA_DISK_1: sid=160 devtype=DISK 
  
  
channel ORA_DISK_1: starting datafile backupset restore  
  
  
channel ORA_DISK_1: specifying datafile(s) to restore from backup set  
  
  
restoring datafile 00001 to /opt/oracle/oradata/eygle/system01.dbf  
  
  
channel ORA_DISK_1: restored backup piece 1  
  
  
piece handle=/data5/flash_recovery_area/EYGLE/backupset/2005_03_29/  
  
  
o1_mf_nnndf_TAG20050329T065513_14k2tmx7_.bkp tag=TAG20050329T065513 
  
  
channel ORA_DISK_1: restore complete  
  
  
Finished restore at 30-MAR-05 
 
 

The above content describes the tablespace-based recovery using Oracle RMAN, hoping to help you in this regard.