Error opening Database

Hi Everyone!!

Fall season is showing good colors(Trees are really beautiful in red color than green!!) around the area, we had storm in our data center today causing unplanned outage. UNIX engineers worked for ~12 hours to bring back up all the servers. After my production server came up, I was starting the databases one by one. Archive database(version 9.2.0.8) started giving error.

SQL> startup
ORACLE instance started.

Total System Global Area 2000651176 bytes
Fixed Size 730024 bytes
Variable Size 922746880 bytes
Database Buffers 1073741824 bytes
Redo Buffers 3432448 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/ora07/oradata/arcprd01/data/ora_arcprd01_system01.dbf'


SQL>

I was doubting file system mount was correct or not.


SQL> !ls -l /ora07/oradata/arcprd01/data/ora_arcprd01_system01.dbf
-rw-r--r-- 1 oracle dba 19385032704 Oct 25 21:11 /ora07/oradata/arcprd01/data/ora_arcprd01_system01.dbf

SQL>

This showed the file system mounts are correct.

I have queried v$recover_file, it was showing 27 files need recovery.

SQL>desc v$recover_file;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
ONLINE VARCHAR2(7)
ONLINE_STATUS VARCHAR2(7)
ERROR VARCHAR2(18)
CHANGE# NUMBER
TIME DATE

SQL> select file# from v$recover_file;

FILE#
----------
1
17
19
23
24
51
55
59
66
75
76

FILE#
----------
92
93
94
95
96
97
98
99
100
101
102

FILE#
----------
103
106
109
111
113

27 rows selected.

SQL> exit

At this stage I have checked the alert log.

alter tablespace RXC_VRV_IDX_TSPA BEGIN backup
Completed: alter tablespace RXC_VRV_IDX_TSPA BEGIN backup
Sun Oct 25 08:00:25 2009
alter tablespace RXC_DISC_TSPA END backup
Sun Oct 25 08:00:25 2009
Completed: alter tablespace RXC_DISC_TSPA END backup
Sun Oct 25 08:00:25 2009
alter tablespace RXC_DCD_TSPA BEGIN backup
Completed: alter tablespace RXC_DCD_TSPA BEGIN backup
Sun Oct 25 20:09:30 2009
Starting ORACLE instance (normal)
Disable cache advisory with old cache parameters
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value

I interpreted that tablespace gone to 'begin backup' mode and server gone down.
This is how I have fixed the issue.

SQL> select status,count(1) from v$backup group by status;

STATUS COUNT(1)
------------------ ----------
ACTIVE 27
NOT ACTIVE 104

SQL>
SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

SQL>select status,count(1) from v$backup group by status;

STATUS COUNT(1)
------------------ ----------
NOT ACTIVE 131

SQL>exit