1. 连接到Oracle
开始 -> 运行cmd -> cd \
C:\>sqlplus "sys/mfw238 as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 3月 16 14:16:43 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
2. 查看数据文件
SQL> desc v$controlfile
名称 是否为空? 类型
----------------------------------------- -------- ---------------------------
STATUS VARCHAR2(7)
NAME VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
SQL>
C:\>sqlplus "sys/mfw238 as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 3月 16 14:16:43 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> desc v$controlfile
名称 是否为空? 类型
----------------------------------------- -------- ---------------------------
STATUS VARCHAR2(7)
NAME VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
SQL>
SQL> select status ,name from v$controlfile;
STATUS
-------
NAME
------------------------------------------------------------
C:\ORACLE\PRODUCT\10.1.0\ORADATA\JLXXT\CONTROL01.CTL
C:\ORACLE\PRODUCT\10.1.0\ORADATA\JLXXT\CONTROL02.CTL
C:\ORACLE\PRODUCT\10.1.0\ORADATA\JLXXT\CONTROL03.CTL
desc v$datafile;
select file#,status,name form v$datafile;
desc v$logfile;
select
3.Oracle 参数文件用于寻找控制文件,控制文件直接控制数据文件,日志文件
物理结构
开始 -> 运行cmd -> cd \
C:\>sqlplus "sys/mfw238 as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 3月 16 14:16:43 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
2. 查看数据文件
SQL> desc v$controlfile
名称 是否为空? 类型
----------------------------------------- -------- ---------------------------
STATUS VARCHAR2(7)
NAME VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
SQL>
C:\>sqlplus "sys/mfw238 as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 3月 16 14:16:43 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> desc v$controlfile
名称 是否为空? 类型
----------------------------------------- -------- ---------------------------
STATUS VARCHAR2(7)
NAME VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
SQL>
SQL> select status ,name from v$controlfile;
STATUS
-------
NAME
------------------------------------------------------------
C:\ORACLE\PRODUCT\10.1.0\ORADATA\JLXXT\CONTROL01.CTL
C:\ORACLE\PRODUCT\10.1.0\ORADATA\JLXXT\CONTROL02.CTL
C:\ORACLE\PRODUCT\10.1.0\ORADATA\JLXXT\CONTROL03.CTL
desc v$datafile;
select file#,status,name form v$datafile;
desc v$logfile;
select
3.Oracle 参数文件用于寻找控制文件,控制文件直接控制数据文件,日志文件
物理结构