Author Archives: pawan

Oracle Database Administration (DBA): 1. What is an Oracle Instance? 2. What information is stored in Control File? 3. When you start an Oracle DB which file is accessed first? 4. What is the Job of SMON, PMON processes? 5. … Continue reading

Posted in Career Management / Upward Mobility, Data Guard, Interview Questions, Oracle Database Family, Whats Hot? | Leave a comment

============DATA GUARD================= ———– ===========PRIMARY STEPS================= <oracle.root>chown -R oracle:oinstall /u01 SQL>alter database force logging; rman>backup database plus archivelog;     OR (backup database include current controlfile for standby plus archivelog;) rman>backup current controlfile for standby; ====>”Transfer backup to standby” ====> Now first create … Continue reading

Posted in Data Guard, My Blogs | Tagged | 1 Comment