Recover controlfile

Controlfiles saved at least in 2 locations. If one of them is corrupted then you can copy from other one after shutdown database. In this case I will show you how to recover from autobackup via RMAN. So you need CONFIGURE CONTROLFILE AUTOBACKUP ON; in RMAN and you should have full backup database. It can […]

Read More

ESTIMATE in Oracle Expdp

The value for parameter ESTIMATE  is either BLOCKS (default) or STATISTICS. BLOCKS: The estimated space used is calculated by multiplying the number of database blocks used by the target objects with the appropriate block sizes. It is  the least accurate because of: The table was created with a much bigger initial extent size than was needed for […]

Read More

ESTIMATE_ONLY in Oracle Expdp

This parameter is useful when you wanted get the approximate size of the dump file. Suppose you have only limited space available in the disk and if you wanted to check whether your dump will be fit into the available space then you can use this parameter to check or estimate the size of the […]

Read More

Flashback Technology

Flashback Technology in Oracle : Oracle Flashback Technology is a group of Oracle Database features that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery. Today we will see following feature of Flashback Technology : 1. Oracle Flashback Query . 2. Flashback […]

Read More

Changing password securely in Oracle

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – We are living in the world of username and password life. We all have countless password due to technology’s development. Password plays an important role in our life. Oracle Database leads the industry in security. To maximize the security […]

Read More

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

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