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;
......
