Hi all,
When I do
SELECT name from v$datafile;
NAME
-------------------------------------
...
/disk1/Oracle8i/dbs/MISSING00007
/disk1/Oracle8i/dbs/MISSING00008
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/MISSING00007',
'/disk1/Oracle8i/dbs/MISSING00008'
;
ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING00007' OFFLINE;
ALTER DATABASE DATAFILE '/disk1/Oracle8i/dbs/MISSING00008' 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 10 MAXDATAFILES 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).
--
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).