Posted by : Mahe ORA-17502: ksfdcre:4 Failed to create file “FILE NAME” / ORA-15173: entry ‘string’ does not exist in directory ‘string’ RMAN> restore spfile from ‘+FRA/SRPRIMT/AUTOBACKUP/2016_07_10/s_788290484.315.788290487’; Starting restore at 10-JUL-16 using…
Read MorePosted by : Karthick This Post demonstrates the Dataguard status connection lost contact from Primary database The Data Guard status of xxxx is Error ORA-03135: connection lost contact from Primary…
Read MorePosted by : Mahe This post will demonstrate the Backup Failure because of Control File Enqueue Error : RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002:…
Read MorePosted by : Unknown This Post will demonstrate to enabling the trace and take tkprof Step 1 : Check Request ID from Find Concurrent request screen (In my case…
Read MorePosted by : Selvakumar Raja This Post will demonstrate the Steps to Modify Scan listener port . Due to security reasons some of environment require using a different port…
Read MorePosted by Sundaravel Ramasubbu Introduction : In this session we will see How to set up Data Guard Broker. NOTE: Environment in my case Prerequisite Check DG_BROKER_START parameter on Primary and…
Read MorePosted by Abishek Kathiresan Introduction: The details of changes in the blocks of the database after the last backup are written in the block change tracking file. RMAN uses this…
Read MorePosted by Mahendran Manickam Introduction: Here we will see How to rename a constraint in Oracle Database. Step 1: Login to sqlplus SQL> show user; USER is “MAHE” SQL> select dbms_metadata.get_ddl(‘TABLE’,…
Read MorePosted by Jayachandran A OMS_HOME/Apache/Apache/log/error_log shows: [timestamp] [error] (79) Value too large for define data type: could not open transfer log file /apps/oracle/logs/access_log or [Tue Oct 11 11:26:36 2011] [notice] child…
Read MorePosted by Sathiyaseelan Mariappan Problem: Physical standby recovery reports error in alert log: Wed Jun 23 01:10:22 2010 Media Recovery Log /mnt/import/recovery_standby/4_77799_650412287.dbf Errors in file /oracle/diag/rdbms/db1/DB1/trace/DB1_pr00_16417.trc (incident=360443): ORA-00600: internal error code,…
Read More