RE: Recovery from loss of both control files & redo log files
- From: "Best, David" <David.Best@xxxxxxxxxx>
- To: <Mark.Bobak@xxxxxxxxxxxxxxx>, "Kevin Lidh" <kevin.lidh@xxxxxxxxx>
- Date: Thu, 30 Nov 2006 13:48:03 -0500
If your on unix you can strings your old controlfile (assuming you have
one) and obtain the datafile locations which will help when building the
create controlfile syntax.
strings cntrl01.dbf | grep dbf
/oradata/dbf/log02a.dbf
/oradata/dbf/log02b.dbf
/oradata/dbf/log01a.dbf
Also, if there is information in the redo logs that is needed to
complete recovery you can try using the _allow_resetlogs_corruption
init.ora parameter. This parameter tells oracle to skip some(all?)
internal consistency checks. I can't seem to find the metalink note
right now but I believe after you use this parameter your supposed to
export/import to create a new database. Of course, you should only use
this on the recommendation of Oracle support. ;)
Tnx.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Thursday, November 30, 2006 1:31 PM
To: Kevin Lidh
Cc: oradba.la@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Recovery from loss of both control files & redo log files
Cool article, thanks for pointing it out.
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
There is nothing so useless as doing efficiently that which shouldn't be
done at all. -Peter F. Drucker, 1909-2005
-----Original Message-----
From: Kevin Lidh [mailto:kevin.lidh@xxxxxxxxx]
Sent: Thursday, November 30, 2006 1:30 PM
To: Bobak, Mark
Cc: oradba.la@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Recovery from loss of both control files & redo log files
I read this article by Howard Rogers and thought it was really good.
Maybe it will be helpful to you since your situation is so similar.
http://www.dizwell.com/prod/node/399
On Thu, 2006-11-30 at 13:13 -0500, Bobak, Mark wrote:
> Since the database was closed at the time, you don't need the redo
> logs. (Just open w/ resetlogs.)
>
> However, the controlfiles are a bit more problematic. If you have the
> create controlfile command from when the database was created, and you
> know about *ALL* datafiles that were added and any tablespaces that
> were dropped in the meantime, you ought to be able to cobble together
> a representative create controlfile command that you could use to
> re-create the controlfile. If you're successful there, do startup
> mount, then alter database open resetlogs.
>
> Good luck....
>
>
> Hope that helps,
>
> -Mark
>
> --
>
> Mark J. Bobak
>
> Senior Oracle Architect
>
> ProQuest Information & Learning
>
> There is nothing so useless as doing efficiently that which shouldn't
> be done at all. -Peter F. Drucker, 1909-2005
>
>
>
>
> ______________________________________________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Manjula Krishnan
> Sent: Thursday, November 30, 2006 1:05 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Recovery from loss of both control files & redo log files
>
>
>
> We had a disk crash. All data files are intact (database was closed at
> the time). But, all redo log files and controlfiles are lost. Can this
> database be recovered? This is a development database so I am not too
> worried, but would like to know if this is possible.
>
> Thanks,
>
> Manjula
--
//www.freelists.org/webpage/oracle-l
This message may contain privileged and/or confidential information. If
you have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any attachments,
delete it immediately from your system and notify the sender promptly by e-mail
that you have done so. Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
