基于时间的备份保留策略的rman研究
基于时间的备份保留策略的rman研究
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;
- ......
|
评论暂时关闭