How do Nologging Operations affect Recovery and Data Guard?

What is Redo Information: Each Oracle Database instance has redo logs, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure. What is Nologging: NOLOGGING can be used to prevent bulk operations from … Continue reading How do Nologging Operations affect Recovery and Data Guard?

Oracle Database Migration to Exadata – Case Study

Objective: This report will show the detailed steps that we followed to migrate a real client production database from its current production server to the Exadata machine. Environment:  SourceTargetServer Nameprod-n-214exa-db-101Database NamePRODPRODOracle version11.2.0.311.2.0.3O.SLinux OEL 6.5Exadata OEL 6.8Character setWE8ISO8859P1WE8ISO8859P1Clustered:Single InstanceSingle Instance Migration High Level Plan: Migration Preparation.Backup the production database.Duplicate the production database to Exadata.Post Migration stepsValidate … Continue reading Oracle Database Migration to Exadata – Case Study