RE: missing all control file continue...

2001-06-14 Thread Sinardy Xing
] 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

RE: missing all control file continue...

2001-06-14 Thread Robertson Lee - lerobe
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

RE: missing all control file continue...

2001-06-14 Thread nlzanen1
[EMAIL PROTECTED] csis.comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: missing all control file continue... [EMAIL PROTECTED

RE: missing all control file

2001-06-13 Thread Sinardy Xing
/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

RE: missing all control file

2001-06-12 Thread Robertson Lee - lerobe
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

Re: missing all control file

2001-06-12 Thread Connor McDonald
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;

RE: missing all control file

2001-06-12 Thread Sinardy Xing
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-

Re: missing all control file

2001-06-12 Thread Jared Still
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

RE: missing all control file

2001-06-12 Thread Sinardy Xing
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