1.了解你的数据库版本号

 

2.是否配置了DataGuard?

SQL> select protection_mode, protection_level, remote_archive,

database_role, dataguard_broker,guard_status

from v$database;

 

3.是否起用了flashback database特性？

SQL> select flashback_on from v$database;

 

4.是否关闭回收站？

SQL> show parameter recyclebin

 

5.是否起用了force logging和补充日志？

SQL> select force_logging,supplemental_log_data_min,

supplemental_log_data_pk, supplemental_log_data_ui,

supplemental_log_data_fk, supplemental_log_data_all

from v$database;

6.控制文件，参数文件是否设置了自动备份？

RMAN> show controlfile autobackup;

 

7.系统中是否存在invalid对象、无效索引

SQL> select owner, object_type, COUNT(*)

from dba_objects

where status = 'INVALID' group by owner, object_type;

SQL> select owner, index_name, index_type

from dba_indexes

where status not in ('VALID', 'N/A') order by 1,3,2;

8. 数据库需要归档的情形