1 实验准备
a)物理和逻辑上检查
SQL> col file_name for a70 wrapped
SQL> select file_name,status from dba_data_files where file_id=4;
FILE_NAME STATUS
---------------------------------------------------------------------- ---------
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_7wvsw7hg_.dbf AVAILABLE
SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='USERS';
TABLESPACE_NAME STATUS
------------------------------ ---------
USERS ONLINE
b)large_pool
SQL> select * from v$sgastat where pool like '%large%';
POOL NAME BYTES
------------ -------------------------- ----------
large pool PX msg pool 902160
large pool free memory 3292144
c)NLS_DATE_FORMAT
>vim .bash_profile
>export NLS_DATE_FORMAT='YYYY-MM-DD:HH24:MI:SS'
>. .bash_profile
d)control_file_record_keep_time
SQL> show parameter control_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
e)清空环境
RMAN> list backup;
RMAN> list copy;
specification does not match any archive log in the recovery catalog
f)配置时间窗口为1 days
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> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
......
2 对report obsolete的影响
RMAN> backup tablespace users;
......
Finished backup at 2012-10-09:10:14:46
RMAN> backup tablespace users; //对users备份两次,当超过备份保留策略时,rman会将老的备份标志为obsolete
......
Finished backup at 2012-10-09:10:17:13