ORA-16179 incremental changes to “log_archive_dest_10” not allowed with SPFILE

You might encounter ORA-16179 error while changing the archive destination.

There is syntax error in above command . It should be like log_archive_dest_n [n is a integer from 1 to 31]=’LOCATION=path_for_archive_log’ example :

Thank you for giving your valuable time to read the above information. If you want to be updated with all […]

Read More

Recover a datafile from copy

Let’s recover if some datafile is unavailable. Let’s delete users01.dbf datafile which is in USERS tablespace.

Let’s try to create a table name A in tablespace Users.

We need to restore and recover the datafile. Restore means copy from backup, recover means applying changes since the backup is taken.

Restore datafile:

[…]

Read More

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