missing all control file
Hi all, I accidentally rm all my control file, I forgot do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; do you have any idea how to recover my control files ? This is just a test server so I do not perform any backup datafiles nor control files..., Or do you have unix (Solaris 7) way to recover from files being "rm" Thank you, Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: missing all control file
Hi all, Thanks for your help, CREATE CONTROLFILE is work. Sinardy -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 June 2001 11:08 PM To: LazyDBA.com Discussion Hi Sinardy ! For more detail i am attaching Metalink Note Note:1014502.6 Hope it will help you alot Best Regards Your DBA Salman Faheem [EMAIL PROTECTED] on 06/12/2001 08:17:59 PM To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> cc: The answer lies on Page 563 of Oracle SQL Reference manual from oraprd5 docu cd rom. The steps are: 1. Take full offline database (data files) backup just in case 2. Use svrmgrl to "startup nomount" 3. Issue the create control file command for example: CREATE CONTROLFILE REUSE DATABASE "TDBA" NORESETLOGS NOARCHIVELOG MAXLOGFILES 100 MAXLOGMEMBERS 10MAXDATAFILES 1000 MAXINSTANCES 2 MAXLOGHISTORY 500 LOGFILE GROUP 1 '/u1/..dbf' SIZE 64M, GROUP 2 '... GROUP 3 .. GROUP N.. DATAFILE '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM .; Note that we must use unix FIND command to search all the above files for names and sizes. 4. Recover database (for safe side) 5. alter database open. Oliver Artelt <[EMAIL 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 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 TO TRACE; > > do you have any idea how to recover my control files ? > > This is just a test server so I do not perform any backup datafiles nor > control files..., > > > Or do you have unix (Solaris 7) way to recover from files being "rm" > > > > Thank you, > > > > > Best Regards > > Sinardy > > > > > > Oracle documentation is here: > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a > blank email to [EMAIL PROTECTED] To subscribe: send a > blank email to [EMAIL PROTECTED] Visit the list archive: > http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > By using this list you agree to these > terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: missing all control file
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 Size 5046272 bytes Database Buffers 1638400 bytes Redo Buffers 147456 bytes Then AS LONG AS YOU KNOW HOW YOUR DB was set up you could use the following command. I checked out where all the files were and typed this into a file, basically replicating the Oracle backup control file to trace output.Then from svrmgrl ran it CREATE CONTROLFILE REUSE DATABASE "LRDB" NORESETLOGS NOARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 10 MAXINSTANCES 8 MAXLOGHISTORY 907 LOGFILE GROUP 1 '/usr/app/oracle/admin/leework/LRDB/redoLRDB01.log' SIZE 1M, GROUP 2 '/usr/app/oracle/admin/leework/LRDB/redoLRDB02.log' SIZE 1M, GROUP 3 '/usr/app/oracle/admin/leework/LRDB/redoLRDB03.log' SIZE 1M DATAFILE '/usr/app/oracle/admin/leework/LRDB/system001.dbf', '/usr/app/oracle/admin/leework/LRDB/temp001.dbf', '//usr/app/oracle/admin/leework/LRDB/BRDMK_data001.dbf', '/usr/app/oracle/admin/leework/LRDB/rbs01.dbf', '/usr/app/oracle/admin/leework/LRDB/lee001.dbf'; SVRMGRL>@leecrtctl Statement processed. SVRMGR> alter database open; Statement processed. SVRMGR> BEST OF LUCK but this did work perfectly for me. erm... start using the backup controlfile to trace on a regular basis !!!. Cheers Lee -Original Message- Sent: 12 June 2001 11:21 To: Multiple recipients of list ORACLE-L Hi all, I accidentally rm all my control file, I forgot do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; do you have any idea how to recover my control files ? This is just a test server so I do not perform any backup datafiles nor control files..., Or do you have unix (Solaris 7) way to recover from files being "rm" Thank you, Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: missing all control file
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; > > do you have any idea how to recover my control files > ? > > This is just a test server so I do not perform any > backup datafiles nor > control files..., > > > Or do you have unix (Solaris 7) way to recover from > files being "rm" > > > > Thank you, > > > > > Best Regards > > Sinardy > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Sinardy Xing > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: missing all control file
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/run.sh) Thank you, you are really brilliant Sinardy -Original Message- Lee - lerobe Sent: Tuesday, 12 June 2001 7:40 PM To: Multiple recipients of list ORACLE-L 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 Size 5046272 bytes Database Buffers 1638400 bytes Redo Buffers 147456 bytes Then AS LONG AS YOU KNOW HOW YOUR DB was set up you could use the following command. I checked out where all the files were and typed this into a file, basically replicating the Oracle backup control file to trace output.Then from svrmgrl ran it CREATE CONTROLFILE REUSE DATABASE "LRDB" NORESETLOGS NOARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 10 MAXINSTANCES 8 MAXLOGHISTORY 907 LOGFILE GROUP 1 '/usr/app/oracle/admin/leework/LRDB/redoLRDB01.log' SIZE 1M, GROUP 2 '/usr/app/oracle/admin/leework/LRDB/redoLRDB02.log' SIZE 1M, GROUP 3 '/usr/app/oracle/admin/leework/LRDB/redoLRDB03.log' SIZE 1M DATAFILE '/usr/app/oracle/admin/leework/LRDB/system001.dbf', '/usr/app/oracle/admin/leework/LRDB/temp001.dbf', '//usr/app/oracle/admin/leework/LRDB/BRDMK_data001.dbf', '/usr/app/oracle/admin/leework/LRDB/rbs01.dbf', '/usr/app/oracle/admin/leework/LRDB/lee001.dbf'; SVRMGRL>@leecrtctl Statement processed. SVRMGR> alter database open; Statement processed. SVRMGR> BEST OF LUCK but this did work perfectly for me. erm... start using the backup controlfile to trace on a regular basis !!!. Cheers Lee -Original Message- Sent: 12 June 2001 11:21 To: Multiple recipients of list ORACLE-L Hi all, I accidentally rm all my control file, I forgot do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; do you have any idea how to recover my control files ? This is just a test server so I do not perform any backup datafiles nor control files..., Or do you have unix (Solaris 7) way to recover from files being "rm" Thank you, Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Sinardy Xing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: missing all control file
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 files. When you realized what happened, did you get that all over body buzz that indicates that you may be nearer to death than you ever expected? :) Maybe we can offer some tips to help prevent that kind of error in the future. More importantly, do your user and/or boss know what happened? :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: missing all control file
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 > 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 files. When you realized what happened, did you get that all over body buzz that indicates that you may be nearer to death than you ever expected? :) Maybe we can offer some tips to help prevent that kind of error in the future. More importantly, do your user and/or boss know what happened? :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Sinardy Xing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: missing all control file continue...
Hi all, When I do SELECT name from v$datafile; NAME - ... /disk1/Oracle8i/dbs/MISSING7 /disk1/Oracle8i/dbs/MISSING8 Where are these files came from ? do I lost anything ? When I quickly do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Why the trace file is not generated at my udump (according to my init.ORA setting) It generated at /disk1/Oracle8i/rdbms/log/*.trc (which is not my user_dump_dest path) and this file contain CREATE CONTROLFILE ... DATAFILE '/disk1/Oracle8i/system01.dbf', ... '/disk1/Oracle8i/dbs/MISSING7', '/disk1/Oracle8i/dbs/MISSING8' ; ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING7' OFFLINE; ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING8' OFFLINE; Thank you, Sinardy -Original Message- Xing Sent: Thursday, 14 June 2001 10:40 AM To: Multiple recipients of list ORACLE-L Hi all, Thanks for your help, CREATE CONTROLFILE is work. Sinardy -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 June 2001 11:08 PM To: LazyDBA.com Discussion Hi Sinardy ! For more detail i am attaching Metalink Note Note:1014502.6 Hope it will help you alot Best Regards Your DBA Salman Faheem [EMAIL PROTECTED] on 06/12/2001 08:17:59 PM To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> cc: The answer lies on Page 563 of Oracle SQL Reference manual from oraprd5 docu cd rom. The steps are: 1. Take full offline database (data files) backup just in case 2. Use svrmgrl to "startup nomount" 3. Issue the create control file command for example: CREATE CONTROLFILE REUSE DATABASE "TDBA" NORESETLOGS NOARCHIVELOG MAXLOGFILES 100 MAXLOGMEMBERS 10MAXDATAFILES 1000 MAXINSTANCES 2 MAXLOGHISTORY 500 LOGFILE GROUP 1 '/u1/..dbf' SIZE 64M, GROUP 2 '... GROUP 3 .. GROUP N.. DATAFILE '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM .; Note that we must use unix FIND command to search all the above files for names and sizes. 4. Recover database (for safe side) 5. alter database open. Oliver Artelt <[EMAIL 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 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 TO TRACE; > > do you have any idea how to recover my control files ? > > This is just a test server so I do not perform any backup datafiles nor > control files..., > > > Or do you have unix (Solaris 7) way to recover from files being "rm" > > > > Thank you, > > > > > Best Regards > > Sinardy > > > > > > Oracle documentation is here: > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a > blank email to [EMAIL PROTECTED] To subscribe: send a > blank email to [EMAIL PROTECTED] Visit the list archive: > http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > By using this list you agree to these > terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.o
RE: missing all control file continue...
Uh oh, What has happened here is there are a couple of datafiles in the data dictionary that you have missed in your create controlfile statement. You should be able to rename them to whatever the files are called on the OS. Check out Chapter 12 of the Oracle Backup and Recovery Guide Manual for a full explanation. Lee -Original Message- Sent: 14 June 2001 09:00 To: Multiple recipients of list ORACLE-L Hi all, When I do SELECT name from v$datafile; NAME - ... /disk1/Oracle8i/dbs/MISSING7 /disk1/Oracle8i/dbs/MISSING8 Where are these files came from ? do I lost anything ? When I quickly do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Why the trace file is not generated at my udump (according to my init.ORA setting) It generated at /disk1/Oracle8i/rdbms/log/*.trc (which is not my user_dump_dest path) and this file contain CREATE CONTROLFILE ... DATAFILE '/disk1/Oracle8i/system01.dbf', ... '/disk1/Oracle8i/dbs/MISSING7', '/disk1/Oracle8i/dbs/MISSING8' ; ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING7' OFFLINE; ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING8' OFFLINE; Thank you, Sinardy -Original Message- Xing Sent: Thursday, 14 June 2001 10:40 AM To: Multiple recipients of list ORACLE-L Hi all, Thanks for your help, CREATE CONTROLFILE is work. Sinardy -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 June 2001 11:08 PM To: LazyDBA.com Discussion Hi Sinardy ! For more detail i am attaching Metalink Note Note:1014502.6 Hope it will help you alot Best Regards Your DBA Salman Faheem [EMAIL PROTECTED] on 06/12/2001 08:17:59 PM To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> cc: The answer lies on Page 563 of Oracle SQL Reference manual from oraprd5 docu cd rom. The steps are: 1. Take full offline database (data files) backup just in case 2. Use svrmgrl to "startup nomount" 3. Issue the create control file command for example: CREATE CONTROLFILE REUSE DATABASE "TDBA" NORESETLOGS NOARCHIVELOG MAXLOGFILES 100 MAXLOGMEMBERS 10MAXDATAFILES 1000 MAXINSTANCES 2 MAXLOGHISTORY 500 LOGFILE GROUP 1 '/u1/..dbf' SIZE 64M, GROUP 2 '... GROUP 3 .. GROUP N.. DATAFILE '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM .; Note that we must use unix FIND command to search all the above files for names and sizes. 4. Recover database (for safe side) 5. alter database open. Oliver Artelt <[EMAIL 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 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 TO TRACE; > > do you have any idea how to recover my control files ? > > This is just a test server so I do not perform any backup datafiles nor > control files..., > > > Or do you have unix (Solaris 7) way to recover from files being "rm" > > > > Thank you, > > > > > Best Regards > > Sinardy > > > > > > Oracle documentation is here: > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a > blank email to [EMAIL PROTECTED] To subscribe: send a > blank email to [EMAIL PROTECTED] Visit the list archive: > http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > By using this list you agree to these > terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms: http://www.lazydba.com/legal.html Oracle docu
RE: missing all control file continue...
Hi, You have probably created this database by cloning another one and left out the temp tablespace or something. I clone without the temp tablespace because test needs smaller temp tablespace and I get the same messages. They should also show up in your alert log. Jack "Sinardy Xing" csis.com>cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: missing all control file continue... [EMAIL PROTECTED] om 14-06-2001 10:00 Please respond to ORACLE-L Hi all, When I do SELECT name from v$datafile; NAME - ... /disk1/Oracle8i/dbs/MISSING7 /disk1/Oracle8i/dbs/MISSING8 Where are these files came from ? do I lost anything ? When I quickly do ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Why the trace file is not generated at my udump (according to my init.ORA setting) It generated at /disk1/Oracle8i/rdbms/log/*.trc (which is not my user_dump_dest path) and this file contain CREATE CONTROLFILE ... DATAFILE '/disk1/Oracle8i/system01.dbf', ... '/disk1/Oracle8i/dbs/MISSING7', '/disk1/Oracle8i/dbs/MISSING8' ; ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING7' OFFLINE; ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING8' OFFLINE; Thank you, Sinardy -Original Message- Xing Sent: Thursday, 14 June 2001 10:40 AM To: Multiple recipients of list ORACLE-L Hi all, Thanks for your help, CREATE CONTROLFILE is work. Sinardy -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 June 2001 11:08 PM To: LazyDBA.com Discussion Hi Sinardy ! For more detail i am attaching Metalink Note Note:1014502.6 Hope it will help you alot Best Regards Your DBA Salman Faheem [EMAIL PROTECTED] on 06/12/2001 08:17:59 PM To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> cc: The answer lies on Page 563 of Oracle SQL Reference manual from oraprd5 docu cd rom. The steps are: 1. Take full offline database (data files) backup just in case 2. Use svrmgrl to "startup nomount" 3. Issue the create control file command for example: CREATE CONTROLFILE REUSE DATABASE "TDBA" NORESETLOGS NOARCHIVELOG MAXLOGFILES 100 MAXLOGMEMBERS 10MAXDATAFILES 1000 MAXINSTANCES 2 MAXLOGHISTORY 500 LOGFILE GROUP 1 '/u1/..dbf' SIZE 64M, GROUP 2 '... GROUP 3 .. GROUP N.. DATAFILE '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM, '/u2/.dbf' SIZE xM .; Note that we must use unix FIND command to search all the above files for names and sizes. 4. Recover database (for safe side) 5. alter database open. Oliver Artelt <[EMAIL 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 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 TO TRACE; > > do you have any idea how to recover my control files ? > > This is just a test server so