How to move controlfile from one diskgroup to another

dbbox2>show parameter control
NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 7
control_files string +DBBOX_DATA_DG/dbbox/contr
ol01.ctl, +DBOLD_FRA_DG/dbold
/control02.ctl
alter system set control_files=’+DBBOX_DATA_DG/dbbox/control01.ctl’,’
+DBBOX_FRA_DG/dbbox/control02.ctl’ scope=spfile sid=’*’;
oracle11@vboxdb:dbbox1 # srvctl stop database -d dbbox -o immediate
ASMCMD> cp +DBBOX_DATA_DG/dbbox/control01.ctl +DBBOX_FRA_DG/dbbox/control02.ctl
copying +DBBOX_DATA_DG/dbbox/control01.ctl -> +DBBOX_FRA_DG/dbbox/control02.ctl
ASMCMD> ls -lrt DBBOX_FRA_DG/dbbox/control02.ctl
WARNING:option ‘r’ is deprecated for ‘ls’
please use ‘reverse’
Type Redund Striped Time Sys Name
N control02.ctl => +DBBOX_FRA_DG/dbbox/CONTROLFILE/control02.ctl.713.881859415
oracle11@vboxdb:dbbox1 # srvctl start database -d dbbox
oracle11@vboxdb:dbbox1 # sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 8 16:58:12 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
Oracle Label Security,
Data Mining and Real Application Testing options

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *