Recover Datafile with NOARCHIVELOG

[ckwan]

Dear all,
Received a call saying the database cannot up the error message as below
ORA:01113 file2 needs media recovery
ORA:01110 Data File 2.....

Thus,
svrmgr> startup mount
svrmgr> alter database datafile 'c:.....' offline drop;
svrmgr> alter database open;

I created another owner in order for me to import from backup file.

Next day, I discovered the datafile is being hide by 'someone' and the permission of the file is read only.

Question is can I still recover my datafile from my physical datafile ? This is no archivelog mode. I just set it archivelog mode.

Any ideas to recover back if without archive log mode ? Please help me on this ....

[vijay8282]

Hi

You cannot recover the file if u r not running in archivelog mode.

regds

[ckwan]

According to Oracle Support, there is another possibility to recover the data using the DUL (Data Unloader)

I am not sure whether anybody know how to use the tools ?

Please advice. Thanks.

[ms_reddy]

There is no recovery that DBA could do when the database is running in no archivelog mode.

[rameshgiri26]

Originally posted by ms_reddy
There is no recovery that DBA could do when the database is running in no archivelog mode.

hi, i am ramesh giri .n

you can do one thing install oracle lite in any other client machine that it will install recovery manager with front end tool you can recover from that tool that it supports definetly..


regds,
RAMESH GIRI .N

[ckwan]

Can u elaborate more on the idea you suggest ? Thanks.

[sreddy]

Unfortunately, whatever should not happen is happened. One shouldn't drop a datafile no matter whats the situation unless they want to blow the tablespace off.

I guess,You don't have any solution other than restoring the database from previous cold backup and loose the data from the cold backup time.

Dropping the datafile leaves a pointer in the database tablespace. Whenever you try to bring the database up it looks for that datafile.

Not sure. Give a try. Try copying the original physical file you found to the location where it was and try bringing up the database. If there was no activity on the datafile since the file is in readonly mode, it may work out. Just a trial.