Unified Auditing in Oracle 12c

Unified Auditing is new audit feature came with Oracle 12c version. You have to do enable Unified Auditing to use after install database. Unified Auditing come as disabled by default. In previous releases of Oracle Database, there were separate audit trails for individual components: SYS.AUD$ for the database audit trail, SYS.FGA_LOG$ for fine-grained auditing, DVSYS.AUDIT_TRAIL$ […]

5,372 total views, 4 views today

Oracle 12c R2 (12.2.0.1) Real Time Apply Data Guard Installation on Oracle Linux 7.3

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of […]

9,328 total views, 6 views today

Oracle 12c R2 (12.2.0.1) RAC Installation Steps on Oracle Linux 7.3

Oracle Real Application Clusters (Oracle RAC) is a clustered database infrastructure of Oracle Database based on a comprehensive high-availability stack that can be used as the foundation of a database cloud system as well as a shared infrastructure, ensuring high availability, scalability, and agility for any application. Oracle Real Application Cluster has been using with […]

26,177 total views, 10 views today

Oracle 11g R2 Resize Redo Log Size on Data Guard and Primary Database

Sometimes, you may need to change redo log size to perform optimum size for performance. If you want to change redo log size of both standby side and primary side, you can use below commands. Current Status Of Redo Logs Primary Side SQL> select group#,sum(bytes/1024/1024)”Size in MB” from v$log group by group#; GROUP# Size in […]

21,195 total views, 5 views today

Oracle 11g R2 Open Data Guard Read Write Mode With Flashback Technology And Revert Restore Point

You can use flashback technology on standby side. If you want to make application test on database, you can use data guard as read write mode temporarily with flashback technology. You can create a restore point on standby side then you can do any transaction on standby side to test or any other purpose. After […]

8,110 total views, no views today

Oracle 11g R2 Data Guard Manual Switchover Steps

You can use the same steps to switchover for single data guard or multiple data guard configuration. Switchover operation will convert primary side to data guard and data guard to primary side. You have to control listeners whether it is running before switchover steps. Switchover Steps Primary Side SQL> alter system archive log current; SQL> […]

6,911 total views, 2 views today

Oracle 11g R2 Multi Real Time Apply Data Guard Configuration Steps

Oracle 11g R2 database supports multi standby database structure up to 30 standby databases. We can use remote destinations for real time apply standby structures with todays network technologies. If your remote destination network is not good, you can use archivelog apply for remote destination with some delay. System informations are like below. System Informations […]

2,939 total views, no views today

Oracle 11g R2 Cascade Standby Data Guard Installation and Configuration Steps

Oracle 11g R2 database supports cascade standby database structure. If you are using RAC on primary side, your database version has to be least 11.2.0.2 to support cascade standby structure. You can use to reduce the load on your primary database with using cascade standby database structure. Primary database redo is written to the standby […]

3,889 total views, 8 views today

Oracle 12c R2 Downloadable Now

You can download Oracle 12c R2 database now. Only Linux x64 and Solaris Operation Systems supported for now. You can download with below link; http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Also you can find new features about of Oracle 12c R2 with below links; https://docs.oracle.com/database/122/ https://blogs.oracle.com/sql/entry/12_things_developers_will_love 2,401 total views, no views today

2,401 total views, no views today

Oracle 11g Oracle Checkpoint Not Complete, Cannot Allocate New Log Warning

Error: Checkpoint not complete, Cannot Allocate New Log Warning Thread 1 cannot allocate new log, sequence 125487 Checkpoint not complete Solution: Checkpoint not complete messages are generated due to the logs are switching so fast that the checkpoint associated with the log switch isn’t complete. You should increase redo log file size and amount to […]

11,029 total views, 8 views today