script_76.txt

orale培训教材包括了所有的sql说明和实例

---------- instance.txt ----------
/*
 * 范例名称：instance:instance  startup and check
 * 文件名称：instance.txt
 */
 

以oracle登录

在rxvt终端窗口，或命令行。

svrmgrl

connect internal;

startup;

select * from v$instance


  
---------- filesystem.txt ----------
/*
 * 范例名称：理解oracle的文件
 * 文件名称：filesystem.txt
 */
--datafile
select * from v$datafile;

--logfile
select * from v$logfile;

--control file
select * from v$controlfile;

--pfile,在linux下
cd $ORACLE_BASE/admin/ora8/pfile
vi initora8.ora
--也可以在$ORACLE_HOME/dbs下
vi initora8.ora



---------- sysdba_oper.txt ----------
/*
 * 范例名称：svrmgrl:CONNECT  AS SYSDBA的使用
 * 文件名称：sysdba_oper.txt
 */

--以oracle用户登录。启动SVRMGRL

SVRMGRL

CONNECT  AS SYSDBA

select * from v$database;
--ok

connect as sysoper;
输入：scott/tiger

select * from v$database;  
--ORA-00942: table or view does not exist



---------- startup_stage.txt ----------
/*
 * 范例名称：startup的各个阶段
 * 文件名称：startup_stage.txt
 */

--以oracle用户登录。启动SVRMGRL

SVRMGRL

CONNECT  internal


--nomount stage
startup nomount;
select * from v$process;
select * from v$sga;
--ok

select * from v$database;
--ORA-01507: ??????

--mount stage
alter database mount;

select * from v$database;  
select * from V$datafile;
--ok
select * from user_tables;
select * from sm_emp;
--ORA-01219: ??????: ???????/?????

--database open stage
alter database open;
select * from user_tables;
--ok
--select * from sm_emp;
desc sm_emp;
error!: 要描述的对象不存在
--注意：connect as sysdba不许访问数据!
connect
user:system
pw:manager
desc sm_emp;
select * from sm_emp;

----------  ----------
/*
 * 范例名称：备份控制文件
 * 文件名称：backupcontrolf.txt
 */
  alter database backup controlfile to trace ;
--可以用show parameter dum;显示user_dump_dest



--不用to trace如何呢？
alter database backup controlfile to 'c:/orc1';

alter database backup controlfile to 'c:/orc1.trc';

--IN SVRMGRL
startup PFILE=$ORACLE_HOME/dbs/initora8.ora