oraclesvrmgrl:Oracle介绍SVRMGRL命令

="t18">
  启动思路方法:
[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 ernal
Connected.
关闭数据库现在尝试下?!
SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
启动数据库吧, 我想给它指定参数,并且打开:
SVRMGR> startup pfile=/ora/dbs/initora8.ora open ora8
ORACLE instance started.
Total  Global Area                         23670160 s
Fixed Size                                          64912 s
Variable Size                                     6656000 s
Database Buffers                                 16777216 s
Redo Buffers                                       172032 s
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.
Tags:  oracle常用命令 oracle命令 svrmgrl oraclesvrmgrl

延伸阅读

最新评论

发表评论