Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

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

  1. Asm_diskstring need to be specified
  2. 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.

  1. 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 ~]$

  1. 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.

  1. Note the ASM spfile location
  2. Prepare scripts to rename the file names of the databases using DATA disk group.
  3. 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

  1. 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]$

  1. Create a pfile in /tmp. Change the init.ora parameter to point to DG instead of DATA.
  2. Start the database from the pfile and recreate the spfile.
  3. 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>

  1. 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]$

  1. Create a pfile in /tmp. Change the init.ora parameter to point to DG instead of DATA.
  2. Start the database from the pfile and recreate the spfile.
  3. 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>

  1. 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]$

  1. Create a pfile in /tmp. Change the init.ora parameter to point to DG instead of DATA.
  2. Start the database from the pfile and recreate the spfile.
  3. 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.

January 11, 2010 - Posted by | oracle

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: