体验跨越incarnation进行flashback database相比传统RMAN RECOVER的便捷性

最新推荐文章于 2021-11-16 16:11:39 发布
最新推荐文章于 2021-11-16 16:11:39 发布
阅读量163 收藏
点赞数
文章标签： 数据库


本文要模拟的是使用flashback database进行不同incarnation之间的flashback，将之与传统的RMAN recovery进行比较，从中感受一下flashback database高效、便捷的特点


       |-----inc3_scn1            |-----inc2_scn1
       |                                  |
---inc1_scn1-----------------inc1_scn2--------inc1_scn3

flashback and recovery时序图说明：
inc1_scn1、inc1_scn2、inc1_scn3同属于incarnation 1
inc2_scn1属于incarnation 2
inc3_scn1属于incarnation 3


前提：开启flashback database logging

操作场景：
当inc1_scn3时flashback到inc1_scn2，open resetlogs生成incarnation 2，incarnation 2前进到inc2_scn1时，执行flashback到inc1_scn1，open resetlogs生成incarnation 3，之后分别尝试flashback database和recover database两种方式从inc3_scn1回到inc2_scn1

具体操作命令如下：
<<<incarnation 1：生成inc1_scn1、inc1_scn2、inc1_scn3各时间节点的数据，从inc1_scn3 flashback到inc1_scn2，制造出incarnation 2>>>

###inc1_scn1:
backup database tag 'inc1_scn1';

alter system switch logfile;
alter system switch logfile;

create table inc1_scn1 (c1 timestamp,c2 number);
insert into inc1_scn1 values(sysdate,dbms_flashback.get_system_change_number+10);
commit;
set numwidth 16 linesize 120
select * from inc1_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.39.46.000000 PM                                                  12723361982199


###inc1_scn2:
backup database tag 'inc1_scn2';

alter system switch logfile;
alter system switch logfile;

create table inc1_scn2 (c1 timestamp,c2 number);

insert into inc1_scn2 values(sysdate,dbms_flashback.get_system_change_number+10);

set numwidth 16 linesize 120
select * from inc1_scn2;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.42.59.000000 PM                                                  12723361982600

###inc1_scn3:
backup database tag 'inc1_scn3';

alter system switch logfile;
alter system switch logfile;

create table inc1_scn3 (c1 timestamp,c2 number);
insert into inc1_scn3 values(sysdate,dbms_flashback.get_system_change_number+10);
set numwidth 16 linesize 120
select * from inc1_scn3;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.45.05.000000 PM                                                  12723361982799

shutdown immediate
startup mount

list incarnation;
using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TSTDB1   2030654775       CURRENT 12723361876275 20150501 22:23:18


set numwidth 16
col name format a50
set linesize 150
select name,checkpoint_change#,CHECKPOINT_TIME,RESETLOGS_CHANGE#,RESETLOGS_TIME from v$datafile_header;
NAME                                               CHECKPOINT_CHANGE# CHECKPOINT_TIME   RESETLOGS_CHANGE# RESETLOGS_TIME
-------------------------------------------------- ------------------ ----------------- ----------------- -----------------
/oradata06/testaaaaa/system01.dbf                      12723361983627 20150502 16:46:49    12723361876275 20150501 22:23:18
/oradata06/testaaaaa/sysaux01.dbf                      12723361983627 20150502 16:46:49    12723361876275 20150501 22:23:18
/oradata06/testaaaaa/undotbs01.dbf                     12723361983627 20150502 16:46:49    12723361876275 20150501 22:23:18
/oradata06/testaaaaa/users01.dbf                       12723361983627 20150502 16:46:49    12723361876275 20150501 22:23:18
/oradata06/testaaaaa/ts0329_1.dbf                      12723361983627 20150502 16:46:49    12723361876275 20150501 22:23:18
/oradata06/testaaaaa/xdbts1.dbf                        12723361983627 20150502 16:46:49    12723361876275 20150501 22:23:18
/oradata06/testaaaaa/ts0212.dbf                        12723357761339 20150315 09:56:23                 1 20141110 21:15:35
/oradata06/testaaaaa/ts0212_1.dbf                      12723357761339 20150315 09:56:23                 1 20141110 21:15:35
/oradata06/testaaaaa/ts0422_1.dbf                      12723361983627 20150502 16:46:49    12723361876275 20150501 22:23:18

col FLASHBACK_DATABASE_ALLOWED format a3
set linesize 150
set numwidth 15
select * from v$database_incarnation;
   INCARNATION# RESETLOGS_CHANGE# RESETLOGS_TIME    PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_T STATUS     RESETLOGS_ID PRIOR_INCARNATION# FLA
--------------- ----------------- ----------------- ----------------------- ----------------- ------- --------------- ------------------ ---
              1    12723361876275 20150501 22:23:18          12723361866362 20150501 21:07:33 CURRENT       878595798                  0 YES


flashback database to scn 12723361982600;  <--- 从inc1_scn3->inc1_scn2


***alert.log
Sat May 02 16:50:35 2015
flashback database to scn 12723361982600
Flashback Restore Start
Flashback Restore Complete
Flashback Media Recovery Start
 started logmerger process
Sat May 02 16:50:36 2015
Flashback mount Marker scn during SCN 12723361982683
Marker checkpoint scn during mount SCN 12723361982035
Marker fgda seq 1 bno 7
Flashback mount unfinished crash recovery 1
Parallel Media Recovery started with 16 slaves
Flashback unfinished crash recovery is set during start of  media recovery
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_7_1jQHi3m6Z_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_8_1jQHi7rLJ_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_9_1jQHtWhju_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_10_1jQHtWgrp_.arc
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
  Mem# 0: /oradata06/testaaaaa/redo02a.log
  Mem# 1: /oradata06/testaaaaa/redo02b.log
Incomplete Recovery applied until change 12723361982601 time 05/02/2015 16:43:22
Flashback Media Recovery Complete
Completed: flashback database to scn 12723361982600

alter database open resetlogs;    <----进入incarnation 2


