ORACLE_基础二十四(RMAN RECOVER)

Using RMAN in ARCHIVELOG

rman target sys/sys
RMAN> backup database format '/u01/app/oracle/flash_recovery_area/KING/wb_%u';    

RMAN> sql 'alter system archive log current';      //这个不是必须但是是习惯这么做   

backup incremental level 0 database  format '/u01/app/oracle/flash_recovery_area/KING/all_%U';

SQL> insert into usr1.t4 values(1,'haha')
commit;                        


backup incremental level 1 database  format '/u01/app/oracle/flash_recovery_area/KING/all_%U';     

SQL>shutdown immediate;

删除所有数据文件：
rm -f *.dbf

SQL> startup mount; 


RMAN> restore database;  

RMAN> recover database;

SQL> alter database open;

SQL> select * from usr1.t3;

Restore to a New Location

Recovery a Tablespace

RMAN Incomplete Recovery

1.Mount the database.

2.Allocate multiple chanels for parallelization

3.Restore all datafiles

4.Recover the database by using UNTIL TIME, UNTIL SEQUENCE or UNTIL SCN>

5.Open the database by using RESETLOGS

6.Perform a whole database backup.

UTIL TIME Example

UNTIL SEQUENCE Example