ACCIDENTALLY data file is added without “+” sign

In RAC or ASM environment, we missed the ‘+’ sign while adding datafile in tablespace. we got error in ora-01110, ora-27037 in alert log.

Solution 1.  Find out the data file number( It is available in the alert log) 2.  use the rman to copy the data to ASM disk group. 3.  offline the […]

Read More

Rebuilding / Moving MGMTDB on Grid Infrastructure 12c

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In this article, we are going to know about how to rebuilding/moving MGMTDB on grid infrastructure 12c. Stop the ora.crf resource on each node in your cluster and disable it so that it does not start automatically:

If your […]

Read More

Deleting diskgroup via asmcmd

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to show that via asmcmd it is also possible to remove a disk group. Let’s briefly see how to do this. We list the disk groups:

So we tried to delete the diskgroup:

Note that […]

Read More

Enable Archive Log Mode In Oracle RAC

1. stop the database service.

2. start the database in mount state.

3. enable archive log mode.

4. Restart the database service (using srvctl)

5. set the archive destination to a ASM DISK

Read More

Move Datafile From File System To ASM Disk In 11g

Below steps need to be followed to move the datafile to ASM disk group. SOLUTION: 1. Make the datafile offline;

2. Connect to RMAN and copy datafile to ASM DISKGROUP

3. Rename the datafile in control file

4. Switch the data file to copy

5. Recover the datafile

6. Make the datafile […]

Read More

How to change ASM SYS Password and Creating SYSASM user 11g.

First we can try with normal method

We cannot change the password for ASM databases via alter user command. Because passwords are managed through password file in ASM. The password should be the one provided when the password file was created, also REMOTE_LOGIN_PASSWORDFILE should be set to EXCLUSIVE on all instances. So only way to […]

Read More

Introducing new disks to ASM using ASMFD

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. This article provides the information to create new disks to ASM using ASMFD. In my cluster, I have 2 nodes: london1 and london2. From one of the ready nodes the newly added shared disk:

Note that this disk has […]

Read More

Separating OCR and Voting Disk in Oracle Clusterware 12c

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Objective: Describe the advantages of separating OCR and RV and also present the process needed to do this. NOTE: Although the procedure was performed in version 11gR2, the steps are the same for version 12c. In this article, we will […]

Read More