| loss of controlfile [message #64401] |
Sat, 22 January 2005 13:45  |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
Hi,
I have lost controlfile, and I dont have any backup of my controlfile. How can I startup my database?
Thank you.
|
|
|
|
| Re: loss of controlfile [message #64405 is a reply to message #64401] |
Sun, 23 January 2005 21:48  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
if u lose the controlfile,
then u needto create a new one only
Create the control file using the CREATE CONTROLFILE statement with the NORESETLOGS option (provided u should know the datafile names and lcoations)
Eg:
CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16MAXLOGHISTORY 1600
LOGFILE
GROUP 1
'/diska/prod/sales/db/log1t1.dbf',
'/diskb/prod/sales/db/log1t2.dbf'
) SIZE 100K
GROUP 2
'/diska/prod/sales/db/log2t1.dbf',
'/diskb/prod/sales/db/log2t2.dbf'
) SIZE 100K,
DATAFILE
'/diska/prod/sales/db/database1.dbf',
'/diskb/prod/sales/db/filea.dbf'
;
Recover the database
RECOVER DATABASE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
