Query to find out FULL table scan and table extent in a database
Query to find out FULL table scan and table extent in a database 1) The below query will provide all the select statement which is using FTS in the whole…
Read MoreIf Condition Options – BASH/SHELL Script
The below conditions can be used in IF condition to match you requirements [ -a FILE ] True if FILE exists. [ -b FILE ] True if FILE exists and…
Read MoreDataguard Queries
SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; Check for messages/errors SELECT MESSAGE FROM V$DATAGUARD_STATUS; Query the physical standby database to monitor Redo Apply and redo transport services…
Read MoreXML-20201: (Fatal Error) Expected name instead of .
Error : ——- Output post processor failed with below error processing report output Caused by: org.xml.sax.SAXParseException: <Line 17018, Column 25>: XML-20201: (Fatal Error) Expected name instead of . Concurrent Log file…
Read MoreDataguard Background Process
The services required on the primary database are: •Log Writer Process (LGWR) – Collects redo information and updates the online redo logs. It can also create local archived redo logs…
Read MoreOracle Standby databases
Types Of standby databases Physical standby database Logical standby database Oracle Active Data Guard(11g) Snapshot standby database (11g) Heterogeneous DataGuard 10g/11g Cascading standby database Far Sync Instance(12c)
Read MoreStep by Step Failover Datagurd
In case of our bad situation with data guard primary database, or not available for production than we can activated standby database as a primary production database. Step:1 Select name,open_mode,database_role…
Read MoreStep by Step Dataguard Switchover
Step:1 ALTER SESSION SET nls_date_format=’DD-MON-YYYY HH24:MI:SS’; SELECT sequence#, first_time, next_time, applied FROM v$archived_log ORDER BY sequence#; Step:2 select dest_name,status,error from v$archive_dest where dest_name=’LOG_ARCHIVE_DEST_2′; Step:3 select message from v$dataguard_status; select switchover_status…
Read MoreError while running autoconfig in DB Tier
Error while running autoconfig in DB Tier Error: UnsatisfiedLinkError exception…
Read More