启动方法:
[oracle@lin
/ora]$
svrmgrl
Oracle
Server
Manager
Release
3.1.5.0.0
-
Production
Oracle8i
Enterprise
Edition
Release
8.1.5.0.1
-
Production
With
the
Partitioning
and
Java
options
PL/SQL
Release
8.1.5.0.0
–
Production
如何获得使用帮助
打入help,得到:
下面是简单的语法描述,详细资料请看Oracle
Server
Manager
User's
Guide.
SVRMGR>
help
STARTUP
[DBA]
[FORCE]
[PFILE=filespec]
[EXCLUSIVE
|
SHARED]
[MOUNT
dbname
|
OPEN
dbname]
[NOMOUNT]
SHUTDOWN
[NORMAL
|
IMMEDIATE
|
ABORT]
MONITOR
For
graphical
modes
only,
bring
up
a
monitor
ARCHIVE
LOG
[START]
[STOP]
[LIST]
[NEXT]
[]
[ALL]
['destination']
RECOVER
{
[DATABASE
[MANUAL]
]
|
[TABLESPACE
ts-name
[,tsname]]
}
CONNECT
[username
[/password]
]
[INTERNAL]
['@'instance-spec]
DISCONNECT
SET
options:
INSTANCE,
ECHO,
TERMOUT,
TIMING,
NUMWIDTH,
CHARWIDTH
SHOW
LONGWIDTH,
DATEWIDTH,
AUTOPRINT
and
for
SHOW:
ALL,
SPOOL
EXIT
REM
SQL
statements
can
also
be
executed.
以系统用户oracle登录:
SVRMGR>
connect
internal
Connected.
关闭数据库,现在尝试一下?!
SVRMGR>
shutdown
Database
closed.
Database
dismounted.
ORACLE
instance
shut
down.
启动数据库吧,
我想给它指定参数,并且打开:
SVRMGR>
startup
pfile=/ora/dbs/initora8.ora
open
ora8
ORACLE
instance
started.
Total
System
Global
Area
23670160
bytes
Fixed
Size
64912
bytes
Variable
Size
6656000
bytes
Database
Buffers
16777216
bytes
Redo
Buffers
172032
bytes
Database
mounted.
Database
opened.
测试一下啦,
先看看数据库的系统文件吧:
SVRMGR>
select
*
from
system.sysfiles;
TSNAME
FNAME
BLOCKS
------------------------------
-------------------------------------------------
SYSTEM
/u01/app/oracle/oradata/ora8/system01.dbf
89600
OEM_REPOSITORY
/u01/app/oracle/oradata/ora8/oemrep01.dbf
2560
RBS
/u01/app/oracle/oradata/ora8/rbs01.dbf
6144
TEMP
/u01/app/oracle/oradata/ora8/temp01.dbf
5120
USERS
/u01/app/oracle/oradata/ora8/users01.dbf
5120
INDX
/u01/app/oracle/oradata/ora8/indx01.dbf
5120
6
rows
selected.
嗯,
感觉不错,
我会了,谢谢。现在退出休息一下吧。
SVRMGR>
exit
Server
Manager
complete.