tag:blogger.com,1999:blog-697307722356110163.post2801939523145251205..comments2023-10-19T08:14:15.629-04:00Comments on Halimdba: How can recover database after deleting/corrupted all control files in oracle .halimdbahttp://www.blogger.com/profile/06064045814557676169noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-697307722356110163.post-11718579494222205762011-08-03T00:57:55.642-04:002011-08-03T00:57:55.642-04:00thanks RAJ .thanks RAJ .halimdbahttps://www.blogger.com/profile/06064045814557676169noreply@blogger.comtag:blogger.com,1999:blog-697307722356110163.post-30649791442632348732011-08-02T04:43:05.756-04:002011-08-02T04:43:05.756-04:00Hello Halim,
Link is not working, please update.
...Hello Halim,<br />Link is not working, please update.<br /><br />You can also create a new control file by "CREATE CONTROLFILE" Statement.<br /><br />The Syntax is:<br /><br />CREATE CONTROLFILE<br /> SET DATABASE prod<br /> LOGFILE GROUP 1 ('/u01/oracle/prod/redo01_01.log',<br /> '/u01/oracle/prod/redo01_02.log'),<br /> GROUP 2 ('/u01/oracle/prod/redo02_01.log',<br /> '/u01/oracle/prod/redo02_02.log'),<br /> GROUP 3 ('/u01/oracle/prod/redo03_01.log',<br /> '/u01/oracle/prod/redo03_02.log')<br /> RESETLOGS<br /> DATAFILE '/u01/oracle/prod/system01.dbf' SIZE 3M,<br /> '/u01/oracle/prod/rbs01.dbs' SIZE 5M,<br /> '/u01/oracle/prod/users01.dbs' SIZE 5M,<br /> '/u01/oracle/prod/temp01.dbs' SIZE 5M<br /> MAXLOGFILES 50<br /> MAXLOGMEMBERS 3<br /> MAXLOGHISTORY 400<br /> MAXDATAFILES 200<br /> MAXINSTANCES 6<br /> ARCHIVELOG;<br /><br />Regards,<br />Raj<br /><a href="http://www.stellaroracledatabaserecovery.com/" rel="nofollow">Stellar Oracle Recovery</a>Rajhttps://www.blogger.com/profile/05020900054347222949noreply@blogger.com