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

ACFS for Database and Flex ASM – Part II

I must thank my fellow DBA Franky Weber Faust for his publication in Portuguese OTN. Objective: Explain and demonstrate the use of ACFS for storing Oracle Home binaries and the database itself, registering the ACFS filesystem to start automatically, configuring the logs to be generated in a unified directory, and displaying ACFS behavior with the […]

Read More

Upgrading Oracle Grid Infrastructure 11gR2 to 12cR2

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). 1. Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 12.2.0.1 to 11.2.0.4 later one. If you […]

Read More