***alert.log
Sat May 02 16:51:47 2015
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 12723361982601
Archived Log entry 10 added for thread 1 sequence 13 ID 0x79f2aa03 dest 1:
Archived Log entry 11 added for thread 1 sequence 11 ID 0x79f2aa03 dest 1:
Archived Log entry 12 added for thread 1 sequence 12 ID 0x79f2aa03 dest 1:
Clearing online redo logfile 1 /oradata06/testaaaaa/redo01a.log
Clearing online log 1 of thread 1 sequence number 13
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 /oradata06/testaaaaa/redo02a.log
Clearing online log 2 of thread 1 sequence number 11
Clearing online redo logfile 2 complete
Clearing online redo logfile 3 /oradata06/testaaaaa/redo03a.log
Clearing online log 3 of thread 1 sequence number 12
Clearing online redo logfile 3 complete
Resetting resetlogs activation ID 2045946371 (0x79f2aa03)
Online log /oradata06/testaaaaa/redo01a.log: Thread 1 Group 1 was previously cleared
Online log /oradata06/testaaaaa/redo01b.log: Thread 1 Group 1 was previously cleared
Online log /oradata06/testaaaaa/redo02a.log: Thread 1 Group 2 was previously cleared
Online log /oradata06/testaaaaa/redo02b.log: Thread 1 Group 2 was previously cleared
Online log /oradata06/testaaaaa/redo03a.log: Thread 1 Group 3 was previously cleared
Online log /oradata06/testaaaaa/redo03b.log: Thread 1 Group 3 was previously cleared
Sat May 02 16:51:52 2015
Setting recovery target incarnation to 2
Flashback resetlogs (SCN 12723361876275 -> SCN 12723361982602)
Sat May 02 16:51:52 2015
Assigning activation ID 2046039106 (0x79f41442)
LGWR: STARTING ARCH PROCESSES
Sat May 02 16:51:52 2015
ARC0 started with pid=24, OS id=41681260
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /oradata06/testaaaaa/redo01a.log
  Current log# 1 seq# 1 mem# 1: /oradata06/testaaaaa/redo01b.log
Successful open of redo thread 1
Sat May 02 16:51:53 2015
SMON: enabling cache recovery
Sat May 02 16:51:53 2015
ARC1 started with pid=25, OS id=5702698
Sat May 02 16:51:53 2015
ARC2 started with pid=26, OS id=10880786
Sat May 02 16:51:53 2015
ARC3 started with pid=27, OS id=1574092
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
[37093898] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:2199634163 end:2199634270 diff:107 (1 seconds)
Dictionary check beginning
File #7 is offline, but is part of an online tablespace.
data file 7: '/oradata06/testaaaaa/ts0212.dbf'
Successfuly brought file #7 online.
File #8 is offline, but is part of an online tablespace.
data file 8: '/oradata06/testaaaaa/ts0212_1.dbf'
Successfuly brought file #8 online.
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
         This condition can occur when a backup controlfile has
         been restored.  It may be necessary to add files to these
         tablespaces.  That can be done using the SQL statement:
 
         ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
 
         Alternatively, if these temporary tablespaces are no longer
         needed, then they can be dropped.
           Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sat May 02 16:51:54 2015
QMNC started with pid=29, OS id=1246314
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sat May 02 16:51:54 2015
New flashback coordinator
Sat May 02 16:51:55 2015
db_recovery_file_dest_size of 204800 MB is 5.02% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sat May 02 16:51:55 2015
Starting background process CJQ0
Sat May 02 16:51:55 2015
CJQ0 started with pid=34, OS id=41354144
Completed: alter database open resetlogs

set linesize 100
select * from inc1_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.39.46.000000 PM                                                  12723361982199


select * from inc1_scn2;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.42.59.000000 PM                                                  12723361982600

select * from inc1_scn3;
select * from inc1_scn3
              *
ERROR at line 1:
ORA-00942: table or view does not exist

list incarnation;
List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TSTDB1   2030654775       PARENT  12723361876275 20150501 22:23:18
2       2       TSTDB1   2030654775       CURRENT 12723361982602 20150502 16:51:47


set numwidth 16
col name format a50
set linesize 150
select name,checkpoint_change#,CHECKPOINT_TIME,RESETLOGS_CHANGE#,RESETLOGS_TIME from v$datafile_header;
NAME                                               CHECKPOINT_CHANGE# CHECKPOINT_TIME   RESETLOGS_CHANGE# RESETLOGS_TIME
-------------------------------------------------- ------------------ ----------------- ----------------- -----------------
/oradata06/testaaaaa/system01.dbf                      12723361982605 20150502 16:51:53    12723361982602 20150502 16:51:47
/oradata06/testaaaaa/sysaux01.dbf                      12723361982605 20150502 16:51:53    12723361982602 20150502 16:51:47
/oradata06/testaaaaa/undotbs01.dbf                     12723361982605 20150502 16:51:53    12723361982602 20150502 16:51:47
/oradata06/testaaaaa/users01.dbf                       12723361982605 20150502 16:51:53    12723361982602 20150502 16:51:47
/oradata06/testaaaaa/ts0329_1.dbf                      12723361982605 20150502 16:51:53    12723361982602 20150502 16:51:47
/oradata06/testaaaaa/xdbts1.dbf                        12723361982605 20150502 16:51:53    12723361982602 20150502 16:51:47
/oradata06/testaaaaa/ts0212.dbf                        12723357761339 20150315 09:56:23                 1 20141110 21:15:35
/oradata06/testaaaaa/ts0212_1.dbf                      12723357761339 20150315 09:56:23                 1 20141110 21:15:35
/oradata06/testaaaaa/ts0422_1.dbf                      12723361982605 20150502 16:51:53    12723361982602 20150502 16:51:47


col FLASHBACK_DATABASE_ALLOWED format a3
set linesize 150
set numwidth 15
select * from v$database_incarnation;
   INCARNATION# RESETLOGS_CHANGE# RESETLOGS_TIME    PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_T STATUS     RESETLOGS_ID PRIOR_INCARNATION# FLA
--------------- ----------------- ----------------- ----------------------- ----------------- ------- --------------- ------------------ ---
              1    12723361876275 20150501 22:23:18          12723361866362 20150501 21:07:33 PARENT        878595798                  0 YES
              2    12723361982602 20150502 16:51:47          12723361876275 20150501 22:23:18 CURRENT       878662307                  1 YES


<<<incarnation 2：生成inc2_scn1时间点的数据，从inc2_scn1 flashback到inc1_scn1，制造出incarnation 3>>>
###inc2_scn1
backup database tag 'inc2_scn1';

