Gr8 to know that you have set(s) of valid backup....
Now you can perform following steps to bring the database up..
1. Restore the online backup: Place all the datafiles to their original
destination (from tape). Take help of previous trace dump of control
file
to put at right place.
2. Restore all the archived log files to log_archive_dest.
3. If all copies of your current control file is damaged, then restore
a backup of it.
If you have even a single copy intact, use that and overwrite
others with that. Best strategy is to refer only one control file
in init.ora at one time and try mounting the database, if it mounts,
means
that control file is OK.
4. Now you are ready to perform database recovery, fire the golden
command...
ALTER DATABASE RECOVER [AUTOMATIC] UNTIL ........
you might would have to use "USING BACKUP CONTROLFILE " clause. Refer
manual for complete set of options.
5. Cross your fingers....
6. Once media recovery is completed
" ALTER DATABASE OPEN [resetlogs/noresetlogs]"
7. After finishing above steps , take one full COLD backup, if it was
resetlogs.
8. Keep testing your backup (on monthly basis, preferably on test
server).
HTH, if you need more help keep in touch,
Rajesh
-----Original Message-----
Sent: Tuesday, June 19, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
Thanks Rajesh,
The part of broken database is datafiles (data-datafile and
control-file).
It caused by immediate shutdown from electricity consumption. And affect
the
database (corrupted).
We have online backup..including archive log.
OS = HP-UX tester B.10.20 E 9000/802 1414693381 8-user license.
Thanks before..
m-t-x
"Our greatest glory is not in never falling but in rising every time we
fall"
-----Original Message-----
Sent: Tuesday, June 19, 2001 01:30 PM
To: Multiple recipients of list ORACLE-L
We appreciate your quote....
>>
m-t-x
"Our greatest glory is not in never falling but in rising every time we
fall"
<<
But would appreciate more if you could provide details of broken
database, e.g.
-- What part of database is broken (control file, online redolog
file, data-datafile, temp-datafile, rbs-datafile).
-- What was the cause of failure
-- What kind of backups you have( If you have any)
-- OS and version details
HTH,
Rajesh
OC DBA (8 & 8i)
-----Original Message-----
Sent: Tuesday, June 19, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L
Dear Subscribers,
I have a broken database that I wish to recover. The old database come
from
other SID
Could you please help me how to recover ?
m-t-x
"Our greatest glory is not in never falling but in rising every time we
fall"
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hermanto P
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajesh Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hermanto P
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajesh Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
