Data Guard

How to Duplicate a 19c Physical Standby Database

Posted on
You don’t have to create an empty database on the standby server for building a standby database. In this post, I will show you how to duplicate a 19c physical standby database from scratch by the following sections. Password File File Management Mode Parameter File Necessary Directories Name Resolution Connect Identifiers Listeners Force Logging RMAN […]
RAC

How to Resolve Srvctl Start Database ORA-00304: requested INSTANCE_NUMBER is busy

Posted on
Srvctl Start Database ORA-00304 Saw some errors when I tried to startup a cluster database by srvctl. [oracle@primary01 ~]$ srvctl start database -d compdb PRCR-1079 : Failed to start resource ora.compdb.db CRS-5017: The resource action “ora.compdb.db start” encountered the following error: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: […]
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 […]
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 […]
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 […]
PFILE and SPFILE

How to Change SPFILE Location

Posted on
Change SPFILE Location Generally, we don’t change SPFILE location, because it should be found in the default location, $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora any time to startup the instance without any explicit indication. SQL> startup Which means, the database will find an appropriate SPFILE or PFILE in the default location to startup the instance. Of course, anything is possible […]
Control File

How to Change Control File Location

Posted on
Change Control File Location Here are the steps to change the location of control file: Stop Database Service Copy Control File to New Location Create PFILE from Current SPFILE Modify Control File Location in PFILE Restore SPFILE from Modified PFILE Startup NOMOUNT to Check New Setting Open Database If you’d like to move SPFILE as […]
Administration

How to Move Oracle Database

Posted on
Actually, this topic “How to Move Oracle Database” follows my previous post: How to Move ORACLE HOME. But I think it can be used in any moving operations. Generally speaking, this post will include the following subtle topics: How to move spfile How to move control files How to move database files How to move […]
PFILE and SPFILE

The Default Location of SPFILE and PFILE for Linux and Windows

Posted on
Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows. For Linux/Unix SPFILE <ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora PFILE <ORACLE_HOME>/dbs/init<ORACLE_SID>.ora For Windows Please note that, for Windows, directory name and filename are case-insensitive. SPFILE <ORACLE_HOME>\database\spfile<ORACLE_SID>.ora PFILE <ORACLE_BASE>\admin\<ORACLE_SID>\pfile\init.ora.<n> There’s no typos in the above path. The default location of […]