Oracle介绍SVRMGRL命令

王朝oracle·作者佚名  2008-05-18
窄屏简体版  字體: |||超大  

启动方法:

[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.

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航