Category Archives: Data Guard

Data Guard Site Failover & Replication Technologies

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

On this last day of VirtaThon 2011, I wanted to take this opportunity and thank ALL the organizers & attendees for making VirtaThon 2011 a resounding success! Credit goes to all the Speakers for their incredible efforts and AWESOME sessions. … Continue reading

Posted in Automatic Storage Management (ASM), BrainSurface, Business Intelligence, Career Management / Upward Mobility, Certification, Cloud Computing, Data Guard, Database Family, Development, Disaster Recovery, E-Business Suite, E-Business Suite, Education, Enterprise Manager, Exadata, High Availability, Innovations / New Features, Installation / Upgrades, Interview Questions, Maximum Availability Architecture (MAA), My Blogs, OEM Database Control, Oracle Database Family, Oracle Enterprise Manager / Grid Control, Real Application Clusters (RAC), Systems, The BrainSurface Project, Tools / Utilities, Training, Troubleshooting, Virtualization, Whats Hot? | Leave a comment

How to put a Oracle database into FORCE LOGGING mode? Why does a Data Guard database have to be in FORCE LOGGING mode? What impact does FORCE LOGGING have on a Dataguard database? How to revert a FORCE LOGGING database back to … Continue reading

Posted in BrainSurface, Data Guard, Database Family, Education, High Availability, Installation / Upgrades, Maximum Availability Architecture (MAA), My Blogs, Oracle Database Family, Real Application Clusters (RAC), Tools / Utilities, Training, Troubleshooting | Tagged | 3 Comments

Is there a method to verify, that the database is indeed shipping redo data over to the standby database in a 10G Data Guard setup? What is the fastest way to find out if the Data Guard is working?

Posted in Automatic Storage Management (ASM), BrainSurface, Data Guard, Database Family, Disaster Recovery, High Availability, Installation / Upgrades, Maximum Availability Architecture (MAA), My Blogs, Oracle Database Family, Tools / Utilities, Troubleshooting | Tagged | 1 Comment

Windows Server 2003: Oracle 10G Release 2: Data Guard Wizard in Grid Control fails and display error: ORA-19257: It reports creation status failed in the Data Guard Wizard spawned job with following errors in Standby alert log files:   ORA-00313: … Continue reading

Posted in BrainSurface, Data Guard, Database Family, Disaster Recovery, High Availability, Installation / Upgrades, Maximum Availability Architecture (MAA), My Blogs, Oracle Database Family, Tools / Utilities, Troubleshooting | Tagged | 1 Comment

Windows Server 2003 R.3: Encountered error: ORA-00272: error writing archive log. ORA-16737: The redo transport service for standby database “PROD_DG1″ has an error.

Posted in BrainSurface, Data Guard, Database Family, Disaster Recovery, High Availability, Maximum Availability Architecture (MAA), My Blogs, Oracle Database Family, Tools / Utilities, Troubleshooting | Tagged | 2 Comments