Simply run the following script from any database server to query the physical disk, celldisk, griddisk, and flash disks on the cell nodes in …
Read More »ORACLE
How To Restore RAC Database From rman backup
When a database completely crashes, you need to do is to setup from scratch and return from backup. If you have a Rman backup …
Read More »Oracle Exadata Default Passwords
Exadata installation is done with standard user name and password unless you specify otherwise. All standard passwords must be changed. The standard user name …
Read More »DBA_TAB_MODIFICATIONS table does not return any record
In the DBA_TAB_MODIFICATIONS table, change statistics for all changed tables in the database are stored. The same information can also be accessed from the …
Read More »How To Recover Dropped Tables with Oracle Recyclebin
In this article I will tell you about Recyclebin which is one of the beautiful features announced with Oracle 10g version. With the Recyclebin …
Read More »ORA-00245: control file backup failed; target is likely on a local file system
When backup is taken with Rman, it creates the snapshot of the control file and uses it as backup file. The name of the …
Read More »Data Pump Export process waiting with the message “wait for unread message on broadcast channel”
During the DataPump export process, if the relevant session is waiting for the following message, you can resolve this issue by doing the following …
Read More »How To Increase Incremental Backup Speed with Block Change Tracking
You can increase the incremental backup speed with Block Change Tracking, which is one of the features that introduced with 10G. When we enable …
Read More »What is Network Access Control List and How To Use It
From 11gR1, access to external network services in Oracle databases is done through the Access Control List (ACL). It is possible to perform operations …
Read More »Oracle Data Pump Query Parameter
With the data pump, you can use the query parameter to export only the records that are returned from the query in a table. …
Read More »