We have archive on Production Server but we need to apply manually on DR server. Archive is present in ASM disk. So We have two option to resolve these: 1. …
-
-
Error: ORA-27041: unable to open file Cause:Unable to start the database after adding new disk in diskgroup. Solution: 1. Check the permission of the disks.Note: Need permission at OS level …
-
Copy password file from primary to standby in RAC Environment Errors:–PRODDB – Primary databaseError: ORA-16810: multiple errors or warnings detected for the database –DRDB – Physical standby databaseError: ORA-01017: …
-
Understand the terminology involved in Buffer Cache Buffer CacheOracle having copies of database blocks for frequent access instead of fetching from disks known as buffer cache in SGA area. It’s …
-
Check database is Administrative and policy managed in RAC Administrative: DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster.Policy: DBA …
-
Check session in waiting and how much time from its waiting COLUMN event FORMAT A30COLUMN wait_class FORMAT A15COLUMN sid format 9999select sid, seq#, EVENT, WAIT_CLASS, SECONDS_IN_WAIT from v$session_wait ORDER BY …
-
Hard Parses If session execute the SQL statement that not present in the shared pool then Oracle need following steps to placed in memory:1. Allocate memory for the statement from …
-
Soft Parses wait in Oracle Soft ParseSession executes a statement that exists in shared pool is refered to Soft Parse. Note: General high “parse call” (> 10/sec.) indicates that …
-
Purge the RECYCLEBIN in Oracle RECYCLEBIN feature is enabled by default. It is used for the recover purpose if you table is dropped accidentally. Check the table present in …
-
Script for move stats of previous to next month partition in Oracle In one of our customer is facing problems on first of every month due to no data …