Srvctl Add Database Example
Add RAC DB Let me ask you a question, why would you like to add a RAC database to a cluster? In my experience, there're… Read More »Srvctl Add Database Example
Parameter File (PFILE)
How to Resolve ORA-29760: instance_number parameter not specified
ORA-29760 ORA-29760: instance_number parameter not specified means that Oracle cannot find any INSTANCE_NUMBER for given instance names in the parameter file to startup the instance.… Read More »How to Resolve ORA-29760: instance_number parameter not specified
Where is Oracle Control File Location
Oracle Control File Location We use different ways to find out the location of control file when the database is online and offline. 1. When… Read More »Where is Oracle Control File Location
How RMAN Duplicate 19c Standby Database
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… Read More »How RMAN Duplicate 19c Standby Database
How to Resolve ORA-00304: requested INSTANCE_NUMBER is busy
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… Read More »How to Resolve ORA-00304: requested INSTANCE_NUMBER is busy
How to Restore RAC Database from RMAN Backup Set
For 10g RAC database restoration, you may check: How to Restore 10g RAC Database from a Backup Set. Suppose we have restored 12c clusterware back.… Read More »How to Restore RAC Database from RMAN Backup Set
How to Restore 10g RAC Database from a Backup Set
For 12c RAC database restoration, you may check: How to Restore 12c RAC Database from a Backup Set. Suppose we have recovered 10g CRS and… Read More »How to Restore 10g RAC Database from a Backup Set
How to Resolve SPFILE in DB_UNKNOWN
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… Read More »How to Resolve SPFILE in DB_UNKNOWN
How to Change SPFILE Location in Oracle
ALTER SYSTEM SET SPFILE Before reading, you have to know that there's no ALTER SYSTEM SET SPFILE statement in Oracle, because we can never write… Read More »How to Change SPFILE Location in Oracle
How to Change Control File Location in Oracle
ALTER SYSTEM SET CONTROL_FILES In this post, I will show you how to change control file location in a single-instance and a cluster database. Change… Read More »How to Change Control File Location in Oracle