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.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
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 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
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 sinardyxing@b To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] csis.comcc: (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 I do not perform any backup datafiles nor control files..., Or do you have unix (Solaris 7) way to recover from files being rm