Rename disk group in Oracle 11g R2
Rename disk group in Oracle 11g R2
In this article will look at renamedg utility introduced in Oracle 11gR2 to change the name of an existing ASM disk group. In order to use the command a disk group needs to be dismounted. Oracle GI is installed on a standalone server to implement ASM and Oracle restart. Although, to rename a disk group seems to be a straightforward task the resource dependencies are important and need to be taken into consideration. The disk group DATA in the exercise is a storage for the ASM spfile and for couple of databases. During the test we will look at how to point the ASM and existing databases to the newly renamed disk group DG. The renamedg utility works in two phases. First phase identifies the disk group, performs a discovery of the disks member of the group, checks if the disk group is mounted and if the group is not mounted checks the member disks and generates the configuration file. Second phase performs the actual renaming. By default the renamed utility combines the two phases, though we can explicitly separate the two phases by running the utility twice with a phase parameter. Note that if using Oracle GI for a standalone server we need to start explicitly ./acfsload start –s from $GI_HOME/bin in comparison to Oracle GI for a cluster.
The utility options
[oracle@oel55 ~]$ renamedg -help
NOTE: No asm libraries found in the system
Parsing parameters..
phase Phase to execute,
(phase=ONE|TWO|BOTH), default BOTH
dgname Diskgroup to be renamed
newdgname New name for the diskgroup
config intermediate config file
check just check-do not perform actual operation,
(check=TRUE/FALSE), default FALSE
confirm confirm before committing changes to disks,
(confirm=TRUE/FALSE), default FALSE
clean ignore errors,
(clean=TRUE/FALSE), default TRUE
asm_diskstring ASM Diskstring (asm_diskstring=’discoverystring’,
‘discoverystring1’ …)
verbose verbose execution,
(verbose=TRUE|FALSE), default FALSE
keep_voting_files Voting file attribute,
(keep_voting_files=TRUE|FALSE), default FALSE
[oracle@oel55 ~]$
Later we will use the renamed utility to rename a disk group data using the default phase=both option with a single call. Below are examples of invoking renamed utility to prepare a configuration file. Note that in order to avoid errors and have a successful completion
- Asm_diskstring need to be specified
- Disk group needs to be dismounted
What if the asm_string is not specified?
oracle@oel55 ~]$ renamedg phase=one dgname=data1 newdgname=dg1 confirm=true config=/tmp/renamedg verbose=true
NOTE: No asm libraries found in the system
Parsing parameters..
Parameters in effect:
Old DG name : DATA1
New DG name : DG1
Phases :
Phase 1
Discovery str : (null)
Confirm : TRUE
Clean : TRUE
Raw only : TRUE
renamedg operation: phase=one dgname=data1 newdgname=dg1 confirm=true config=/tmp/renamedg verbose=true
Executing phase 1
Discovering the group
Performing discovery with string:
KFNDG-00407: file not found; arguments: []
Terminating kgfd context 0xb7f1a050
[oracle@oel55 ~]$
What if the disk group is mounted?
[oracle@oel55 ~]$ renamedg phase=one dgname=data1 newdgname=dg1 confirm=false config=/tmp/renamedg verbose=true asm_diskstring=’/dev/oracleasm/disks/*’
NOTE: No asm libraries found in the system
Parsing parameters..
Parameters in effect:
Old DG name : DATA1
New DG name : DG1
Phases :
Phase 1
Discovery str : /dev/oracleasm/disks/*
Clean : TRUE
Raw only : TRUE
renamedg operation: phase=one dgname=data1 newdgname=dg1 confirm=false config=/tmp/renamedg verbose=true asm_diskstring=/dev/oracleasm/disks/*
Executing phase 1
Discovering the group
Performing discovery with string:/dev/oracleasm/disks/*
Identified disk UFS:/dev/oracleasm/disks/DISK4 with disk number:0 and timestamp (32939882 785868800)
Identified disk UFS:/dev/oracleasm/disks/DISK5 with disk number:1 and timestamp (32939882 785868800)
Identified disk UFS:/dev/oracleasm/disks/DISK6 with disk number:2 and timestamp (32939882 785868800)
Checking for hearbeat…
Re-discovering the group
Performing discovery with string:/dev/oracleasm/disks/*
Identified disk UFS:/dev/oracleasm/disks/DISK4 with disk number:0 and timestamp (32939882 785868800)
Identified disk UFS:/dev/oracleasm/disks/DISK5 with disk number:1 and timestamp (32939882 785868800)
Identified disk UFS:/dev/oracleasm/disks/DISK6 with disk number:2 and timestamp (32939882 785868800)
Checking if the diskgroup is mounted
Checking disk number:0
KFNDG-00405: file not found; arguments: [DATA1]
Terminating kgfd context 0xb7f61050
[oracle@oel55 ~]$
Successful completion of phase one
[oracle@oel55 ~]$ renamedg phase=one dgname=data1 newdgname=dg1 confirm=true config=/tmp/renamedg verbose=true asm_diskstring=’/dev/oracleasm/disks/*’
NOTE: No asm libraries found in the system
Parsing parameters..
Parameters in effect:
Old DG name : DATA1
New DG name : DG1
Phases :
Phase 1
Discovery str : /dev/oracleasm/disks/*
Confirm : TRUE
Clean : TRUE
Raw only : TRUE
renamedg operation: phase=one dgname=data1 newdgname=dg1 confirm=true config=/tmp/renamedg verbose=true asm_diskstring=/dev/oracleasm/disks/*
Executing phase 1
Discovering the group
Performing discovery with string:/dev/oracleasm/disks/*
Identified disk UFS:/dev/oracleasm/disks/DISK4 with disk number:0 and timestamp (32939882 785868800)
Identified disk UFS:/dev/oracleasm/disks/DISK5 with disk number:1 and timestamp (32939882 785868800)
Identified disk UFS:/dev/oracleasm/disks/DISK6 with disk number:2 and timestamp (32939882 785868800)
Checking for hearbeat…
Re-discovering the group
Performing discovery with string:/dev/oracleasm/disks/*
Identified disk UFS:/dev/oracleasm/disks/DISK4 with disk number:0 and timestamp (32939882 785868800)
Identified disk UFS:/dev/oracleasm/disks/DISK5 with disk number:1 and timestamp (32939882 785868800)
Identified disk UFS:/dev/oracleasm/disks/DISK6 with disk number:2 and timestamp (32939882 785868800)
Checking if the diskgroup is mounted
Checking disk number:0
Checking disk number:1
Checking disk number:2
Checking if diskgroup is used by CSS
Generating configuration file..
Completed phase 1
Terminating kgfd context 0xb7f27050
[oracle@oel55 ~]$
[oracle@oel55 ~]$cat /tmp/renamedg
/dev/oracleasm/disks/DISK4 DATA1 DG1
/dev/oracleasm/disks/DISK5 DATA1 DG1
/dev/oracleasm/disks/DISK6 DATA1 DG1
[oracle@oel55 ~]$
Determine the resources that depend on disk group DATA.
-
ASM uses DATA for the spfile
[oracle@oel55 ~]$ srvctl config asm
ASM home: /u01/app/11.2.0/grid
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.253.725013905
ASM diskgroup discovery string: /dev/oracleasm/disks/*
[oracle@oel55 ~]$
- Few databases (DB11P, D11P and REP) are using DATA disk group
[oracle@oel55 ~]$ cat /etc/oratab
#Backup file is /u01/app/oracle/product/11.2.0/db_1/srvm/admin/oratab.bak.oel55 line added by Agent
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ‘:’, is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, ‘#’, are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , “Y”, or should not,
# “N”, be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
+ASM:/u01/app/11.2.0/grid:N
*:/u01/app/oracle/Middleware/oms11g:N
*:/u01/app/oracle/Middleware/agent11g:N
DPS1:/u01/app/oracle/product/11.2.0/db_1:N # line added by Agent
D11P:/u01/app/oracle/product/11.2.0/db_1:N # line added by Agent
REP:/u01/app/oracle/product/11.2.0/db_1:N # line added by Agent
DB11P:/u01/app/oracle/product/11.2.0/db_1:N # line added by Agent
[oracle@oel55 ~]$ srvctl config database -d REP
Database unique name: REP
Database name: REP
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/REP/spfileREP.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
[oracle@oel55 ~]$
[oracle@oel55 ~]$ srvctl config database -d DB11P
Database unique name: DB11P
Database name: DB11P
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/DB11P/spfileDB11P.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
[oracle@oel55 ~]$
[oracle@oel55 ~]$ srvctl config database -d D11P
Database unique name: D11P
Database name: D11P
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/D11P/spfileD11P.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
[oracle@oel55 ~]$
[oracle@oel55 ~]$ srvctl config database -d DPS1
Database unique name: DPS1
Database name: DB11P
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA1/DPS1/spfileDPS1.ora_262
Domain:
Start options: open
Stop options: immediate
Database role: PHYSICAL_STANDBY
Management policy: AUTOMATIC
Disk Groups:
Services:
[oracle@oel55 ~]$
The crs resources are as follow:
[oracle@oel55 ~]$ crsctl status resource
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on oel55
NAME=ora.DATA1.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on oel55
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on oel55
NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE on oel55
NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on oel55
NAME=ora.d11p.db
TYPE=ora.database.type
TARGET=ONLINE
STATE=ONLINE on oel55
NAME=ora.db11p.db
TYPE=ora.database.type
TARGET=ONLINE
STATE=ONLINE on oel55
NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=ONLINE
STATE=ONLINE on oel55
NAME=ora.dps1.db
TYPE=ora.database.type
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.rep.db
TYPE=ora.database.type
TARGET=ONLINE
STATE=ONLINE on oel55
[oracle@oel55 ~]$
Prepare for disk group rename.
- Note the ASM spfile location
- Prepare scripts to rename the file names of the databases using DATA disk group.
- Recreate the spfile to point to the new DG group for each affected database.
ASM spfile is +DATA/asm/asmparameterfile/registry.253.725013905262 and will point to +DG/asm/asmparameterfile/registry.253.725013905
Prepare scripts to rename the file names of the affected databases.
[oracle@oel55 tmp]$ cat d11p.sql
alter database rename file ‘+DATA/d11p/datafile/system.775.725458923’ to ‘+DG/d11p/datafile/system.775.725458923’;
alter database rename file ‘+DATA/d11p/datafile/sysaux.776.725458923’ to ‘+DG/d11p/datafile/sysaux.776.725458923’;
alter database rename file ‘+DATA/d11p/datafile/undotbs1.777.725458923’ to ‘+DG/d11p/datafile/undotbs1.777.725458923’;
alter database rename file ‘+DATA/d11p/datafile/users.746.725458923’ to ‘+DG/d11p/datafile/users.746.725458923’;
alter database rename file ‘+DATA/d11p/onlinelog/group_3.737.725459019’ to ‘+DG/d11p/onlinelog/group_3.737.725459019’;
alter database rename file ‘+DATA/d11p/onlinelog/group_3.655.725459021’ to ‘+DG/d11p/onlinelog/group_3.655.725459021’;
alter database rename file ‘+DATA/d11p/onlinelog/group_2.763.725459017’ to ‘+DG/d11p/onlinelog/group_2.763.725459017’;
alter database rename file ‘+DATA/d11p/onlinelog/group_2.699.725459019’ to ‘+DG/d11p/onlinelog/group_2.699.725459019’;
alter database rename file ‘+DATA/d11p/onlinelog/group_1.757.725459015’ to ‘+DG/d11p/onlinelog/group_1.757.725459015’;
alter database rename file ‘+DATA/d11p/onlinelog/group_1.759.725459017’ to ‘+DG/d11p/onlinelog/group_1.759.725459017’;
[oracle@oel55 tmp]$
[oracle@oel55 tmp]$ cat db11p.sql
alter database rename file ‘+DATA/db11p/datafile/system.770.725452799’ to ‘+DG/db11p/datafile/system.770.725452799’;
alter database rename file ‘+DATA/db11p/datafile/sysaux.771.725452801’ to ‘+DG/db11p/datafile/sysaux.771.725452801’;
alter database rename file ‘+DATA/db11p/datafile/undotbs1.781.725452801’ to ‘+DG/db11p/datafile/undotbs1.781.725452801’;
alter database rename file ‘+DATA/db11p/datafile/users.635.725452801’ to ‘+DG/db11p/datafile/users.635.725452801’;
alter database rename file ‘+DATA/db11p/datafile/example.281.725452961’ to ‘+DG/db11p/datafile/example.281.725452961’;
alter database rename file ‘+DATA/db11p/onlinelog/group_3.314.725452933’ to ‘+DG/db11p/onlinelog/group_3.314.725452933’;
alter database rename file ‘+DATA/db11p/onlinelog/group_3.313.725452937’ to ‘+DG/db11p/onlinelog/group_3.313.725452937’;
alter database rename file ‘+DATA/db11p/onlinelog/group_2.282.725452929’ to ‘+DG/db11p/onlinelog/group_2.282.725452929’;
alter database rename file ‘+DATA/db11p/onlinelog/group_2.315.725452931’ to ‘+DG/db11p/onlinelog/group_2.315.725452931’;
alter database rename file ‘+DATA/db11p/onlinelog/group_1.772.725452925’ to ‘+DG/db11p/onlinelog/group_1.772.725452925’;
alter database rename file ‘+DATA/db11p/onlinelog/group_1.545.725452927’ to ‘+DG/db11p/onlinelog/group_1.545.725452927’;
alter database rename file ‘+DATA/db11p/onlinelog/group_4.354.725478873’ to ‘+DG/db11p/onlinelog/group_4.354.725478873’;
alter database rename file ‘+DATA/db11p/onlinelog/group_4.780.725478873’ to ‘+DG/db11p/onlinelog/group_4.780.725478873’;
alter database rename file ‘+DATA/db11p/onlinelog/group_5.356.725478875’ to ‘+DG/db11p/onlinelog/group_5.356.725478875’;
alter database rename file ‘+DATA/db11p/onlinelog/group_5.330.725478877’ to ‘+DG/db11p/onlinelog/group_5.330.725478877’;
alter database rename file ‘+DATA/db11p/onlinelog/group_6.722.725478877’ to ‘+DG/db11p/onlinelog/group_6.722.725478877’;
alter database rename file ‘+DATA/db11p/onlinelog/group_6.720.725478879’ to ‘+DG/db11p/onlinelog/group_6.720.725478879’;
alter database rename file ‘+DATA/db11p/onlinelog/group_7.719.725478879’ to ‘+DG/db11p/onlinelog/group_7.719.725478879’;
alter database rename file ‘+DATA/db11p/onlinelog/group_7.718.725478881’ to ‘+DG/db11p/onlinelog/group_7.718.725478881’;
[oracle@oel55 tmp]$
[oracle@oel55 tmp]$ cat rep.sql
alter database rename file ‘+DATA/rep/datafile/system.264.725016995’ to ‘+DG/rep/datafile/system.264.725016995’;
alter database rename file ‘+DATA/rep/datafile/sysaux.265.725017009’ to ‘+DG/rep/datafile/sysaux.265.725017009’;
alter database rename file ‘+DATA/rep/datafile/undotbs1.266.725017019’ to ‘+DG/rep/datafile/undotbs1.266.725017019’;
alter database rename file ‘+DATA/rep/datafile/users.268.725017033’ to ‘+DG/rep/datafile/users.268.725017033’;
alter database rename file ‘+DATA/rep/datafile/mgmt_ecm_depot_ts.284.725021583’ to ‘+DG/rep/datafile/mgmt_ecm_depot_ts.284.725021583’;
alter database rename file ‘+DATA/rep/datafile/mgmt_tablespace.285.725021587’ to ‘+DG/rep/datafile/mgmt_tablespace.285.725021587’;
alter database rename file ‘+DATA/rep/datafile/mgmt_ad4j_ts.286.725021595’ to ‘+DG/rep/datafile/mgmt_ad4j_ts.286.725021595’;
alter database rename file ‘+DATA/rep/onlinelog/group_1.258.725016991’ to ‘+DG/rep/onlinelog/group_1.258.725016991’;
alter database rename file ‘+DATA/rep/onlinelog/group_1.259.725016991’ to ‘+DG/rep/onlinelog/group_1.259.725016991’;
alter database rename file ‘+DATA/rep/onlinelog/group_2.260.725016993’ to ‘+DG/rep/onlinelog/group_2.260.725016993’;
alter database rename file ‘+DATA/rep/onlinelog/group_2.261.725016993’ to ‘+DG/rep/onlinelog/group_2.261.725016993’;
alter database rename file ‘+DATA/rep/onlinelog/group_3.262.725016993’ to ‘+DG/rep/onlinelog/group_3.262.725016993’;
alter database rename file ‘+DATA/rep/onlinelog/group_3.263.725016995’ to ‘+DG/rep/onlinelog/group_3.263.725016995’;
[oracle@oel55 tmp]$
Create a pfile in /tmp for each of the databases on DATA disk group.
Make sure that data disk group is not mounted prior to the rename to avoid error KFNDG-00405: file not found; arguments: [DATA]. Start the rename.
[oracle@oel55 ~]$ renamedg dgname=data newdgname=dg asm_diskstring=’/dev/oracleasm/disks/*’ verbose=true
NOTE: No asm libraries found in the system
Parsing parameters..
Parameters in effect:
Old DG name : DATA
New DG name : DG
Phases :
Phase 1
Phase 2
Discovery str : /dev/oracleasm/disks/*
Clean : TRUE
Raw only : TRUE
renamedg operation: dgname=data newdgname=dg asm_diskstring=/dev/oracleasm/disks/* verbose=true
Executing phase 1
Discovering the group
Performing discovery with string:/dev/oracleasm/disks/*
Identified disk UFS:/dev/oracleasm/disks/DISK1 with disk number:0 and timestamp (32939720 -1287618560)
Identified disk UFS:/dev/oracleasm/disks/DISK2 with disk number:1 and timestamp (32939720 -1287618560)
Identified disk UFS:/dev/oracleasm/disks/DISK3 with disk number:2 and timestamp (32939720 -1287618560)
Checking for hearbeat…
Re-discovering the group
Performing discovery with string:/dev/oracleasm/disks/*
Identified disk UFS:/dev/oracleasm/disks/DISK1 with disk number:0 and timestamp (32939720 -1287618560)
Identified disk UFS:/dev/oracleasm/disks/DISK2 with disk number:1 and timestamp (32939720 -1287618560)
Identified disk UFS:/dev/oracleasm/disks/DISK3 with disk number:2 and timestamp (32939720 -1287618560)
Checking if the diskgroup is mounted
Checking disk number:0
Checking disk number:1
Checking disk number:2
Checking if diskgroup is used by CSS
Generating configuration file..
Completed phase 1
Executing phase 2
Looking for /dev/oracleasm/disks/DISK1
Modifying the header
Looking for /dev/oracleasm/disks/DISK2
Modifying the header
Looking for /dev/oracleasm/disks/DISK3
Modifying the header
Completed phase 2
Terminating kgfd context 0xb7f48050
[oracle@oel55 ~]$
Reconfigure ASM
[oracle@oel55 ~]$ srvctl modify asm -p +DG/asm/asmparameterfile/registry.253.725013905
[oracle@oel55 ~]$
[oracle@oel55 ~]$ srvctl start asm
[oracle@oel55 ~]$ srvctl config asm
ASM home: /u01/app/11.2.0/grid
ASM listener: LISTENER
Spfile: +DG/asm/asmparameterfile/registry.253.725013905
ASM diskgroup discovery string: /dev/oracleasm/disks/*
[oracle@oel55 ~]$
Reconfigure the databases for DG
- Modify CRS configuration.
[oracle@oel55 dbs]$ srvctl modify database -d D11P -p ‘+DG/D11P/spfileD11P.ora’
[oracle@oel55 dbs]$ srvctl modify database -d D11P -a DG
[oracle@oel55 dbs]$
- Create a pfile in /tmp. Change the init.ora parameter to point to DG instead of DATA.
- Start the database from the pfile and recreate the spfile.
- Execute the file rename SQL script.
SQL> startup mount pfile=’/tmp/initD11P.ora’
ORACLE instance started.
Total System Global Area 418484224 bytes
Fixed Size 1336932 bytes
Variable Size 318769564 bytes
Database Buffers 92274688 bytes
Redo Buffers 6103040 bytes
Database mounted.
SQL> create spfile=’+DG/D11P/spfileD11P.ora’ from pfile=’/tmp/initD11P.ora’;
File created.
SQL>
- Modify CRS configuration.
[oracle@oel55 dbs]$ cat initREP.ora
SPFILE=’+DG/REP/spfileREP.ora’
[oracle@oel55 dbs]$ srvctl modify database -d REP -p +DG/REP/spfileREP.ora
[oracle@oel55 dbs]$ srvctl modify database -d REP -a DG
[oracle@oel55 dbs]$
- Create a pfile in /tmp. Change the init.ora parameter to point to DG instead of DATA.
- Start the database from the pfile and recreate the spfile.
-
Execute the file rename SQL script.
SQL> startup pfile=’/tmp/initREP.ora’ mount
ORACLE instance started.
Total System Global Area 523108352 bytes
Fixed Size 1337632 bytes
Variable Size 444597984 bytes
Database Buffers 62914560 bytes
Redo Buffers 14258176 bytes
Database mounted.
SQL> create SPFILE=’+DG/REP/spfileREP.ora’ from pfile=’/tmp/initREP.ora’;
File created.
SQL>
- Modify CRS configuration.
[oracle@oel55 dbs]$ cat initDB11P.ora
SPFILE=’+DG/DB11P/spfileDB11P.ora’ # line added by Agent
[oracle@oel55 dbs]$ srvctl modify database -d DB11P -p +DG/DB11P/spfileDB11P.ora
[oracle@oel55 dbs]$ srvctl modify database -d DB11P -a DG
[oracle@oel55 dbs]$
- Create a pfile in /tmp. Change the init.ora parameter to point to DG instead of DATA.
- Start the database from the pfile and recreate the spfile.
-
Execute the file rename SQL script.
SQL> startup pfile=’/tmp/initDB11P.ora’ mount
ORACLE instance started.
Total System Global Area 523108352 bytes
Fixed Size 1337632 bytes
Variable Size 398460640 bytes
Database Buffers 117440512 bytes
Redo Buffers 5869568 bytes
Database mounted.
SQL> create SPFILE=’+DG/DB11P/spfileDB11P.ora’ from pfile=’/tmp/initDB11P.ora’
2 ;
File created.
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
SQL> !oerr ora 38760
38760, 00000, “This database instance failed to turn on flashback database”
// *Cause: Database flashback is on but this instance failed to
// start generating flashback data. Look in alert log for more
// specific errors.
// *Action: Correct the error or turn off database flashback.
We will set flashback off bounce the database and set flashback on to point the flashback logs to DG group.
SQL> alter database flashback off;
Database altered.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 523108352 bytes
Fixed Size 1337632 bytes
Variable Size 398460640 bytes
Database Buffers 117440512 bytes
Redo Buffers 5869568 bytes
Database mounted.
Database opened.
SQL> alter database flashback on;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 523108352 bytes
Fixed Size 1337632 bytes
Variable Size 398460640 bytes
Database Buffers 117440512 bytes
Redo Buffers 5869568 bytes
Database mounted.
Database opened.
SQL>
Summary
Oracle’s 11gR2 renamedg utility can be used to rename a disk group. The disk group has to be dismounted for the rename to complete. Prior to using renamedg utility it is necessary to do some prep work to identify the resources depending on the disk group to be renamed and to point the resources to the newly named disk group.
No comments yet.
-
Archives
- February 2017 (1)
- November 2016 (1)
- October 2016 (1)
- May 2016 (2)
- March 2016 (3)
- December 2014 (2)
- July 2014 (1)
- June 2014 (6)
- May 2014 (5)
- February 2014 (1)
- December 2012 (2)
- November 2012 (8)
-
Categories
-
RSS
Entries RSS
Comments RSS
Leave a Reply