Sometimes when your running an Oracle database, it becomes necessary to automate some tasks like cleaning your archivelogs. Since in…
How to change the Size of the Redo Log files to improve the log switch frequency in Oracle database. select…
Purpose of this parameter found in sqlnet.ora file: Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If…
How to configure just newly added disks in Solaris 10? It’s really simple. 1. first show all attached targets bash-3.00#…
—– Procedure to import table from production system to test system —— 1. Copy the backup(dump) of schema onto /backup_restor_only…
####PSU patching, interim patches ##### Sometimes before moving to a new 10.2.0.* version there are CPU patches released on a…
How to backup the Oracle Control File? There are two approaches: you either generate a binary image of the Control…
Whenever you are trying to backup Archivelogs from RMAN you might get the following error. Starting backup at 25-FEB-10 current…
I’m now a certified expert in Oracle. Just cleared the 1z0-048 exam for Oracle RAC 10g Cluster. The exam tests…