Hi Maser,
I am not sure this work or not. Actually my suggestion is call oracle
support before you do anything. Just for your reference.
1) BACKUP the current situation with the database closed.
The instructions here are destructive. You are STRONGLY
advised to
backup the
Please provide an update as to whether this worked or not, I would be
interested in knowing.
Thanks,
Ethan
-Original Message-
Sent: Wednesday, December 19, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L
Hi Maser,
I am not sure this work or not. Actually my suggestion is call
Post,
Actually I did try. database was opened successfully, but when I query
dba_data_file, all the files are disabled. (RBS from recover status to
disabled, other files from read/write to disabled ) From that point, I
stoped (I don't have time) I am waiting somebody else to tell me.
Joan
Yes. There are ways to recover the database (of course , unsupported) . let
me know the following details by offline,
I will be able to help you.
What is the current state of the database?
What is the size of the redo logs?
Was the last shutdown (if the database is down) is immediate or abort?
how much money do you want to spend?
If you are willing to spend a lot (like $5K for every 8 hours with a
minimum of 16 hours -- price might have gone up, it was that about 3
years ago)
call Tech Support, ask to speak to someone in Field Support about Data
Unloader.
This is what it does
HELP! I got hit with something or someone today and all the redologs for 2
of my production databases disappeared. I have no idea how, and will leave
it to the SysAdmin
to figure out what happened and how to prevent it from happening again. I
am not in archivelog mode and normally take nightly