Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)
Gr8 to know that you have set(s) of valid backup.... Now you can perform following steps to bring the database up..
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
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: hermanto_p_at_aprilasia.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Tue Jun 19 2001 - 02:15:32 CDT
![]() |
![]() |