alter system switch logfile;
alter system switch logfile;


create table inc2_scn1 (c1 timestamp,c2 number);

insert into inc2_scn1 values(sysdate,dbms_flashback.get_system_change_number+10);
commit;
set numwidth 16 linesize 120
select * from inc2_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 05.00.02.000000 PM                                                  12723361984200


shutdown immediate;
startup mount;


flashback database to scn 12723361982199; <---从inc2_scn1->inc1_scn1，因为inc1_scn1与inc2_scn1在同一条direct ancestral path上所以可以不显式的指定" RESET DATABASE TO INCARNATION"，这一豁免仅限于flashback database操作，而不是recover database
***alert.log
Sat May 02 17:04:45 2015
flashback database to scn 12723361982199
Flashback Restore Start
Flashback Restore Complete
Flashback Media Recovery Start
Sat May 02 17:04:46 2015
Setting recovery target incarnation to 1
 started logmerger process
Sat May 02 17:04:46 2015
Flashback mount Marker scn during SCN 12723361982683
Marker checkpoint scn during mount SCN 12723361982035
Marker fgda seq 1 bno 7
Flashback mount unfinished crash recovery 1
Flashback incarnation change (SCN 12723361982602 -> SCN 12723361876275)
Parallel Media Recovery started with 16 slaves
Flashback unfinished crash recovery is set during start of  media recovery
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_7_1jQHi3m6Z_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_8_1jQHi7rLJ_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_9_1jQHtWhju_.arc
Incomplete Recovery applied until change 12723361982200 time 05/02/2015 16:40:07
Flashback Media Recovery Complete
Setting recovery target incarnation to 2
Completed: flashback database to scn 12723361982199


alter database open read only;


set linesize 100
set numwidth 16
select * from inc1_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.39.46.000000 PM                                                  12723361982199

select * from inc1_scn2;
select * from inc1_scn2
              *
ERROR at line 1:
ORA-00942: table or view does not exist

select * from inc2_scn1;
select * from inc2_scn1
              *
ERROR at line 1:
ORA-00942: table or view does not exist


---此处再演示一下如何从inc1_scn1 Flashback回到inc2_scn1;
shutdown immediate
startup mount;

flashback database to scn 12723361984200;


***alert.log
Sat May 02 17:12:51 2015
flashback database to scn 12723361984200
Flashback Restore Start
Flashback Restore Complete
Flashback Media Recovery Start
 started logmerger process
Parallel Media Recovery started with 16 slaves
Sat May 02 17:12:53 2015
Media Recovery start incarnation depth : 1, target inc# : 2, irscn : 12723361982601
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_7_1jQHi3m6Z_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_8_1jQHi7rLJ_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_9_1jQHtWhju_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_10_1jQHtWgrp_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_11_1jQIO5Ulj_.arc
Flashback mount Marker scn during SCN 12723361983987
Marker checkpoint scn during mount SCN 12723361982742
Marker fgda seq 1 bno 2785
Flashback mount unfinished crash recovery 0
Flashback incarnation change (SCN 12723361876275 -> SCN 12723361982602)
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata06/testaaaaa/redo01a.log
  Mem# 1: /oradata06/testaaaaa/redo01b.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0: /oradata06/testaaaaa/redo02a.log
  Mem# 1: /oradata06/testaaaaa/redo02b.log
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0: /oradata06/testaaaaa/redo03a.log
  Mem# 1: /oradata06/testaaaaa/redo03b.log
Incomplete Recovery applied until change 12723361984201 time 05/02/2015 17:00:03
Flashback Media Recovery Complete
Completed: flashback database to scn 12723361984200


alter database open read only;

set linesize 100
set numwidth 16

select * from inc1_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.39.46.000000 PM                                                  12723361982199


select * from inc1_scn2;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.42.59.000000 PM                                                  12723361982600


select * from inc2_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 05.00.02.000000 PM                                                  12723361984200


当然从inc1_scn1到inc2_scn1也可以使用recover database until scn 12723361984200;


---依旧回到inc1_scn1，继续下面的测试
flashback database to scn 12723361982199;    <--- inc2_scn1->inc1_scn1


alter database open resetlogs;    <----进入incarnation 3

***alert.log
Sat May 02 17:26:40 2015
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 12723361982200
Archived Log entry 21 added for thread 1 sequence 1 ID 0x79f41442 dest 1:
Archived Log entry 22 added for thread 1 sequence 2 ID 0x79f41442 dest 1:
Archived Log entry 23 added for thread 1 sequence 3 ID 0x79f41442 dest 1:
Clearing online redo logfile 1 /oradata06/testaaaaa/redo01a.log
Clearing online log 1 of thread 1 sequence number 1
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 /oradata06/testaaaaa/redo02a.log
Clearing online log 2 of thread 1 sequence number 2
Clearing online redo logfile 2 complete
Clearing online redo logfile 3 /oradata06/testaaaaa/redo03a.log
Clearing online log 3 of thread 1 sequence number 3
Clearing online redo logfile 3 complete
Resetting resetlogs activation ID 2046039106 (0x79f41442)
Online log /oradata06/testaaaaa/redo01a.log: Thread 1 Group 1 was previously cleared
Online log /oradata06/testaaaaa/redo01b.log: Thread 1 Group 1 was previously cleared
Online log /oradata06/testaaaaa/redo02a.log: Thread 1 Group 2 was previously cleared
Online log /oradata06/testaaaaa/redo02b.log: Thread 1 Group 2 was previously cleared
Online log /oradata06/testaaaaa/redo03a.log: Thread 1 Group 3 was previously cleared
Online log /oradata06/testaaaaa/redo03b.log: Thread 1 Group 3 was previously cleared
Sat May 02 17:26:45 2015
Setting recovery target incarnation to 3
Flashback resetlogs (SCN 12723361876275 -> SCN 12723361982201)
Sat May 02 17:26:45 2015
Assigning activation ID 2046030896 (0x79f3f430)
LGWR: STARTING ARCH PROCESSES
Sat May 02 17:26:46 2015
ARC0 started with pid=24, OS id=42205420
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /oradata06/testaaaaa/redo01a.log
  Current log# 1 seq# 1 mem# 1: /oradata06/testaaaaa/redo01b.log
