RAC

How to Restore 12c RAC Database by a Backup Set

Posted on
For 10g RAC database restoration, you may check: How to Restore 10g RAC Database by a Backup Set. Suppose we have restored 12c clusterware back. Now we can start to restore 12c cluster database. Our goal in this post is to use a backup set on one of RAC nodes to restore the database. First […]
ASM

How to Resolve SPFILE in DB_UNKNOWN

Posted on
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN in ASM. Is it a bug dedicated to Oracle 10g RAC (Bug 5370663)? No, I saw it too in 12c R1 RAC restoration. Let’s reproduce the problem. First, check what […]
ACFS

How to Create a ACFS File System on 18c

Posted on
Create ACFS File System First of all, make sure everything is ready on grid-level. [root@primary01 ~]# su – grid [grid@primary01 ~]$ crsctl check crs [grid@primary01 ~]$ crsctl status resource -t Create a Volume In this case, We allocate 80GB for the new volume ORADATA1 from a ASM disk group, DATA. [grid@primary01 ~]$ asmcmd volcreate -G […]
ASM

How to Copy Files From One ASM Instance to Another

Posted on
ASM in Oracle 11g grid infrastructure has been improved a lot on the storage operations. For instance, the utility ASMCMD offers several new commands to operate with the storage and make DBA more easily to control the storage, especially on copying files, the “cp”. The syntax of cp iscp [-i][-f][connect_str:]src_file [connect_str:]tgt_fileIn the syntax description, “connect_str” is […]
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 […]