Database Administration (MOSC)

MOSC Banner

Creating a new controlfile without an existing controlfile and getting ORA-1163

Louis J. Crabtree
Louis J. Crabtree Posts: 1 Newbie
edited Mar 30, 2009 7:53AM in Database Administration (MOSC) 1 comment

Comments

  • You went to a great deal of work. I executed "alter database backup controlfile to trace" on Oracle versions 8, 9, and 10. In all cases sizes were specified for the log files, but no size was specified for any of the datafiles. I believe that in a create controlfile statement, you can omit the sizes for datafiles altogether. None the less, you deserve a great deal of credit in sucessfully recovering a database in what is always a stress filled time.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center