基于时间的备份保留策略的rman研究(二)
ecovery_area/ORCL/backupset/2012_10_09/o1_mf_nnndf_TAG20121009T101445_87724os6_.bkp
www.2cto.com
[sql]
[root@think ~]# export LANG=en_US
[root@think ~]# date
Mon Oct 15 10:28:03 CST 2012
[root@think ~]# date -s "Mon Oct 9 10:28:03 CST 2012"
Tue Oct 9 10:28:03 CST 2012
[root@think ~]# date
Tue Oct 9 10:28:06 CST 2012
[root@think ~]# su - oracle
[oracle@think ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 9 10:28:20 2012
Copyright (c) 1982, 2005,
Oracle. All rights reserved.
connected to target database: ORCL (DBID=1312966189)
RMAN> report obsolete;
using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
no obsolete backups found
www.2cto.com
3 对report need backup的影响
[sql]
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 9 11:14:16 2012
RMAN> list backup;
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 13.09M DISK 00:00:01 2012-10-09:10:14:46
......
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 13.09M DISK 00:00:01 2012-10-09:10:17:13
......
RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days Name
---- ----- -----------------------------------------------------
1 2658 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7wvsw7b2_.dbf
2 2658 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wvsw7gf_.dbf
3 2658 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wvsw7bd_.dbf
5 126 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wvsxyqt_.dbf
6 122 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_ts_1_7x5v2q05_.dbf
www.2cto.com
[root@think ~]# export LANG=en_US
[root@think ~]# date
Wed Oct 10 21:20:03 CST 2012
[root@think ~]# date -s "Wed Oct 11 21:20:03 CST 2012"
Thu Oct 11 21:20:03 CST 2012
[root@think ~]# date
Thu Oct 11 21:20:06 CST 2012
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Oct 11 21:20:54 2012
RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days Name
---- ----- -----------------------------------------------------
1 2660 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_7wvsw7b2_.dbf
2 2660 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_7wvsw7gf_.dbf
3 2660 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_7wvsw7bd_.dbf
4 2 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_7wvsw7hg_.dbf
5 128 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_7wvsxyqt_.dbf
6 124 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_ts_1_7x5v2q05_.dbf
ww