Home » RDBMS Server » Backup & Recovery » Instance Recovery......
Instance Recovery...... [message #262347] Sun, 26 August 2007 06:50 Go to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,

When database gets started how can we know instance recovery has taken place?

Please Guide me.

Regards,
Naveen
Re: Instance Recovery...... [message #262349 is a reply to message #262347] Sun, 26 August 2007 07:17 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
shutdown abort;
startup

and check alert<sid>.log file

Sun Aug 26 16:12:48 2007
ALTER DATABASE OPEN
Sun Aug 26 16:12:48 2007
Beginning crash recovery of 1 threads
Sun Aug 26 16:12:49 2007
Started redo scan
Sun Aug 26 16:12:49 2007
Completed redo scan
 37 redo blocks read, 11 data blocks need recovery
Sun Aug 26 16:12:49 2007
Started redo application at
 Thread 1: logseq 14, block 18044, scn 0.0
Sun Aug 26 16:12:49 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 14 Reading mem 0
  Mem# 0 errs 0: C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG
Sun Aug 26 16:12:49 2007
Completed redo application
Sun Aug 26 16:12:50 2007
Completed crash recovery at
 Thread 1: logseq 14, block 18081, scn 0.595684
 11 data blocks read, 11 data blocks written, 37 redo blocks read

http://download.oracle.com/docs/cd/B14117_01/server.101/b10743/backrec.htm#sthref2414

[Updated on: Sun, 26 August 2007 07:21]

Report message to a moderator

Re: Instance Recovery...... [message #262587 is a reply to message #262349] Mon, 27 August 2007 11:38 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:

When database gets started how can we know instance recovery has taken place?


In addition to TAJ Instance recovery only needed when your instance went down ABNORMAL like (power off,shutdown abort,Os hang).
Previous Topic: Backup And Recovery
Next Topic: archivelog file?
Goto Forum:
  


Current Time: Sat Jun 15 12:04:38 CDT 2024