In this article we will present how to apply and remove PSU in Grid Infrastructure Home on only one node using the conflict resolution method with roll forward method. To do this we need a RAC of at least 2 nodes. If you want to patch on Database Home in Oracle 12c then click here […]
Category: ORACLE RAC
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: [root@rac1 ~]# crsctl […]
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: [oracle@london1 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Logical_Sector Block […]
Enable Archive Log Mode In Oracle RAC
1. stop the database service. srvctl stop database -d RAC 2. start the database in mount state. srvctl start database -d RAC -o mount 3. enable archive log mode. SQL> alter database archivelog; Database altered. 4. Restart the database service (using srvctl) srvctl stop database -d RAC srvctl start database -d RAC 5. set the […]
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; SQL> select file_name from dba_data_files; FILE_NAME ——————————————————————————– +DATA/RAC2/DATAFILE/system.260.934026715 +DATA/RAC2/DATAFILE/sysaux.261.934026717 +DATA/RAC2/DATAFILE/undotbs1.262.934026719 +DATA/RAC2/DATAFILE/undotbs2.264.934026727 +DATA/RAC2/DATAFILE/users.265.934026729 /export/home/oracle/user02.dbf alter database datafile ‘/export/home/oracle/user01.dbf’ offline; 2. Connect to RMAN and copy datafile to ASM DISKGROUP RMAN> copy datafile ‘/export/home/oracle/user02.dbf’ to ‘+DATA/RAC2/DATAFILE/user02.db’; Starting backup […]
How to change ASM SYS Password and Creating SYSASM user 11g.
First we can try with normal method SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME —————- +ASM SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>; ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password> * ERROR at line 1: ORA-01109: database not open We cannot change the password for ASM databases via alter user command. Because passwords are […]
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: [root@london1 ~]# ls -l /dev/sdf brw-rw—- […]
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 […]
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 […]
Getting Started with Automatic Storage Management Cluster FileSystem (ACFS) – Part I
I must thank my fellow DBA Franky Weber Faust for his publication in Portuguese OTN. Purpose: To present the benefits and reasons for using ACFS and to initially configure ACFS for use. The Automatic Storage Management Cluster File System (ACFS) was introduced in the second release of Oracle 11g in 2009 and initially there was no […]