■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 件のコメント:
コメントを投稿