SEV 1 SR – 8 Node Exadata Database Hang – Update 1

Because of the potential bug that we hit (8738555) which is resolved with patchset 11.2.0.2, Oracle has been reviewing some parallel query trace files. Here is some example output of the trace files: *** 2011-10-09 19:44:55.218*** SESSION ID:(116.3167) 2011-10-09 19:44:55.218*** CLIENT ID:() 2011-10-09 19:44:55.218*** SERVICE NAME:(SYS$BACKGROUND) 2011-10-09 19:44:55.218*** MODULE NAME:() 2011-10-09 19:44:55.218*** ACTION NAME:() 2011-10-09 […]

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 […]

Determining throughput for your Data Guard network

At one time or another us DBA’s will be tasked with determining the size of your logs for Data Guard.  Determining the size of the logs will provide a fairly accurate estimate.  You can provide the estimate to your network or data team so they can properly size the network pipe to your other facility.  […]

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 […]

Refresh Physical Standby Database from Primary

Simple method to refresh your physical standby database if apply lag is lengthy 1) Stop dataguard broker for the standby database dgmgrl connect sys/pswd disable database ‘inst_ps’ 2) Stop redo application using sqlplus ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; SHUTDOWN IMMEDIATE; 3) Manually copy the logs from the primary to the standby filesystem *** […]

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 […]