resync catalog from db_unique_name all — fails ***UPDATE

Previously I talked about ‘RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;’ (LINK) and the issues we have faced.  As promised here is some followup. Oracle had asked us to perform a few steps. The first was to test 2 new net service names in the tnsnames.ora file on both the primary and the standby database.  Here is […]

Hugepages on Exadata? Yes and No… part1

The topic of enabling hugepages on our Exadata environment.  Just opened an SR with Oracle Support to get some clarification.  I know that it is not enabled on the database servers, but is on the cell servers. Here you can see the database version we are using: Here you can see that hugepages in /etc/sysctl.conf […]

resync catalog from db_unique_name all — fails

We perform daily backups and specify the statement: RESYNC CATALOG FROM DB_UNIQUE_NAME ALL; To further define the statement you can reference the Oracle 11.2 documentation HERE (section 11.4.1.1).  Here is an exert from the documentation: Resynchronizes the information from all other database sites (primary and other standby databases) in the Data Guard setup that are […]

SEV 1 SR – 8 Node Exadata Database Hang

We’ve had an issue for the past ohh  6 hours with a production Exadata cluster.  It started out with random instances of  our database coming down and then starting backup. Some of the initial errors were: ORA-600 internal errorCF EnqueueParallel Query Interrupt So our database is 11.2.0.1.  The exact Parallel Query Interrupt error we received […]

Continuous Physical Data Block Corruption Issues – post 3

We have officially resolved our physical data block corruption.  The final action plan provided by My Oracle Support came 8 days after SR creation, several escalations and manager phone calls as well as being assigned to an “expert” data corruption specialist. The solution = copy datafile that contains the corrupt blocks from the physical standby […]

Continuous Physical Data Block Corruption Issues – post 2

So the issues are still persisting in the system.  We still have 3 corrupt data blocks (123456, 123457, 123458).  Only 1 data file is still affected (100).  Here are some of the latest steps that Oracle Support has requested from us: ##################################################Generic Note————————1- Please run the sundiag.sh on each of your exadata cells and upload […]

Missing Datafile Physical Standby 11gR2 – Restore and Sync with Primary

1) Identify datafile to remove from the standby a)  connect to sqlplus and query for datafile SQL> select file#,name,online_time from v$datafile where file#=’72’; FILE#    NAME ——-    —— 72        +DATA/inst_ps/datafile/sif_data.1592.126384956 2) Stop the standby database and check the status a)  stop database srvctl stop database -d inst b)  get status of the database srvctl status […]

Restore Physical Standby Database 11gR2 and Sync with Primary

In the previous post HERE we created the physical standby controlfile from the primary database and copied over to the standby.  We then used RMAN to restore it to the physical standby.  Now that we have done some prepwork we can restore the physical standby database.  I recently went through this using the “TAG” we […]

Create Physical Standby Controlfile and Restore to Standby Database

1) On the primary database connect to sqlplus ‘/as sysdba’ and issue command to create the standby controlfile testserver:/tmp–> sqlplus ‘/as sysdba’ SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 2 12:46:13 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production With the Partitioning, […]