Purpose of Catalog Database A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog. Catalog Database can be two types Base recovery catalog Virtual […]
Monthly Archives: August 2018
Basic of RMAN Backup and Recovery Scenario
Backup and recovery is a common task in DBA’s Daily Routine. Let’s have looked over the process to take backup of Oracle database and know about the process to recover the database. Check the archive log status SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log […]
RMAN Time Based Recovery
RMAN is the most useful tool for Oracle in DBA’s life. Today’s post is about “RMAN Time Based Recovery”. Let’s have look on the steps. First, take the full backup. RMAN> run { allocate channel c1 device type disk; allocate channel c2 device type disk; backup database and archivelog all delete input; } Create a […]
Generating AWR report from Active Dataguard
Oracle 12.2 came up with a new feature that we can generate AWR report from Physical Standby database if we have enabled active datagaurd. We need to perform the following steps to enable AWR reporting from a physical standby database. Step 1: Unlock SYS$UMF user and change its password using SYS user. SYS$UMF account is used […]
ORA-00600 [KUTYXTTE_TRANSFORM:FAILED]
Recently started seeing this error on few of the Exadata environments. ORA–00600: internal error code, arguments:[KUTYXTTE_TRANSFORM:FAILED] As per metalink this is a known Bug 28194173 Patch 28194173: SQL ON 12.2 QUARANTINED AND CELL THROWING ORA-00600 [KUTYXTTE_TRANSFORM:FAILED] I’ve seen this in 12.2.
ORA-04030:QERGH hash-agg,kllcqas:kllsltba
In Oracle 12.2, ORA-04030:QERGH hash-agg,kllcqas:kllsltba, then we need do the following [oracle@local03 run]$ grep CRS_LIMIT_OPENFILE /u01/app/12.2.0.1/grid/crs/install/s_crsconfig_local03_env.txt Old value CRS_LIMIT_OPENFILE=65536 We need to change the value and restart the CRS New value CRS_LIMIT_OPENFILE=400000
ORA-600[KCLANTILOCK_17]
Recently started seeing this error on few of the RAC environments. ORA–00600: internal error code, arguments:[ORA-600[KCLANTILOCK_17] After upgrade to 12.2, Due to this Instance got crashed. As per metalink this is a known Bug 27162390 Patch 27162390: LNX64-181-RAC: LMS HIT ORA-600[KCLANTILOCK_17], INST CRASH I’ve seen this in 12.2. As per Oracle it’s fixed in version 18.1
ORA-600 [KDZA_CHECK_EQ NOT IN DICTIONARY]
Recently started seeing this error on few of the RAC environments. ORA–00600: internal error code, arguments:[KDZA_CHECK_EQ NOT IN DICTIONARY] As per metalink this is a known Bug 24818566 Patch 24818566: SQLLOAD FAILED WITH ORA-600 [KDZA_CHECK_EQ NOT IN DICTIONARY] I’ve seen this in 11204 ,12102,12.2 both. As per Oracle it’s fixed in version 18.1
Upgrade and Patch Application in Application Container
In previous article we have seen Installing Application and Synchronizing it with Application PDB. Introduction to Application Container Application Container Creation and Installation of Application In this article, we will see upgrading Application and Patching Application. 1. Upgrade Application in Application Container : Before starting application upgrade you need to know the current version of […]
Creating Application PDB and Syncing with Application Root
In a previous post, we have seen creation steps of Application Container and Installation of Application in the Application container. Application Container Creation and Installation of Application In this article, we will see Creation Steps of Application PDB and synchronization of Application PDB with Application Container. Create application PDB: Step1: Connect to application root : […]