From my previous posting I had mention that I need to recreate my Oracle database control file since I need to increase my MAXDATAFILES parameter.
Yesterday (sunday) I had a chance to manage my control file since I have time to shutdown my server. I log on my AIX server and logon to Oracle SQL Plus.
Connect to my database.
SQL>conn / as sysdba;
Then dump my current control file to a text file.
SQL>alter database backup controlfile to trace as ‘/oracle/[SID]/controlfile.txt’;
Then I copied that file (controlfile.txt) to my local notebook and edit it using my favourite text editor.
Here are list of my old control file :