Successful open of redo thread 1
Sat May 02 17:26:47 2015
SMON: enabling cache recovery
Sat May 02 17:26:47 2015
ARC1 started with pid=25, OS id=36635540
Sat May 02 17:26:47 2015
ARC2 started with pid=26, OS id=40698320
Sat May 02 17:26:47 2015
ARC3 started with pid=27, OS id=48628392
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
[51184380] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:2201727867 end:2201727976 diff:109 (1 seconds)
Dictionary check beginning
File #7 is offline, but is part of an online tablespace.
data file 7: '/oradata06/testaaaaa/ts0212.dbf'
Successfuly brought file #7 online.
File #8 is offline, but is part of an online tablespace.
data file 8: '/oradata06/testaaaaa/ts0212_1.dbf'
Successfuly brought file #8 online.
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
         This condition can occur when a backup controlfile has
         been restored.  It may be necessary to add files to these
         tablespaces.  That can be done using the SQL statement:
 
         ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
 
         Alternatively, if these temporary tablespaces are no longer
         needed, then they can be dropped.
           Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sat May 02 17:26:47 2015
QMNC started with pid=29, OS id=39321972
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sat May 02 17:26:48 2015
New flashback coordinator
Sat May 02 17:26:48 2015
db_recovery_file_dest_size of 204800 MB is 6.63% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sat May 02 17:26:49 2015
Starting background process CJQ0
Sat May 02 17:26:49 2015
CJQ0 started with pid=32, OS id=41681210
Completed: alter database open resetlogs


list incarnation;
List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TSTDB1   2030654775       PARENT  12723361876275 20150501 22:23:18
3       3       TSTDB1   2030654775       CURRENT 12723361982201 20150502 17:26:40
2       2       TSTDB1   2030654775       ORPHAN  12723361982602 20150502 16:51:47


set numwidth 16
col name format a50
set linesize 150
select name,checkpoint_change#,CHECKPOINT_TIME,RESETLOGS_CHANGE#,RESETLOGS_TIME from v$datafile_header;
NAME                                               CHECKPOINT_CHANGE# CHECKPOINT_TIME   RESETLOGS_CHANGE# RESETLOGS_TIME
-------------------------------------------------- ------------------ ----------------- ----------------- -----------------
/oradata06/testaaaaa/system01.dbf                      12723361982204 20150502 17:26:47    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/sysaux01.dbf                      12723361982204 20150502 17:26:47    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/undotbs01.dbf                     12723361982204 20150502 17:26:47    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/users01.dbf                       12723361982204 20150502 17:26:47    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/ts0329_1.dbf                      12723361982204 20150502 17:26:47    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/xdbts1.dbf                        12723361982204 20150502 17:26:47    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/ts0212.dbf                        12723357761339 20150315 09:56:23                 1 20141110 21:15:35
/oradata06/testaaaaa/ts0212_1.dbf                      12723357761339 20150315 09:56:23                 1 20141110 21:15:35
/oradata06/testaaaaa/ts0422_1.dbf                      12723361982204 20150502 17:26:47    12723361982201 20150502 17:26:40


col FLASHBACK_DATABASE_ALLOWED format a3
set linesize 150
set numwidth 15
select * from v$database_incarnation;
   INCARNATION# RESETLOGS_CHANGE# RESETLOGS_TIME    PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_T STATUS     RESETLOGS_ID PRIOR_INCARNATION# FLA
--------------- ----------------- ----------------- ----------------------- ----------------- ------- --------------- ------------------ ---
              1    12723361876275 20150501 22:23:18          12723361866362 20150501 21:07:33 PARENT        878595798                  0 YES
              2    12723361982602 20150502 16:51:47          12723361876275 20150501 22:23:18 ORPHAN        878662307                  1 YES
              3    12723361982201 20150502 17:26:40          12723361876275 20150501 22:23:18 CURRENT       878664400                  1 YES


<<<incarnation 3：制造出inc3_scn1点的数据，从inc3_scn1 演进到inc2_inc1(使用flashback database/recover database两种方式)>>>
###inc3_scn1：
backup database tag 'inc3_scn1';


create table inc3_scn1 (c1 timestamp,c2 number);

insert into inc3_scn1 values(sysdate,dbms_flashback.get_system_change_number+10);
commit;

set numwidth 16 linesize 120
select * from inc3_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 05.35.56.000000 PM                                                  12723361984661


shutdown immediate
startup mount

flashback database to scn 12723361984200;  <----从inc3_scn1->inc2_inc1的flashback

***alert.log
Sat May 02 17:42:20 2015
flashback database to scn 12723361984200
Flashback Restore Start
Flashback Restore Complete
Flashback Media Recovery Start
 started logmerger process
Sat May 02 17:42:21 2015
Flashback mount Marker scn during SCN 12723361984250
Marker checkpoint scn during mount SCN 12723361982336
Marker fgda seq 1 bno 8416
Flashback mount unfinished crash recovery 1
Parallel Media Recovery started with 16 slaves
Flashback unfinished crash recovery is set during start of  media recovery
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0: /oradata06/testaaaaa/redo01a.log
  Mem# 1: /oradata06/testaaaaa/redo01b.log
Incomplete Recovery applied until change 12723361984201 time 05/02/2015 17:31:57
Flashback Media Recovery Complete
Completed: flashback database to scn 12723361984200


alter database open read only;

set linesize 100
set numwidth 16

select * from inc1_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.39.46.000000 PM                                                  12723361982199

select * from inc3_scn1;
select * from inc3_scn1
              *
ERROR at line 1:
ORA-00942: table or view does not exist

select * from inc1_scn2;
select * from inc1_scn2
              *
ERROR at line 1:
ORA-00942: table or view does not exist

select * from inc2_scn1;
select * from inc2_scn1
              *
ERROR at line 1:
ORA-00942: table or view does not exist


set numwidth 16
col name format a50
set linesize 150
select name,checkpoint_change#,CHECKPOINT_TIME,RESETLOGS_CHANGE#,RESETLOGS_TIME from v$datafile_header;

