]
cc:
12/06/2001 Subject: Re: missing all
control file
05:06 PM
Hi, does
CEATE CONTROLFILE works?
oli
On Tuesday 12 June 2001 11:20, [EMAIL PROTECTED] wrote:
Hi all,
I accidentally rm all my control file, I
PROTECTED]To: LazyDBA.com Discussion
net.de [EMAIL PROTECTED]
cc:
12/06/2001 Subject: Re: missing all
control file
05:06 PM
Hi, does
CEATE CONTROLFILE
[EMAIL PROTECTED]
csis.comcc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: missing all control file
continue...
[EMAIL PROTECTED
/2001 Subject: Re: missing all
control file
05:06 PM
Hi, does
CEATE CONTROLFILE works?
oli
On Tuesday 12 June 2001 11:20, [EMAIL PROTECTED] wrote:
Hi all,
I accidentally rm all my control file, I forgot do
ALTER DATABASE BACKUP CONTROLFILE
You may well be OK. All you need to do is fetch the database up in nomount
mode
startup nomount from svrmgrl.
SVRMGR startup nomount
ORACLE instance started.
Total System Global Area 6892912 bytes
Fixed Size 60784 bytes
Variable
You have to startup nomount and issue a 'create
controlfile' command listing all the bits and pieces
(that you can remember)
hth
connor
--- Sinardy Xing [EMAIL PROTECTED] wrote: Hi
all,
I accidentally rm all my control file, I forgot do
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Hi Robertson,
Your procedure is work for me,
When this database created, the creator kept the create database scripts, so
I able to retrieve some information from there,
(is in $ORACLE/assistants/dbca/jlib/SIDrun.sh)
Thank you, you are really brilliant
Sinardy
-Original Message-
On Tuesday 12 June 2001 03:21, Sinardy Xing wrote:
Hi all,
I accidentally rm all my control file, I forgot do
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Glad to hear your database is now safe and sound.
Now let's hear a little about how you managed to
remove all of your control
I am the last one went home yesterday, so nobody aware of it ; )
Sinardy
-Original Message-
Sent: Wednesday, 13 June 2001 4:25 AM
To: Multiple recipients of list ORACLE-L
On Tuesday 12 June 2001 03:21, Sinardy Xing wrote:
Hi all,
I accidentally rm all my control file, I forgot do