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
Tagged:

Comments

  • User_2025-09-16-13-57-59-401
    User_2025-09-16-13-57-59-401 Posts: 7 Green Ribbon
    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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center