v$instance
[php]
$ sqlplus " /as sysdba"
SQL*Plus: Release 9.2.0.5.0 - Production on Tue Jul 19 14:19:17 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
>
> startup nomount
ORACLE instance started.
Total System Global Area 1074761248 bytes
Fixed Size 732704 bytes
Variable Size 939524096 bytes
Database Buffers 134217728 bytes
Redo Buffers 286720 bytes
> select * from v$instance
2 /
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_
----------------- --------- ------------ --- ---------- ------- -----------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
---------- --- ----------------- ------------------ ---------
1 test
test
9.2.0.5.0 19-JUL-05 STARTED 0 STOPPED
ALLOWED NO ACTIVE UNKNOWN NORMAL
> select * from v$database
2 /
select * from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
> alter database mount
2 /
Database altered.
> select * from v$database
> /
DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- ---------
PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#
----------------------- --------- ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
--------------- ------- --------- --------------------- -------------------
CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE PROTECTION_MODE
--------- ----------- --------- ---------- --------------------
PROTECTION_LEVEL REMOTE_A ACTIVATION# DATABASE_ROLE ARCHIVELOG_CHANGE#
-------------------- -------- ----------- ---------------- ------------------
SWITCHOVER_STATUS DATAGUAR GUARD_S SUP SUP SUP FOR
------------------ -------- ------- --- --- --- ---
1857894666 TEST 31-MAY-05 1 31-MAY-05
0 NOARCHIVELOG 687887
36776 CURRENT 31-MAY-05 88 687805
05-JUL-05 NOT ALLOWED 31-MAY-05 MOUNTED MAXIMUM PERFORMANCE
UNPROTECTED ENABLED 1857901066 PRIMARY 0
SESSIONS ACTIVE DISABLED NONE NO NO NO NO
> select * from v$instance
2 /
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_
----------------- --------- ------------ --- ---------- ------- -----------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
---------- --- ----------------- ------------------ ---------
1 test
test
9.2.0.5.0 19-JUL-05 MOUNTED NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
...
[/php]
扫一扫
922
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
