(no subject)

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Tue, 19 Jun 2001 00:15:32 -0700
Message-ID: <F001.0032E3B5.20010619002626@fatcity.com>

Gr8 to know that you have set(s) of valid backup.... Now you can perform following steps to bring the database up..

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.
Restore all the archived log files to log_archive_dest.
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.
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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rajesh Dayal
INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------