Monday, October 8, 2012
Recovering from Missed /Deleted dbf file in Oracle
Scenerio- one or more datafiles are deleted from OS level and databae is not geeting open.
Issue
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 534462464 bytes
Fixed Size 2215064 bytes
Variable Size 390071144 bytes
Database Buffers 134217728 bytes
Redo Buffers 7958528 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/u01/app4/oracle/oradata/uatdb3/rman_tbs02.dbf'
Solution
SQL> alter database datafile '/u01/app4/oracle/oradata/uatdb3/rman_tbs02.dbf' offline drop;
Database altered.
SQL> alter database backup controlfile to trace as '/u01/app/test.ctl';
Database altered.
SQL> alter database open
2 ;
Database altered.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment