ORACLE_基础二十四(RMAN RECOVER)

Using RMAN in ARCHIVELOG

rman target sys/sysRMAN> 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 *.dbfSQL> 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