基于scn的恢复是怎样的

今天就跟大家聊聊有关基于scn的恢复是怎样的，可能很多人都不太了解，为了让大家更加了解，小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。

--先背备份：（热备）[oracle@wang ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 8 19:35:11 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: DBDB (DBID=3282897732)RMAN> backup database;Starting backup at 08-DEC-17using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=44 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00004 name=/u01/app/oracle/oradata/DBdb/users01.dbfinput datafile file number=00006 name=/u01/app/oracle/fast_recovery_area/DBDB/newback/ts_xxf_01.dbfinput datafile file number=00001 name=/u01/app/oracle/oradata/DBdb/system01.dbfinput datafile file number=00003 name=/u01/app/oracle/oradata/DBdb/undotbs01.dbfchannel ORA_DISK_1: starting piece 1 at 08-DEC-17channel ORA_DISK_1: finished piece 1 at 08-DEC-17piece handle=/u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_nnndf_TAG20171208T193949_f2nyj5gy_.bkp tag=TAG20171208T193949 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:55channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00002 name=/u01/app/oracle/oradata/DBdb/sysaux01.dbfinput datafile file number=00005 name=/u01/app/oracle/oradata/DBdb/example01.dbfchannel ORA_DISK_1: starting piece 1 at 08-DEC-17 channel ORA_DISK_1: finished piece 1 at 08-DEC-17piece handle=/u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_nnndf_TAG20171208T193949_f2nykwl2_.bkp tag=TAG20171208T193949 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:25channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setincluding current control file in backup setincluding current SPFILE in backup setchannel ORA_DISK_1: starting piece 1 at 08-DEC-17channel ORA_DISK_1: finished piece 1 at 08-DEC-17piece handle=/u01/app/oracle/fast_recovery_area/DBDB/newback/DBDB/backupset/2017_12_08/o1_mf_ncsnf_TAG20171208T193949_f2nylpqk_.bkp tag=TAG20171208T193949 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 08-DEC-17RMAN>     二、模拟操作：SQL> select current_scn from v$database;CURRENT_SCN-----------    3960846SQL>  SQL> create table scott.scn_a as select * from dba_objects;Table created.SQL> select count(*) from scott.scn_a;  COUNT(*)----------     87053SQL> select current_scn from v$database;CURRENT_SCN-----------    3960968SQL> SQL> create table hr.scn_b as select * from dba_objects;Table created.SQL> select count(*) from hr.scn_b;  COUNT(*)----------     87054SQL> select current_scn from v$database;CURRENT_SCN-----------    3961042SQL>        SQL> alter system switch logfile;System altered.SQL> SQL> select current_scn from v$database;CURRENT_SCN-----------    3961063SQL> SQL> alter system checkpoint;System altered.SQL> SQL> select current_scn from v$database;CURRENT_SCN-----------    3961088--删除表scn_a/scn_b:SQL> drop table scott.scn_a purge;Table dropped.SQL> drop table hr.scn_b purge;

Table dropped.

看完上述内容，你们对基于scn的恢复是怎样的有进一步的了解吗？如果还想了解更多知识或者相关内容，请关注行业资讯频道，感谢大家的支持。