2014年6月18日水曜日

startup とshutdownはどういう順序で何をしているのだろうか?

実際、startup とshutdownはどういう順序で何をしているのだろうか?

■RMANからつなげてみる
c:\app\camp-kawasaki\product\12.1.0\dbhome_1\BIN>rman

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Jun 18 21:45:28 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

RMAN> show all;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 06/18/2014 21:45:58
RMAN-06171: not connected to target database

あらら、インスタンスは一個しかないけどダメか。

RMAN> exit


Recovery Manager complete.

c:\app\camp-kawasaki\product\12.1.0\dbhome_1\BIN>rman target "' / as sysbackup '
"

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Jun 18 21:47:47 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1374852559)

■Shutdownしてみる
RMAN> shutdown immediate;

using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

■Startupしてみる
RMAN> startup mount

connected to target database (not started)・・・・・・・・・・・・・・初期化パラメータを見ている
Oracle instance started・・・・・・・・・・・・・・・・・・・・・・・・・・・・インスタンスが起動した
database mounted

Total System Global Area    1286066176 bytes・・・・・・・・・SGAを割り当てた

Fixed Size                     2402248 bytes
Variable Size                805308472 bytes
Database Buffers             469762048 bytes
Redo Buffers                   8593408 bytes

RMAN> alter database archivelog;

Statement processed

RMAN> alter database open;

Statement processed

RMAN>

0 件のコメント:

コメントを投稿