Method 1 – preferred by me:
- alter system parameter to point to new (planed) location of controlfiles
alter system set control_files = '/dir1/CONTROL01.CTL' , '/dir2/CONTROL02.CTL' , '/dir3/CONTROL03.CTL' scope=spfile;
- shutdown database,
- copy one of controlfile to new locations,
- startup database.
- shutdown database,
- copy one of controlfile to new locations,
- copy spfile to pfile:
create pfile from spfile;
- manually edit pfile,
- copy pfile back to spfile:
create spfile from pfile;
- startup database.
4 comments:
Beautify! U r Great!
nice.thank u for ur golden help.
Thanks..
Thank you so much, for your help
Post a Comment