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.



0 comments:
Post a Comment