Database not Opening
We have an amazing situation that we don't have the
lastdays backup (as backup was not properly taken up)
The database gets mounted but don't get opened as
one of the data file is missing.
Is there any way to recover the datafile and make
the oracle server live once again.
Good question! There are ways to bring the DB up.
*********
SVRMGR> alter database datafile '/u01/oradata/ORCL/data/users01.dbf'
offline drop;
SVRMGR> alter database open;
SVRMGR> drop tablespace users including contents;
*********
In the first stmt you can either use DROP or just use
OFFLINE.It totally depends on what kind of data is out in that datafile.If
un-necessary data then just drop it...if u happen to have valuable data
then you can bring it offline and try to recover the DB.
Also you haven't mentioned if you are running a COLD
or HOT bkp ?
Do you at least have an EXPORT.dmp of the tablespace?
If you have then just export the Tablespace.
I am not sure this might workout for your scenario but
it may bring the DB up for now.
Thanks a lot , by taking datafiles offline , server
could be opened and is now live.
but all the files taken offline are showing files
0 kb size.
Was it due to virus or anyother reason?
and these files now require auto recovery.
can these files be repaired now
However thanks for the advice
I ran the following command and the output came like this
Can you explain me the reason for the following output
and also how the files can be recovered.
SQL> set autorecovery on;
SQL> recover automatic datafile 11;
ORA-00283: recovery session canceled due to errors
ORA-01157: cannot identify/lock data file 11 - see DBWR
trace file
ORA-01110: data file 11: 'E:\ORACLE\ORADATA\HHML\D_HH_ATEND.ORA'
Seems like the only option in your scenario would be
dropping the tablespace and re-creating a new one.
If you happen to have an export dump for the tablespace
or objects in that tspace just import them after creating a new ts.
Have a Oracle Question
Do
you have an Oracle Question?
Oracle Books
Oracle
Certification, Database Administration, SQL, Application, Programming Reference
Books
Oracle Application
Oracle
Application Hints and Tips
Oracle Home
Oracle
Database, SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|