Thursday, April 21, 2011

STARTUP FORCE

I was asked to bounce an Oracle 11 test database by Dilip
(http://www.linkedin.com/pub/dilip-seshan/5/469/29b). There were several sessions in the database originating from a variety of server processes so I decided to use STARTUP FORCE. This does a SHUTDOWN ABORT then opens the database again. Note the ORA-32004 because the parameter file has not been fully updated since the upgrade from an earlier version of Oracle:

SQL> startup force;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  313245696 bytes
Fixed Size                  2147672 bytes
Variable Size             197139112 bytes
Database Buffers          109051904 bytes
Redo Buffers                4907008 bytes
Database mounted.
Database opened.
SQL>

Appropriate messages appear in the alert log:

Tue Apr 19 10:04:55 2011
Shutting down instance (abort)
License high water mark = 65
USER (ospid: 23820): terminating the instance
Instance terminated by USER, pid = 23820
Tue Apr 19 10:04:57 2011
Instance shutdown complete
Tue Apr 19 10:04:58 2011
Adjusting the default value of parameter parallel_max_servers
from 160 to 85 due to the value of parameter processes (100)
Starting ORACLE instance (normal)
Etc.

And a crash recovery takes place:

ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2804399374
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Tue Apr 19 10:05:07 2011
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
 parallel recovery started with 7 processes
Started redo scan
Completed redo scan
 read 1835 KB redo, 646 data blocks need recovery
Started redo application at
 Thread 1: logseq 99, block 42986
Recovery of Online Redo Log: Thread 1 Group 3 Seq 99 Reading mem 0
  Mem# 0: /database/BUSSOST1/bus_redo1/redo03a.log
  Mem# 1: /database/BUSSOST1/bus_redo2/redo03b.log
Completed redo application of 1.27MB
Completed crash recovery at
 Thread 1: logseq 99, block 46657, scn 1701984663986
 646 data blocks read, 646 data blocks written, 1835 redo k-bytes read
Tue Apr 19 10:05:14 2011

No comments: