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 fil...
Wednesday, 20 September 2017
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 A...
Saturday, 22 August 2015
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/ad...
Monday, 15 September 2014
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 resid...
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
point...
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_tar...
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&nb...
Saturday, 7 June 2014
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 databa...