Data Guard

How to Build Asymmetric Standby Database for Data Guard

Posted on
Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or RAC to RAC. Practically, we could have downgraded standby servers in hardware specifications. For example, we may use 16 cores per instance on the primary side but use 8 cores […]
RAC

How to Restore 10g RAC Database by a Backup Set

Posted on
For 12c RAC database restoration, you may check: How to Restore 12c RAC Database by a Backup Set. Suppose we have recovered 10g CRS and ASM from a fatal crash, but the database is still waiting for our saving. Luckily, we have a backup set of the database, which is a full and consistent database […]
ACFS

How to Create Database on ACFS

Posted on
Assuming that you have created a ACFS file system for the database creation. Then you can go on reading this post. Create a Database on ACFS First of all, make sure everything is ready including ACFS mount point which is /u02/oradata1 in this case. [grid@primary01 ~]$ crsctl status resource ora.data.oradata1.acfs -t ——————————————————————————– Name      […]
ASM

How to Create a ASM Disk Group

Posted on
To isolate non-crucial backups from crucial data in the current disk group DATA, a separate new disk group with new disks is needed to put all backups. For meeting our new requirement, we plan to create a disk group called FRA, i.e. Fast Recovery Area, by ourselves. The utility that we are going to use […]
ASMLib

How to Resolve ASMLib Scanned No Disks on Boot

Posted on
ASMLib Scanned Nothing on Boot-Time ASMLib seems to be started too soon to scan iSCSI disks which may not be ready on boot in Enterprise Linux 7. [root@primary01 ~]# oracleasm listdisks [root@primary01 ~]# oracleasm-discover Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so [ASM Library – Generic Linux, version 2.0.12 (KABI_V2)] Nothing was found there when we tried to list […]
ASM

How to Resolve ASMLib Fails to Open Disk Candidates

Posted on
ASMLib Seems Good In my grid installation plan for 18c database, I use ASMLib to make device path persistent for ASM candidate disks. As a result, oracleasm should be able to recognize those disks as expected. [root@primary01 ~]# oracleasm listdisks ASMDISK01 ASMDISK02 [root@primary01 ~]# oracleasm-discover Using ASMLib from /opt/oracle/extapi/64/asm/orcl/1/libasm.so [ASM Library – Generic Linux, version […]
ASM

How to Resolve INS-30502 No ASM disk group found

Posted on
This error is quite strange and thrown during grid infrastructure installation.INS-30502 No ASM disk group found.Why can not oracle access any ASM disk groups? How can it be? I tried several ways to solve the problem, only the last solution worked.Switching the group of owner of ASM disks from asmadmin to oinstall whcih is oracle default group. Not […]
Control File

How to Check Control File Size

Posted on
Check Control File Size Control file is a file that have several file attributes including size, but when database is stored upon raw devices, your control files are just symbolic links that represent raw devices. You have no way to check the usage of a raw device. Here are several ways that can check the […]