controlfile作为RMAN的repository时,对 keep time 的测试
4月2日,首先查看系统状况:
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 2
control_files string /u01/app/oracle/oradata/orcl/c
ontrol01.ctl, /u01/app/oracle/
flash_recovery_area/orcl/contr
ol02.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
SQL>
*********************************************************************
此时,查看备份状态:
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Apr 2 08:29:05 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1369869147)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> configure retention policy to recovery window of 1 days;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
new RMAN configuration parameters are successfully stored
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 1.05G DISK 00:02:01 01-APR-14
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20140401T172802
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_01/o1_mf_nnndf_TAG20140401T172802_9mo1o2g2_.bkp
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 9.36M DISK 00:00:05 01-APR-14
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20140401T172802
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_01/o1_mf_ncsnf_TAG20140401T172802_9mo1s2ky_.bkp
SPFILE Included: Modification time: 01-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1002728 Ckp time: 01-APR-14
再看RMAN的设定变化:
再看RMAN的设定:
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN>
在4月2日执行backup后再看:
RMAN> backup database;
Starting backup at 02-APR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=29 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 02-APR-14
channel ORA_DISK_1: finished piece 1 at 02-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_nnndf_TAG20140402T083021_9mppjxh1_.bkp tag=TAG20140402T083021 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 02-APR-14
channel ORA_DISK_1: finished piece 1 at 02-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_ncsnf_TAG20140402T083021_9mppn7g5_.bkp tag=TAG20140402T083021 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-APR-14
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 1.05G DISK 00:02:01 01-APR-14
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20140401T172802
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_01/o1_mf_nnndf_TAG20140401T172802_9mo1o2g2_.bkp
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 9.36M DISK 00:00:05 01-APR-14
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20140401T172802
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_01/o1_mf_ncsnf_TAG20140401T172802_9mo1s2ky_.bkp
SPFILE Included: Modification time: 01-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1002728 Ckp time: 01-APR-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 1.00G DISK 00:01:37 02-APR-14
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20140402T083021
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_nnndf_TAG20140402T083021_9mppjxh1_.bkp
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 9.36M DISK 00:00:02 02-APR-14
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20140402T083021
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_ncsnf_TAG20140402T083021_9mppn7g5_.bkp
SPFILE Included: Modification time: 02-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1008751 Ckp time: 02-APR-14
RMAN> quit
******************************************************************
4月3日再进行backup:
[oracle@localhost ~]$ date
Thu Apr 3 08:56:15 CST 2014
Recovery Manager complete.
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 3 08:56:25 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1369869147)
RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 1.05G DISK 00:02:01 01-APR-14
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20140401T172802
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_01/o1_mf_nnndf_TAG20140401T172802_9mo1o2g2_.bkp
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 9.36M DISK 00:00:05 01-APR-14
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20140401T172802
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_01/o1_mf_ncsnf_TAG20140401T172802_9mo1s2ky_.bkp
SPFILE Included: Modification time: 01-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1002728 Ckp time: 01-APR-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 1.00G DISK 00:01:37 02-APR-14
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20140402T083021
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_nnndf_TAG20140402T083021_9mppjxh1_.bkp
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 9.36M DISK 00:00:02 02-APR-14
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20140402T083021
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_ncsnf_TAG20140402T083021_9mppn7g5_.bkp
SPFILE Included: Modification time: 02-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1008751 Ckp time: 02-APR-14
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
RMAN> backup database;
Starting backup at 03-APR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-APR-14
channel ORA_DISK_1: finished piece 1 at 03-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_03/o1_mf_nnndf_TAG20140403T085740_9msdjf1h_.bkp tag=TAG20140403T085740 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 03-APR-14
channel ORA_DISK_1: finished piece 1 at 03-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_03/o1_mf_ncsnf_TAG20140403T085740_9msdnrft_.bkp tag=TAG20140403T085740 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 03-APR-14
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 1.05G DISK 00:02:01 01-APR-14
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20140401T172802
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_01/o1_mf_nnndf_TAG20140401T172802_9mo1o2g2_.bkp
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1002637 01-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 9.36M DISK 00:00:05 01-APR-14
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20140401T172802
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_01/o1_mf_ncsnf_TAG20140401T172802_9mo1s2ky_.bkp
SPFILE Included: Modification time: 01-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1002728 Ckp time: 01-APR-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 1.00G DISK 00:01:37 02-APR-14
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20140402T083021
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_nnndf_TAG20140402T083021_9mppjxh1_.bkp
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 9.36M DISK 00:00:02 02-APR-14
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20140402T083021
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_ncsnf_TAG20140402T083021_9mppn7g5_.bkp
SPFILE Included: Modification time: 02-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1008751 Ckp time: 02-APR-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 1.01G DISK 00:02:25 03-APR-14
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20140403T085740
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_03/o1_mf_nnndf_TAG20140403T085740_9msdjf1h_.bkp
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 9.36M DISK 00:00:05 03-APR-14
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20140403T085740
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_03/o1_mf_ncsnf_TAG20140403T085740_9msdnrft_.bkp
SPFILE Included: Modification time: 03-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1010627 Ckp time: 03-APR-14
RMAN> quit
此时,4月1日的backup集合的情报仍然在此处出现。
******************************************************************
4月4日再进行backup:
[oracle@localhost ~]$ date
Fri Apr 4 09:49:26 CST 2014
[oracle@localhost ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Apr 4 09:49:31 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1369869147)
RMAN> backup database;
Starting backup at 04-APR-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 04-APR-14
channel ORA_DISK_1: finished piece 1 at 04-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_04/o1_mf_nnndf_TAG20140404T094940_9mw3y603_.bkp tag=TAG20140404T094940 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 04-APR-14
channel ORA_DISK_1: finished piece 1 at 04-APR-14
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_04/o1_mf_ncsnf_TAG20140404T094940_9mw43jmo_.bkp tag=TAG20140404T094940 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 04-APR-14
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 9.36M DISK 00:00:05 01-APR-14
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20140401T172802
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_01/o1_mf_ncsnf_TAG20140401T172802_9mo1s2ky_.bkp
SPFILE Included: Modification time: 01-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1002728 Ckp time: 01-APR-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 1.00G DISK 00:01:37 02-APR-14
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20140402T083021
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_nnndf_TAG20140402T083021_9mppjxh1_.bkp
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1008677 02-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 9.36M DISK 00:00:02 02-APR-14
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20140402T083021
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_02/o1_mf_ncsnf_TAG20140402T083021_9mppn7g5_.bkp
SPFILE Included: Modification time: 02-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1008751 Ckp time: 02-APR-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 1.01G DISK 00:02:25 03-APR-14
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20140403T085740
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_03/o1_mf_nnndf_TAG20140403T085740_9msdjf1h_.bkp
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1010406 03-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 9.36M DISK 00:00:05 03-APR-14
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20140403T085740
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_03/o1_mf_ncsnf_TAG20140403T085740_9msdnrft_.bkp
SPFILE Included: Modification time: 03-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1010627 Ckp time: 03-APR-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9 Full 1.01G DISK 00:02:58 04-APR-14
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20140404T094940
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_04/o1_mf_nnndf_TAG20140404T094940_9mw3y603_.bkp
List of Datafiles in backup set 9
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1013694 04-APR-14 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 1013694 04-APR-14 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1013694 04-APR-14 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1013694 04-APR-14 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 1013694 04-APR-14 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 9.36M DISK 00:00:08 04-APR-14
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20140404T094940
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_04_04/o1_mf_ncsnf_TAG20140404T094940_9mw43jmo_.bkp
SPFILE Included: Modification time: 04-APR-14
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1014440 Ckp time: 04-APR-14
RMAN>
可以看到,4月1日的文件虽然还有,但和之前相比,已经从2个减少到1个。
上述试验说明,control_file_record_keep_time 虽然进行了设定,也并不是就马上把超过窗口期的数据清除的。