NAME                                               CHECKPOINT_CHANGE# CHECKPOINT_TIME   RESETLOGS_CHANGE# RESETLOGS_TIME
-------------------------------------------------- ------------------ ----------------- ----------------- -----------------
/oradata06/testaaaaa/system01.dbf                      12723361984201 20150502 17:31:57    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/sysaux01.dbf                      12723361984201 20150502 17:31:57    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/undotbs01.dbf                     12723361984201 20150502 17:31:57    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/users01.dbf                       12723361984201 20150502 17:31:57    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/ts0329_1.dbf                      12723361984201 20150502 17:31:57    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/xdbts1.dbf                        12723361984201 20150502 17:31:57    12723361982201 20150502 17:26:40
/oradata06/testaaaaa/ts0212.dbf                        12723357761339 20150315 09:56:23                 1 20141110 21:15:35
/oradata06/testaaaaa/ts0212_1.dbf                      12723357761339 20150315 09:56:23                 1 20141110 21:15:35
/oradata06/testaaaaa/ts0422_1.dbf                      12723361984201 20150502 17:31:57    12723361982201 20150502 17:26:40


list incarnation;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TSTDB1   2030654775       PARENT  12723361876275 20150501 22:23:18
3       3       TSTDB1   2030654775       CURRENT 12723361982201 20150502 17:26:40    <---current incarnation
2       2       TSTDB1   2030654775       ORPHAN  12723361982602 20150502 16:51:47    <---incarnation 2变成了orphan


inc3_scn1、inc1_scn2、inc2_scn1表都没有记录，这是为何，因为数据库当前的incarnation=3，从当前的incarnation到祖先incarnation存在一条唯一的路径(称为direct ancestral path)，本例中就是incarnation 3->incarnation 1，在不使用reset database to incarnation ...的情况下，scn必须来自于direct ancestral path里的某个incarnation，从list incarnation的输出里可以判断目标scn=12723361984200来自于incarnation 3，inc3_scn1表创建时的scn是12723361984661>12723361984200，而inc1_scn2、inc2_scn1表所在的路径不在direct ancestral path里，所以只有inc1_scn1表能查到内容。


---reset database to incarnation 2，再尝试从inc3_scn1 flashback到inc2_inc1，这下正常了
shutdown immediate
startup mount

list incarnation;
using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TSTDB1   2030654775       PARENT  12723361876275 20150501 22:23:18
3       3       TSTDB1   2030654775       CURRENT 12723361982201 20150502 17:26:40
2       2       TSTDB1   2030654775       ORPHAN  12723361982602 20150502 16:51:47


RMAN> reset database to incarnation 2;

database reset to incarnation 2


RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TSTDB1   2030654775       PARENT  12723361876275 20150501 22:23:18
3       3       TSTDB1   2030654775       ORPHAN  12723361982201 20150502 17:26:40     <---incarnation 3变成orphan
2       2       TSTDB1   2030654775       CURRENT 12723361982602 20150502 16:51:47     <---incarnation 2变成current


flashback database to scn 12723361984200;


***alert.log
Sat May 02 18:20:36 2015
flashback database to scn 12723361984200
Flashback Restore Start
Flashback Restore Complete
Flashback Media Recovery Start
 started logmerger process
Parallel Media Recovery started with 16 slaves
Sat May 02 18:20:39 2015
Media Recovery start incarnation depth : 1, target inc# : 2, irscn : 12723361982601
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_7_1jQHi3m6Z_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_8_1jQHi7rLJ_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_9_1jQHtWhju_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_10_1jQHtWgrp_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_11_1jQIO5Ulj_.arc
Flashback mount Marker scn during SCN 12723361983987
Marker checkpoint scn during mount SCN 12723361982742
Marker fgda seq 1 bno 2785
Flashback mount unfinished crash recovery 0
Flashback incarnation change (SCN 12723361982201 -> SCN 12723361982602)
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_1_1jQKKtU5p_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_2_1jQKKtmNK_.arc
Flashback Media Recovery Log /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_3_1jQKKtsWK_.arc
Incomplete Recovery applied until change 12723361984201 time 05/02/2015 17:00:03
Flashback Media Recovery Complete
Completed: flashback database to scn 12723361984200


alter database open read only;

set linesize 100
set numwidth 16

select * from inc1_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.39.46.000000 PM                                                  12723361982199

select * from inc3_scn1;
select * from inc3_scn1
              *
ERROR at line 1:
ORA-00942: table or view does not exist


select * from inc1_scn2;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.42.59.000000 PM                                                  12723361982600


select * from inc2_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 05.00.02.000000 PM                                                  12723361984200


reset database to incarnation 3;
flashback database to scn 12723361984661;


如果我们使用recover database until scn的方式将inc3_scn1->inc2_inc1，必须把整个库从备份里恢复出来
RMAN> reset database to incarnation 2;

using target database control file instead of recovery catalog
database reset to incarnation 2

RMAN> recover database until scn 12723361984200;

Starting recover at 20150502 20:39:38
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=530 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/02/2015 20:39:39
RMAN-06556: datafile 1 must be restored from backup older than SCN 12723361984200

shutdown immediate
startup mount

reset database to incarnation 2;


--inc2_inc1时刻controlfile restore
RUN
{
  SET UNTIL scn 12723361984200;
  RESTORE CONTROLFILE to '/home/tstdb1/control.0503';
}

executing command: SET until clause

Starting restore at 20150503 04:48:39
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=530 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: restoring control file
output file name=/home/tstdb1/control.0503
channel ORA_DISK_1: reading from backup piece /oradata06/fra/TSTDB1/autobackup/2015_05_02/o1_mf_s_878662763_1jQIpIPZU_.bkp
channel ORA_DISK_1: piece handle=/oradata06/fra/TSTDB1/autobackup/2015_05_02/o1_mf_s_878662763_1jQIpIPZU_.bkp tag=TAG20150502T165923
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 20150503 04:48:41


--用刚才restore的controlfile启动实例
cp /home/tstdb1/control.0503 /oradata06/testaaaaa/control01.ctl
cp /home/tstdb1/control.0503 /oradata06/testaaaaa/control02.ctl

shutdown immediate;

startup mount;


RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TSTDB1   2030654775       PARENT  12723361876275 20150501 22:23:18
2       2       TSTDB1   2030654775       CURRENT 12723361982602 20150502 16:51:47


