Come spostare un controlfile da un diskgroup ad un altro

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
Connettersi a:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
con il Partitioning, Real Application Clusters, Automatic Storage Management,
Oracle Label Security,
Data Mining e Real Application Testing options
dbbox1>show parameter control
NAME TYPE VALUE
———————————— ———– ——————————
control_file_record_keep_time integer 7
control_files string +DBBOX_DATA_DG/dbbox/contr
ol01.ctl, +DBBOX_FRA_DG/ddbox
/control02.ctl

Potrebbero interessarti anche...