Come spostare un controlfile da un diskgroup ad un altro

Come spostare un controlfile da un diskgroup ad un altro
  • 6
    Ago

Come spostare un controlfile da un diskgroup ad un altro

twittergoogle_pluslinkedin

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