ORA-01274: cannot add data file

PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Primary database: SQL> alter tablespace prim add datafile size 1g; Tablespace altered. — 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 […]

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. sql>shutdown immediate sql>startup mount 2. Set DB_FLASHBACK_RETENTION_TARGET […]

Read More

ORA-15032: Not All Alterations Performed

While setting attribute on a ASM diskgroup, we got below error. oracle@crmcpredb1:~$ echo $ORACLE_SID +ASM1 oracle@crmcpredb1:~$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 16 11:19:25 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Real Application Clusters […]

Read More

Enable Archive Log Mode In Oracle RAC

1. stop the database service. srvctl stop database -d RAC 2. start the database in mount state. srvctl start database -d RAC -o mount 3. enable archive log mode. SQL> alter database archivelog; Database altered. 4. Restart the database service (using srvctl) srvctl stop database -d RAC srvctl start database -d RAC 5. set the […]

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; SQL> select file_name from dba_data_files; FILE_NAME ——————————————————————————– +DATA/RAC2/DATAFILE/system.260.934026715 +DATA/RAC2/DATAFILE/sysaux.261.934026717 +DATA/RAC2/DATAFILE/undotbs1.262.934026719 +DATA/RAC2/DATAFILE/undotbs2.264.934026727 +DATA/RAC2/DATAFILE/users.265.934026729 /export/home/oracle/user02.dbf alter database datafile ‘/export/home/oracle/user01.dbf’ offline; 2. Connect to RMAN and copy datafile to ASM DISKGROUP RMAN> copy datafile ‘/export/home/oracle/user02.dbf’ to ‘+DATA/RAC2/DATAFILE/user02.db’; Starting backup […]

Read More

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

First we can try with normal method SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME —————- +ASM SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>; ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password> * ERROR at line 1: ORA-01109: database not open We cannot change the password for ASM databases via alter user command. Because passwords are […]

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: [root@london1 ~]# ls -l /dev/sdf brw-rw—- […]

Read More