ORA-01274: cannot add data file

PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Primary database:

— Error in alert log of standby database File #5 added to control file as ‘UNNAMED00005’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file should be manually created to continue. MRP0: Background Media Recovery terminated […]

Read More

Enabling Flashback Database in Oracle

Oracle Flashback Database, allows to quickly recover the entire database from logical data corruptions or user errors. It is very similar to PITR (Point In Time Recovery) which puts back the database to a state at a particular time in recent past. 1. Place your database in mount stage.

2. Set DB_FLASHBACK_RETENTION_TARGET to the requried […]

Read More

ORA-15032: Not All Alterations Performed

While setting attribute on a ASM diskgroup, we got below error.

Solution: Alter operations on ASM diskgroups need to be done from sysman user , instead of sysdba user.

Read More

Enable Archive Log Mode In Oracle RAC

1. stop the database service.

2. start the database in mount state.

3. enable archive log mode.

4. Restart the database service (using srvctl)

5. set the archive destination to a ASM DISK

Read More

Recreate Oracle Central Inventory

Inventory is the index for the oracle installation. All the details about the ORACLE_HOME including different utility versions, patch details etc. If you do a fresh Oracle installation the inventory will be updated. But if you copy the ORACLE binaries from some other location and if you are not updating the inventory, we cannot read […]

Read More

Move Datafile From File System To ASM Disk In 11g

Below steps need to be followed to move the datafile to ASM disk group. SOLUTION: 1. Make the datafile offline;

2. Connect to RMAN and copy datafile to ASM DISKGROUP

3. Rename the datafile in control file

4. Switch the data file to copy

5. Recover the datafile

6. Make the datafile […]

Read More

How to change ASM SYS Password and Creating SYSASM user 11g.

First we can try with normal method

We cannot change the password for ASM databases via alter user command. Because passwords are managed through password file in ASM. The password should be the one provided when the password file was created, also REMOTE_LOGIN_PASSWORDFILE should be set to EXCLUSIVE on all instances. So only way to […]

Read More

Amount of redo generated during user-managed backup

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: –  In this article, we have a quick journey on redo log during user-managed backup. RMAN is the most recommended tool for performing backup and recovery of an Oracle database, but we know that this is not always the case and many […]

Read More

Unified Auditing, one of the new features in Oracle Database 12c

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: –  In this article, we are going to know about some other new features of Oracle 12c.  Unified Auditing is a new feature in Oracle 12c. In Oracle 12c, a new database auditing Foundation has been introduced.  Oracle Unified Auditing […]

Read More

Introducing new disks to ASM using ASMFD

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. This article provides the information to create new disks to ASM using ASMFD. In my cluster, I have 2 nodes: london1 and london2. From one of the ready nodes the newly added shared disk:

Note that this disk has […]

Read More