If I loose all my control files can I restore them
by using create control file dump from a similer database .
If you have good enough information about all your database
files.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 09, 2003 1:18
PM
Subject: lost control files
BigP wrote:
If I loose all my control files can I restore them by using create
control file dump from a similer database .
IMHO it is safer to do a manual 'create control file'. Similarity is
always just up to a point and gives you a false sense of security. And
BTW if you lose
- Original Message -
From:
David L
Phillips
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 09, 2003 11:08
AM
Subject: Re: lost control files
No. It would be like getting amnesia and just
using the memories of someone that looks like you
Concepts Inc.
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 09, 2003 1:18
PM
Subject: lost control files
If I loose all my control files can I restore
them by using create control file dump from a similer
Wrong...I _think_ :)
If he rebuilds them using the correct file placements then
it will work. The only problem is that he will have to open
RESETLOGS and incomplete recovery will be impossible. But
if he has all of his datafiles and is only missing control
files then he can startup nomount and
Umm I'll have to apologize for thinking too quick and letting my inner child
do the typing.
I haven't had to do a manual create of a control file yet (and hope not to).
My paranoia would not allow me to not have a backup control file and
init.ora file etc around.
If you have multiple instances of
Jeff,
You are right. It's still possible to create the controlfile by hand using
the CREATE CONTROLFILE command. You can do, in fact you *have* to do
incomplete recovery recover database using backup controlfile until cancel
However, a BIG however, here; you MUST know all the file names
Hi ,
Some precisions :
If you have ONLY LOST the controlfiles after a clean shutdown
(normal or immediate) you can just :
1) startup nomount
2) recreate the controfiles (CREATE CONTROLFILE command)
3) open the database in NORESETLOGS mode.
If you have ONLY LOST the controlfiles after a