steps for creating a controlfile


follow these simple steps to create a new controlfile

Step 1)_backingup the controlfile to trace this will create a readable format of the controlfile

Step 2)_shutdown the database

Step 3)_make necesarry changes for the new location where you want to copy your database files

Step 4)_open the traced controlfile and get the script for creation of new controlfile,copy the lines marked in the red box

Step 5)_make necessary changes in the script which you get from the traced controlfile,modify the locations of all the files to the new location where you copied your database files

Step 6)_start the database in nomount state

Step 7)_create the controlfile using the script you get from traced controlfile copy and paste the scripts from Step 5

step 8)_now open the database using alter database open command

NOTE-if you deleted the previous controlfiles then remove the reuse clause from the craete controlfile statement in step 5 or step 7