10g_陌生库检查

D:\APP\ADMINISTRATOR\ORADATA\GG02\USERS01.DBF USERS
D:\APP\ADMINISTRATOR\ORADATA\GG02\UNDOTBS01.DBF UNDOTBS1
D:\APP\ADMINISTRATOR\ORADATA\GG02\SYSAUX01.DBF SYSAUX
SYSAUX 8192 ONLINE PERMANENT LOGGING
UNDOTBS1 8192 ONLINE UNDO LOGGING
TEMP 8192 ONLINE TEMPORARY NOLOGGING
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
3、查看控制文件存放位置
SQL> desc v$controlfile;
名称 是否为空? 类型
ORA-01031: 权限不足
SQL> show user
USER 为 "SYSTEM"
SQL> conn / as sysdba
已连接。
SQL> archive log list;
数据库日志模式 存档模式
自动存档 启用
存档终点 USE_DB_RECOVERY_FILE_DEST
ces;
TABLESPACE_NAME BLOCK_SIZE STATUS CONTENTS LOGGING
--------------- ---------- --------- --------- ---------
SYSTEM 8192 ONLINE PERMANENT LOGGING
---------- ------- --------------------------------------------------
3 D:\DISK5\GG02\ONLINELOG\O1_MF_3_81MNN8NZ_.LOG
2 D:\DISK5\GG02\ONLINELOG\O1_MF_2_81MP3QJM_.LOG
----------------------------------------- -------- ----------------------------
STATUS VARCHAR2(7)
NAME VARCHAR2(513)
1 D:\DISK4\GG02\ONLINELOG\O1_MF_1_81MNVVVC_.LOG
2 D:\DISK4\GG02\ONLINELOG\O1_MF_2_81MP3X3X_.LOG
已选择10行。
SQL> archive log list;
1、检查数据库创建日期、归档方式等
SQL> conn system/manager as sysdba
已连接。
SQL>
SQL> select name,created,log_mode,open_mode from v$database;
NAME CREATED LOG_MODE OPEN_MODE
SQL> select username,created fr
------------------------------ --------------
SYS 30-3月 -10
2 2 104857600 UNUSED YES
3 2 104857600 CURRENT NO
4 2 104857600 UNUSED YES
GROUP# MEMBERS BYTES STATUS ARC
---------- ---------- ---------- ---------------- ---
1 2 104857600 INACTIVE YES
SQL> col name for a60
SQL> select status,name,block_size from v$controlfile;
STATUS NAME BLOCK_SIZE
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
FILE_NAME TABLESPACE_NAME
------------------------------------------------------------ ---------------
D:\APP\ADMINISTRATOR\ORADATA\GG02\SYSTEM01.DBF SYSTEM
D:\APP\ADMINISTRATOR\ORADATA\GG02\EXAMPLE01.DBF EXAMPLE
8、查看数据库有多少用户，什么时候创建的
5 2 104857600 INACTIVE YES
5、重做日志文件的存放位置
SQL> col member for a55
SQL> select group#,status,member from v$logfile;
GROUP# STATUS MEMBER
--------- -------------- ------------ --------------------
GG02 20-7月 -12 ARCHIVELOG READ WRITE
SQL>
2、检查主机名、实例、数据库版本
SQL> col host_name for a20
5 D:\DISK4\GG02\ONLINELOG\O1_MF_5_81MN8ZH4_.LOG
3 D:\DISK4\GG02\ONLINELOG\O1_MF_3_81MNNGMK_.LOG
4 D:\DISK4\GG02\ONLINELOG\O1_MF_4_81MNPO5C_.LOG
IS_RECOVERY_DEST_FILE VARCHAR2(3)
BLOCK_SIZE NUMBER
FILE_SIZE_BLKS NUMBER
MDSYS 30-3月 -10
ORDSYS 30-3月 -10
EXFSYS 30-3月 -10
------- ------------------------------------------------------------ ----------
D:\APP\ADMINISTRATOR\ORADATA\GG02\CONTROL01.CTL 16384
最早的联机日志序列 14
下一个存档日志序列 16
当前日志序列 16
SQL>
6、查看表空间情况
SQL> col tablespace_name for a15
SQL> select tablespace_name,block_size,status,contents,logging from dba_tablespa
1 D:\DISK5\GG02\ONLINELOG\O1_MF_1_81MNVTXS_.LOG
4 D:\DISK5\GG02\ONLINELOG\O1_MF_4_81MNPHTV_.LOG
5 D:\DISK5\GG02\ONLINELOG\O1_MF_5_81MN8T4D_.LOG
SOURCE11 gg02 11.2.0.1.0
SQL> select * from v$version;
BANNER
------------------------------------------------------------------------------
D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\GG02\CONTROL02.CTL 16384
4、查看重做日志文件的配置信息
SQL> select group#,members,bytes,status,archived from v$log;
USERS 8192 ONLINE PERMANENT LOGGING
EXAMPLE 8192 ONLINE PERMANENT NOLOGGING
已选择6行。
7、表空间对应的数据文件
SQL> select file_id,file_name,tablespace_name,status,bytes from dba_data_files;
SQL> select host_name,instance_name,version from v$instance;
HOST_NAME INSTANCE_NAME VERSION
-------------------- ---------------- -----------------
SYSTEM 30-3月 -10
OUTLN 30-3月 -10
MGMT_VIEW 30-3月 -10
FLOWS_FILES 30-3月 -10