oracle各個啟動階段_nomount_mount_open_dump_trace命令的可執行性

/*******測試目的：dump命令是否在資料庫各個啟動階段都可使用*******/
SQL> select segment_name,header_file,header_block from dba_segments where segmen
t_name='_SYSSMU1_2533871115$';

SEGMENT_NAME                   HEADER_FILE HEADER_BLOCK
------------------------------ ----------- ------------
_SYSSMU1_2533871115$                     3          128

/*****nomount狀態可以dump*********/
SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanc
ORACLE instance started.

Total System Global Area 1670221824 bytes
Fixed Size                  2176328 bytes
Variable Size            1056967352 bytes
Database Buffers          603979776 bytes
Redo Buffers                7098368 bytes
SQL> alter system  dump datafile 3 block 128;

System altered.

/*****mount狀態可以dump*****/
SQL> alter database mount
  2  ;

Database altered.

SQL> alter system  dump datafile 3 block 128;

System altered.

/****open狀態可以dump*********/
SQL> alter database open;

Database altered.

SQL> alter system  dump datafile 3 block 128;

System altered.

SQL>

小結:oracle dump命令可以資料庫各個啟動階段使用,這樣在資料庫出現故障進行介析就有了大用處了