How to use Catalog start with command

Recovery Manager(RMAN) is an Oracle Database client that performs backup  and recovery tasks on your databases and automates administration of your backup strategies. It greatly simplifies backing up,restoring and recovering database files. If you have backup files in non-FRA location  , you can catalog your backup using catalog start with command of RMAN. Note : […]

Read More

Prereq Check Failed – The Database Must Be In Upgrade Mode

Database release 12c extends patch install automation for patches that contain post-patch SQL instructions. Prior to Oracle 12c such patches required manual intervention to complete the post-patch SQL instructions after restarting the database. Datapatch is the new tool that enables automation of post-patch SQL actions for RDBMS patches. Datapatch resides in the opatch directory i.e […]

Read More

Export backup with date and time

Data Pump Export (hereinafter referred to as Export for ease of reading) is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility. The dump file set can be imported on the […]

Read More

Undo Segments are corrupted

Database is shutdown and can’t start it, asking for Undo recovery while dropping Undo tablespace Dropping a Undo tablespace give message The UNDOTBS for our RMAN Catalog database was dropped. Any attempts to switch to a newly created UNDOTBS or removing the old UNDOTBS failed with the following error: ORA-01548: active rollback segment Or Undo […]

Read More

Oracle 18c: How to load data in Oracle Autonomous Data Warehouse Cloud

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Loading Data into Autonomous Data Warehouse Cloud Database   Data […]

Read More

Read the Trace file from SQL Plus

Find trace file in Oracle The following script returns the path to the trace file that the current session writes. It returns the path whether or not tracing is enabled.

Check the value for user_dump_dest

Create a directory

Create a function

Now just the select the trace file name.

Thank you for giving your valuable […]

Read More

Transparent Data Encryption (TDE) In Oracle 12c

Today we are going to talk about Transparent Data Encryption (TDE) In Oracle 12c. First, have look at the introduction of TDE.  After the introduction, we have steps to configure TDE. Transparent Data Encryption (TDE) was introduced in Oracle Database 10g Release 2 as an OUT-OF place mechanism to encrypt data at the storage (media) level. TDE […]

Read More

Disable TDE In Oracle 12c

This post is about Disable TDE In Oracle 12c . Let’s hav look on the steps. Find the encrypted table columns and modify them: SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns;SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns; OWNER TABLE_NAME   COLUMN_NAME ENCRYPTION_ALG—– ———— ———— —————————–RAJ   EMPLOYEE    SALARY AES 192 bits key  SQL> alter table raj.employee modify( salary decrypt); Table altered. SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns; No […]

Read More

Purge AUD$ Table Using DBMS_AUDIT_MGMT

  Introduction:- Oracle 11gR2 introduced DBMS_AUDIT_MGMT for managing audit trails.  The growth of AUD$ can impact the performance of the database. So purging it regularly is the best practice followed by DBA’s and DBMS_AUDIT_MGMT makes it easier. Follow below steps for purging aud$ table. 1. Make sure AUD$ table is not in SYSTEM table tablespace.   […]

Read More

Prepare standby and configure primary database for far sync

This depend on distance between primary and standby and network bandwidth. So this feature that came with 12c resolve this situation. We are preparing a database one more. This database take archive–log primary database and then send this archive–log to standby. Primary and far sync standby database are sync, whereas far sync standby database and physical standby database are async. Let’s begin with creating the physical standby with FAR SYNC instance in place. First of […]

Read More