了解oracle数据库的情况

时间:2021-03-30 16:56:29

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

了解oracle数据库的情况

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

了解oracle数据库的情况