RMAN> list backup of database;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time 
------- ---- -- ---------- ----------- ------------ -----------------
5       Full    3.18G      DISK        00:00:38     20150502 16:39:13
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: INC1_SCN1
        Piece Name: /oradata06/fra/TSTDB1/backupset/2015_05_02/o1_mf_nnndf_INC1_SCN1_1jQHevz44_.bkp
  List of Datafiles in backup set 5
  File LV Type Ckp SCN    Ckp Time          Name
  ---- -- ---- ---------- ----------------- ----
  1       Full 12723361982084 20150502 16:38:35 /oradata06/testaaaaa/system01.dbf
  2       Full 12723361982084 20150502 16:38:35 /oradata06/testaaaaa/sysaux01.dbf
  3       Full 12723361982084 20150502 16:38:35 /oradata06/testaaaaa/undotbs01.dbf
  4       Full 12723361982084 20150502 16:38:35 /oradata06/testaaaaa/users01.dbf
  5       Full 12723361982084 20150502 16:38:35 /oradata06/testaaaaa/ts0329_1.dbf
  6       Full 12723361982084 20150502 16:38:35 /oradata06/testaaaaa/xdbts1.dbf
  7       Full 12723357761339 20150315 09:56:23 /oradata06/testaaaaa/ts0212.dbf
  8       Full 12723357761339 20150315 09:56:23 /oradata06/testaaaaa/ts0212_1.dbf
  9       Full 12723361982084 20150502 16:38:35 /oradata06/testaaaaa/ts0422_1.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time 
------- ---- -- ---------- ----------- ------------ -----------------
7       Full    3.18G      DISK        00:00:40     20150502 16:42:16
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: INC1_SCN2
        Piece Name: /oradata06/fra/TSTDB1/backupset/2015_05_02/o1_mf_nnndf_INC1_SCN2_1jQHpgOHF_.bkp
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time          Name
  ---- -- ---- ---------- ----------------- ----
  1       Full 12723361982404 20150502 16:41:36 /oradata06/testaaaaa/system01.dbf
  2       Full 12723361982404 20150502 16:41:36 /oradata06/testaaaaa/sysaux01.dbf
  3       Full 12723361982404 20150502 16:41:36 /oradata06/testaaaaa/undotbs01.dbf
  4       Full 12723361982404 20150502 16:41:36 /oradata06/testaaaaa/users01.dbf
  5       Full 12723361982404 20150502 16:41:36 /oradata06/testaaaaa/ts0329_1.dbf
  6       Full 12723361982404 20150502 16:41:36 /oradata06/testaaaaa/xdbts1.dbf
  7       Full 12723357761339 20150315 09:56:23 /oradata06/testaaaaa/ts0212.dbf
  8       Full 12723357761339 20150315 09:56:23 /oradata06/testaaaaa/ts0212_1.dbf
  9       Full 12723361982404 20150502 16:41:36 /oradata06/testaaaaa/ts0422_1.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time 
------- ---- -- ---------- ----------- ------------ -----------------
9       Full    3.18G      DISK        00:00:38     20150502 16:44:38
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: INC1_SCN3
        Piece Name: /oradata06/fra/TSTDB1/backupset/2015_05_02/o1_mf_nnndf_INC1_SCN3_1jQHyHbG9_.bkp
  List of Datafiles in backup set 9
  File LV Type Ckp SCN    Ckp Time          Name
  ---- -- ---- ---------- ----------------- ----
  1       Full 12723361982670 20150502 16:44:00 /oradata06/testaaaaa/system01.dbf
  2       Full 12723361982670 20150502 16:44:00 /oradata06/testaaaaa/sysaux01.dbf
  3       Full 12723361982670 20150502 16:44:00 /oradata06/testaaaaa/undotbs01.dbf
  4       Full 12723361982670 20150502 16:44:00 /oradata06/testaaaaa/users01.dbf
  5       Full 12723361982670 20150502 16:44:00 /oradata06/testaaaaa/ts0329_1.dbf
  6       Full 12723361982670 20150502 16:44:00 /oradata06/testaaaaa/xdbts1.dbf
  7       Full 12723357761339 20150315 09:56:23 /oradata06/testaaaaa/ts0212.dbf
  8       Full 12723357761339 20150315 09:56:23 /oradata06/testaaaaa/ts0212_1.dbf
  9       Full 12723361982670 20150502 16:44:00 /oradata06/testaaaaa/ts0422_1.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time 
------- ---- -- ---------- ----------- ------------ -----------------
12      Full    3.18G      DISK        00:00:37     20150502 16:59:14
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: INC2_SCN1
        Piece Name: /oradata06/fra/TSTDB1/backupset/2015_05_02/o1_mf_nnndf_INC2_SCN1_1jQImZJME_.bkp
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time          Name
  ---- -- ---- ---------- ----------------- ----
  1       Full 12723361984057 20150502 16:58:37 /oradata06/testaaaaa/system01.dbf
  2       Full 12723361984057 20150502 16:58:37 /oradata06/testaaaaa/sysaux01.dbf
  3       Full 12723361984057 20150502 16:58:37 /oradata06/testaaaaa/undotbs01.dbf
  4       Full 12723361984057 20150502 16:58:37 /oradata06/testaaaaa/users01.dbf
  5       Full 12723361984057 20150502 16:58:37 /oradata06/testaaaaa/ts0329_1.dbf
  6       Full 12723361984057 20150502 16:58:37 /oradata06/testaaaaa/xdbts1.dbf
  7       Full 12723357761339 20150315 09:56:23 /oradata06/testaaaaa/ts0212.dbf
  8       Full 12723357761339 20150315 09:56:23 /oradata06/testaaaaa/ts0212_1.dbf
  9       Full 12723361984057 20150502 16:58:37 /oradata06/testaaaaa/ts0422_1.dbf


reset database to incarnation 2;    <----虽然list incarnation出来incarnation 2是作为Current incarnation，但这里如果不显式的指定，restore database会从incarnation 1(tag inc1_scn1)的备份restore，结果会是incarnation 3 scn=12723361984200，或者在下面的Run block里指定from tag 'inc2_scn1'
 
RUN
{
  SET UNTIL scn 12723361984200;
  RESTORE DATABASE;
  recover DATABASE;
}

executing command: SET until clause

