了解oracle数据库的情况

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. 数据库需要归档的情形