-
Missing Undo datafile on hpux
Hello..
One of the undo datafile is missing from our filesystem and i needed some help to figure out how to fix it.. I know file 52 is an undo datafile because from where it was copied from..the dba did a refresh from prod to uat but he must have used the old create controlfile script and left out undo03.dbf
alert.log is showing this error message.
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 52 cannot be read at this time
ORA-01111: name for data file 52 is unknown - rename to correct file
ORA-01110: data file 52: '/apps/oracle/product/9.2.0_64bit/dbs/MISSING00052'
*** 2006-01-27 18:37:39.943
SQL> select file#, name, status from v$datafile where file#=52;
FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
-------
52
/apps/oracle/product/9.2.0_64bit/dbs/MISSING00052
RECOVER
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|