Starting restore at 20150503 06:09:07
Starting implicit crosscheck backup at 20150503 06:09:07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=530 device type=DISK
Crosschecked 8 objects
Finished implicit crosscheck backup at 20150503 06:09:09

Starting implicit crosscheck copy at 20150503 06:09:09
using channel ORA_DISK_1
Finished implicit crosscheck copy at 20150503 06:09:09

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /oradata06/fra/TSTDB1/archivelog/2015_05_03/o1_mf_1_1_1jQxDKL6n_.arc
File Name: /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_5_1jQGOgOJZ_.arc
File Name: /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_2_1jQIqfl7C_.arc
File Name: /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_1_1jQIqfg-3_.arc
File Name: /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_1_1jQKKtU5p_.arc
File Name: /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_2_1jQKKtmNK_.arc
File Name: /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_3_1jQKKtsWK_.arc
File Name: /oradata06/fra/TSTDB1/autobackup/2015_05_02/o1_mf_s_878662763_1jQIpIPZU_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_05_02/o1_mf_s_878664409_1jQKLPC9n_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_05_02/o1_mf_s_878664913_1jQKpTIOZ_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_04_19/o1_mf_s_877454080_1j9zc3jDi_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_04_22/o1_mf_s_877708937_1jDgyjFjO_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_04_22/o1_mf_s_877710755_1jDif8HjD_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_04_22/o1_mf_s_877725293_1jDwBd9dF_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_04_23/o1_mf_s_877756602_1jENLnnhq_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_04_23/o1_mf_s_877775813_1jEfEqN8a_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_04_23/o1_mf_s_877777253_1jEh987ia_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_04_23/o1_mf_s_877787857_1jEqSkBN4_.bkp
File Name: /oradata06/fra/TSTDB1/autobackup/2015_05_03/o1_mf_s_878706155_1jQxDgMBW_.bkp
File Name: /oradata06/fra/TSTDB1/backupset/2015_05_02/o1_mf_nnndf_INC3_SCN1_1jQKmkAOc_.bkp

using channel ORA_DISK_1

skipping datafile 7; already restored to file /oradata06/testaaaaa/ts0212.dbf
skipping datafile 8; already restored to file /oradata06/testaaaaa/ts0212_1.dbf
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /oradata06/testaaaaa/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /oradata06/testaaaaa/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oradata06/testaaaaa/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /oradata06/testaaaaa/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oradata06/testaaaaa/ts0329_1.dbf
channel ORA_DISK_1: restoring datafile 00006 to /oradata06/testaaaaa/xdbts1.dbf
channel ORA_DISK_1: restoring datafile 00009 to /oradata06/testaaaaa/ts0422_1.dbf
channel ORA_DISK_1: reading from backup piece /oradata06/fra/TSTDB1/backupset/2015_05_02/o1_mf_nnndf_INC2_SCN1_1jQImZJME_.bkp
channel ORA_DISK_1: piece handle=/oradata06/fra/TSTDB1/backupset/2015_05_02/o1_mf_nnndf_INC2_SCN1_1jQImZJME_.bkp tag=INC2_SCN1 <---inc2_scn1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 20150503 06:10:15

Starting recover at 20150503 06:10:15
using channel ORA_DISK_1
datafile 7 not processed because file is read-only
datafile 8 not processed because file is read-only

starting media recovery

archived log for thread 1 with sequence 1 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_1_1jQIqfg-3_.arc
archived log for thread 1 with sequence 2 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_2_1jQIqfl7C_.arc
archived log for thread 1 with sequence 3 is already on disk as file /oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_3_1jQKKtsWK_.arc
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_1_1jQIqfg-3_.arc thread=1 sequence=1
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_2_1jQIqfl7C_.arc thread=1 sequence=2
archived log file name=/oradata06/fra/TSTDB1/archivelog/2015_05_02/o1_mf_1_3_1jQKKtsWK_.arc thread=1 sequence=3
media recovery complete, elapsed time: 00:00:01
Finished recover at 20150503 06:10:19

alter database open read only;


SQL> select * from scott.inc1_scn1;

C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.39.46.000000 PM                                                  12723361982199

SQL> select * from scott.inc1_scn2;

C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 04.42.59.000000 PM                                                  12723361982600


SQL> select * from scott.inc2_scn1;
C1                                                                                        C2
--------------------------------------------------------------------------- ----------------
02-MAY-15 05.00.02.000000 PM                                                  12723361984200

RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TSTDB1   2030654775       PARENT  12723361876275 20150501 22:23:18
3       3       TSTDB1   2030654775       ORPHAN  12723361982201 20150502 17:26:40
2       2       TSTDB1   2030654775       CURRENT 12723361982602 20150502 16:51:47


上面的测试反映出flashback database logging打开的情况下，使用flashback Database可以在任意两个incarnation之间进行flashback，相比传统的recover database的方法灵活性更佳，效率更高

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/53956/viewspace-1775990/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/53956/viewspace-1775990/

cuiqiong6888
关注
RMAN系列（六）RMAN高级恢复
绿杨
04-08 410
原 RMAN 系列（六） ---- RMAN 高级恢复https://blog.csdn.net/tianlesoftware/article/details/5722174版权声明： https://blog.csdn.net/tianlesoftware/article/details/5722174 这几天心情不太好，这周连续加上3天班，有点累，但是不管怎样，学习不能放下，在当下的社会，要改...
Database Incarnations
彦祖的小号的博客
08-04 329
INCARNATION可以翻译为转世 在使用数据库的时间点恢复或使用备份控制文件恢复后必须使用OPEN RESETLOGS After complete recovery, you can resume normal operations without anOPEN RESETLOGS. After a DBPITR or recovery with a backup control file, however, you must open the database with theRESE...
Flashback database说明
ITer-Tony
07-19 888
一、闪回数据库依赖闪回日志 1、简介 必要条件：在MOUNT阶段        必须是归档模式下        必须设定闪回恢复区（设定db_recovery_file_dest参数），存放闪回日志，闪回日志+归档日志就可以闪回到某个阶段。        Flashback  Database 功能非常类似与RMAN的不完全恢复，它可以把整个数据库回退到过去的某个时点的状态，这个功能依
一种快速恢复数据库的方法——Flashback DB
cuicao3604的博客
12-08 179
一种快速恢复数据库的方法——Flashback DB 在工作中有同事这样的场景：在一些特定的情况下在时间点t1需要对我们的产品升级，升级需要在数据库中执行了一系列脚本，而随后我们又希望放弃本次变更，使数据库能...
ORACLE数据库PDB管理-备份与恢复
oradbm的博客
07-30 2169
1 文件结构图如下： Oracle 12c中当对指定的PDB进行不完全恢复的时候,其它的PDBS是完全不受影响的,多租户特性的好处就在于此,并且在恢复完成后老的PDB备份仍然有效,我们也不用为这个PDB创建新的备份。在实验的时候我遇到了一个小问题,就是在进行recover操作时会启动辅助实例,辅助实例则会使用到fast recovery area,如果fast recovery area的空间不够了,recover时会报错。后来手动使用AUXILIARY DESTINATION子句来为辅助实例指定一个临时
Oracle数据路pdb管理-flashback pdb
oradbm的博客
07-30 457
在Oracle Database 12.1中，闪回数据库操作仅限于CDB，从Oracle Database 12.2开始支持CDB与PDB数据库的闪回。在12.2版本新特性引入了PDB级别的flashback，更加快速方便，可以使用RMAN和SQL两种方式实现，且闪回后原PDB的备份仍然有效。 可以对多租户数据库中的单个PDB执行闪回操作。对特定的PDB执行闪回数据库操作只会修改与这个PDB相关文件中的数据。CDB中...
总结oracle flashback 特性
weixin_30299539的博客
11-06 85
Oracle 9i只能够使用flashback query。10G依然可以使用闪回查询，与9i没有变化。但flashback功能大幅强化，新增很多特性；如闪回表，闪回数据库等等。11g又增加了flashback archive ,可以提供不依靠undo的闪回功能。通过实验完成闪回功能测试，仅供参考。 10g默认启用除了闪回数据库之外的所有闪回功能，如果想打开Flashback da...
Oracle 12c RMAN全攻略
你好我是李白
11-16 2241
1. RMAN命令 12cRMAN可以执行大部分SQL命令，不需要SQL关键字。 RMAN> select open_mode from v$database; using target database control file instead of recovery catalog OPEN_MODE -------------------- READ WRITE 可以使用spool log to [destination]/spool lo
Database Point-in-Time Recovery
彦祖的小号的博客
07-27 383
DBPITR与TSPITR均为不完全恢复，本文为数据库的时间点恢复，表空间级单列了文档 Database Point-in-Time Recovery(DBPITR)is sometimes calledincomplete recoverybecause it does not use all of the available redo or completely recover all changes to your database. If unwanted database chang...
RMAN命令简介
个人公众号：Alen的数据库学习笔记
06-03 811
1、创建恢复目录 E:\>sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on 星期一 5月 29 19:37:43 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> conn / as sysdba Connect
Flashback 简介
无双小宝
10-20 826
  Flashback  原理 　　当数据 update 或 delete 时，原来的数据会保存在 undo 表空间中，保存的最少时间是 UNDO_RETENTION。实际的保存时间与 undo表空间的大小和数据更改的繁忙程度相关。 UNDO_RETENTION 的参数（单位为秒）指定 Oracle保存用于 flashback查询的 undo映像 的时间。一般你可以将这个值设为一整天（86
Recovering Tables and Table Partitions
彦祖的小号的博客
07-27 240
RMAN可以通过创建auxiliary database使用备份对表进行时间点恢复而不影响其它对象 RMAN enables you to recover one or more tables or table partitions to a specified point in time without affecting the remaining database objects. You can use previously-created RMAN backups to recover ..
oracle12c之三 控制PDB中CPU 资源使用
weixin_30681121的博客
04-24 647
CPU资源隔离 数据库中，不同的PDB对主机CPU资源使用要求不同，那么我们就可以使用CDB resourceplans来管理不同pdb对CPU资源的使用。 CDB Resource Plans PDB数量很多的情况下，使用这种CDB级别的资源计划对每个PDB进行资源限制会很麻烦。在12cR2版本中，引入了PDB Performance profile特性，来...
oracle数据库打开慢,如何诊断oracle数据库运行缓慢或hang住的问题
weixin_29531177的博客
04-02 2451
为了诊断oracle运行缓慢的问题首先要决定收集哪些诊断信息,可以采取下面的诊断方法:1.数据库运行缓慢这个问题是常见还是在特定时间出现如果数据库运行缓慢是一个常见的问题那么可以在问题出现的时候收集这个时期的awr或者statspack报告(通常收集时间间隔是一个小时).生成awr报告的方法如下:awr是通过sys用户来收集持久系统性能统计信息并且这些信息保存在sysaux表空间.缺省情况下快照是...
Oracle 12.2新特性: PDB级闪回数据库（Flashback PDB）
coco3600的博客
11-29 747
在 Oracle Database 12.1 中，闪回数据库操作仅限于 CDB ， 从 Oracle Database ...
oracle12c怎么pdb容器不会自动关闭
qq_27347147的博客
01-04 549
因为pdb容器在数据库服务器启动时是自动关闭的，所以我们要在重启oracle服务是自动加载pdb容器。我们需要编写这样一条sql语句，这条语句在我的电脑，已经我们公司都适用，如果你的不行，就再查一下吧。语句是： CREATE OR REPLACE TRIGGER open_pdbs AFTER STARTUP ON DATABASE BEGIN EXECUTE IMMEDIATE 'ALT
12C_PDB的不完整恢复
lusklusklusk的博客
09-17 913
官方文档https://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV640 point-in-time recovery (PITR) When you perform DBPITR of a PDB, all the data files for this PDB are recovered in-place. However, to recover the PDB to the specified target time, RMAN also
Oracle 12c 新特性 --- PDBs Point-in-Time Recoverys
leo__1990的博客
05-14 364
概念 You can now recover a PDB to a specific point-in-time. This feature is a high availability enhancement for consolidation and extends point-in-time recovery functionality to PDBs. 您现在可以将PDB恢复到特定的时...
Oracle RMAN工具深度指南：备份与恢复实战
这篇文档提供了一个全面的指南，帮助Oracle数据库管理员了解如何有效地使用RMAN进行备份与恢复，确保数据安全性和灾难恢复能力。通过深入理解这些步骤，用户可以在面临数据丢失或其他问题时快速、准确地采取措施，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值