Wednesday, 20 September 2017

Saturday, 22 August 2015

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 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...

Total Pageviews