Storing password file in ASM diskgroup

Starting with Oracle Database 12c, we can now store a password file directly into ASM Diskgroup. Also, Oracle has made it default for a password to be case sensitive in the password file.

Read more

12c copy the password file from PRIMARY ASM to the STANDBY ASM.

When you create a RAC database in 12c with DBCA, the password file will be stored in an ASM. In this post i will demonstrate how to refresh/copy the password file from PRIMARY ASM to the STANDBY ASM.

Read more

Upgrade the Oracle 11.2.0.4 database to Oracle Database 12.1.0.2

Database SID: UPGR is database version 11.2.0.4 is running and ready for an upgrade.The new pre-upgrade check script preupgrd.sql which will examine UPGR database. This script is shipped with the new Oracle 12c home in /u01/app/oracle/product/12.1.0.2/rdbms/admin

Read more

Recover from a DROP or TRUNCATE table by using RMAN

To recover from a dropped or truncated table, a dummy database (copy of primary) will be restored and recovered to point in time so the table can be exported.  Once the table export is complete, the table can be imported into the primary  database. This dummy database can be a subset of the primary database. However, the 'dummy' database must include the SYSTEM, UNDO (or ROLLBACK), and the  tablespace(s) where the dropped/truncated table resides.

Read more

How to recreate oraInventory (Central Inventory) in RDBMS Homes if the central inventory is corrupted or lost?

SOLUTION

STEP 1: 

Locating the central inventory 

•  The location of the central inventory can be found from the central inventory pointer.

Read more

How to Recreate The AWR( AUTOMATIC WORK LOAD ) Repository

The best way to deinstall/install AWR is as follows:

1. Disable AWR statistics gathering by setting the statistics level to basic as follows:

Check settings for parameters as follows:

sqlplus /nolog

connect / as sysdba

show parameter cluster_database

show parameter statistics_level

show parameter sga_target

Read more

Standby MRP needs old log sequence even after restore of incremental backup at standby

At standby applied incremental backup but  MRP  process at standby is looking for very old sequence.

SQL>SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" 

  FROM (SELECT THREAD# ,SEQUENCE# 

  FROM V$ARCHIVED_LOG 

Read more

DBUA error database not in mounted state

 While  upgrading one of my 10.2.0.4 64-bit database to 11.2.0.2 using DBUA it failed  with retrieve db information  and pop up the message

"The Upgrade Assistant failes in bringing up the database XXX. Oracle Home /oracle/OraHome11203 obtained from file /etc/oratab was used to connect to the database.

Read more