Oracle 10G 学习笔记 20090316

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 参数文件用于寻找控制文件，控制文件直接控制数据文件，日志文件

物理结构