Sunday, April 12, 2009

Add New Controlfile To Database

1-conn / as sysdba
2-create pfile='d:\pfile.txt' from spfile;
3-shutdown immediate
4-copy one of the controlfiles in your database with another name like control04.ctl
5-edit the pfile pfile.txt and add the new created controlfile (control04.ctl)
6-startup pfile='d:\pfile.txt'
7-create spfile from pfile='d:\pfile.txt';
8-shutdown immediate
9-startup

database will start with the new created controlfile

No comments: