---------- 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用戶登錄。啟動(dòng)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的各個(gè)階段
 * 文件名稱：startup_stage.txt
 */

--以oracle用戶登錄。啟動(dòng)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;

connect
user:scott
pw:tiger
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';
--linux
alter database backup controlfile to '/home/oracle/ora8.trc';
--為二進(jìn)制文件


--IN SVRMGRL
echo $ORACLE_HOME/dbs
--驗(yàn)證startup 實(shí)際是等于startup pfile，讀了initora8.ora
 startup pfile=/ora8/m01/app/oracle/product/8.1.7/dbs/initora8.ora