How to Configure Flashback Oracle Database :-

First check archive log and flashback is enabled or not and given parameters. SQL> select name,open_mode,log_mode,FLASHBACK_ON from v$database; SQL> show parameter db_recovery; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string db_recovery_file_dest_size big integer 0 SQL> show parameter db_flashback_retention_target NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_flashback_retention_target integer 1440 Step 1:- Make a directory as flashback and … Continue reading How to Configure Flashback Oracle Database :-

In many interviews this question is asked .How to apply patch if you found prerequisite patch to be applied ?

Before applying another prerequisite patch do the following 1. Use adctrl (option 3) to tell all the existing workers to QUIT 2. Use adctrl (option 5) to tell managers that all workers have QUIT. (Adpatch session ends!) cd $AD_TOP/bin AD Controller Menu 1. Show worker status 2. Tell worker to restart a failed job 3. … Continue reading In many interviews this question is asked .How to apply patch if you found prerequisite patch to be applied ?

Change Database name with DBNEWID utility …….Bingo

For safer side.. Please take a backup of database. Step 1: Before you start, find out the current DBNAME and DBID of your database: SQL> select name,dbid,open_mode,log_mode from v$database; NAME DBID OPEN_MODE LOG_MODE --------- ---------- -------------------- ------------ PROD 348176196 READ WRITE ARCHIVELOG Step 2: Shutdown the database and mount a database without opening i.e MOUNT … Continue reading Change Database name with DBNEWID utility …….Bingo

Online resizing of redolog files…

1.. Check the size and get information SELECT a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group#; 2.. Make the last redo log CURRENT SQL> select group#, status from v$log; Force a log switch until the last redo log is marked "CURRENT" by issuing the following command: SQL> alter system switch logfile; … Continue reading Online resizing of redolog files…