Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to create controlf file from scratch when there is no backup in rman,catalog or trace.

2638616Sep 5 2015 — edited Sep 14 2015

Hi

I am newbie , I know that we can restore the control file by using RMAN configure autobackup feature or by connecting Catalog

or issuing Alter database backup controlfile to trace .

but let us assume that there is no backup . You have the database running in nomount . I came across a blog that instructed to create control file manually and when there is any expected block number error came , the blogger used the forumale something like expected block number * 1024 / something . Lost the link to that blog

was just wondering is it even possible to create a controlfile from scratch . with limited information like datafile location , redo log size / location .

please can anyone let me know this in detail or shoot me that link !

Thanks

This post has been answered by Pavan Kumar on Sep 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2015
Added on Sep 5 2015
10 comments
2,199 views