获取当前scn号scn1_Oracle 基于scn号的不完全恢复

5、执行基于scn号的数据恢复。

run{

set until scn 2939682;

restore database;

recover database;

alter database open resetlogs;

}

输出日志：

[oracle@db udump]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Dec 11 16:35:51 2017

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: DB1 (DBID=1525588825, not open)

RMAN> run{

2> set until scn 2939682;

3> restore database;

4> recover database;

5> alter database open resetlogs;

6> }

executing command: SET until clause

using target database control file instead of recovery catalog

Starting restore at 11-DEC-17

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=155 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 /oracle/app/oradata/db1/system01.dbf

restoring datafile 00002 to /oracle/app/oradata/db1/undotbs01.dbf

restoring datafile 00003 to /oracle/app/oradata/db1/sysaux01.dbf

restoring datafile 00004 to /oracle/app/oradata/db1/users01.dbf

channel ORA_DISK_1: reading from backup piece /oracle/app/flash_recovery_area/DB1/backupset/2017_12_11/o1_mf_nnndf_TAG20171211T161907_f2whvvyz_.bkp

channel ORA_DISK_1: restored backup piece 1

piece handle=/oracle/app/flash_recovery_area/DB1/backupset/2017_12_11/o1_mf_nnndf_TAG20171211T161907_f2whvvyz_.bkp tag=TAG20171211T161907

channel ORA_DISK_1: restore complete, elapsed time: 00:02:25

Finished restore at 11-DEC-17

Starting recover at 11-DEC-17

using channel ORA_DISK_1

starting media recovery

media recovery complete, elapsed time: 00:00:01

Finished recover at 11-DEC-17

database opened

RMAN>