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

Potrebbero interessarti anche...

Lascia un commento

Il tuo indirizzo email non sarà pubblicato. I campi obbligatori sono contrassegnati *