MADHAN APPS DBA

RMAN Commands : =============== An incremental backup: ======================= stores only blocks changed since a previous backup. Thus, they provide more compact backups and faster  recovery, thereby reducing the need to apply redo during data file media recovery.  If you enable block change tracking, then you can improve performance by avoiding full scans of  every input data file. You use the BACKUP INCREMENTAL command to perform incremental backups. cumulative incremental backup ============================== A level 1 backup can be a cumulative incremental backup, which includes all blocks changed since the  most recent level 0 backup, or a differential incremental backup, which includes only blocks changed  since the most recent incremental backup. BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; You can use the VALIDATE command to confirm that all database files exist, are in their correct location,  and are free of physical corr...

Oracle apps dba Interview Q&A's: =========================== What is the significance of utl_file_dir parameter in init.ora file? ===================================================================== Answer The value of this parameter is the group of directories to which u r database can write,  means u r database packages have permission to write to flat files in these directories. What is APPLPTMP environment variable? ======================================= Answer This is the temporary file location for the pl/sql temp files.  If this variable was not set then the concurrent programs may error-ed out. DIAG_PARAM ="Y" in adcmctl.sh. for CM issues oracle apps concurrent managers interview question and common information's Question:Error: ================ After submitting the concurrent program, i am getting the status as inactive and no manager and when i clicked on diagnostics button its showing a message like This request will not be pro...