tag:blogger.com,1999:blog-37416821.post1144381777076265258..comments2024-01-03T07:56:53.504+04:00Comments on Oracle Newbie DBA / Apps DBA: LOST ALL Controlfile and Redolog FilesMohammed Tajhttp://www.blogger.com/profile/18022044698097362461noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-37416821.post-20715941087816021932008-01-07T16:38:00.000+04:002008-01-07T16:38:00.000+04:00but the datafile filesize may have been forgotten,...<EM>but the datafile filesize may have been forgotten, or have been grown by Oracle. To get back all these information is a bit tedious.</EM><BR/><BR/>Full proof recovery procedure is depends on backup method and backup method depends on recovery type.<BR/><BR/>Here I show one more procedure to create controlfile when we lost all controlfile WITHOUT BACKUP.Mohammed Tajhttps://www.blogger.com/profile/18022044698097362461noreply@blogger.comtag:blogger.com,1999:blog-37416821.post-3636878385992519522008-01-03T19:57:00.000+04:002008-01-03T19:57:00.000+04:00Sorry, I find it not logical - creating the contro...Sorry, I find it not logical - creating the controlfile require specifying the filesize of the datafile, but the datafile filesize may have been forgotten, or have been grown by Oracle. To get back all these information is a bit tedious.Peter Teohhttps://www.blogger.com/profile/03117965302401056922noreply@blogger.com