by S-Square | Mar 3, 2021 | Blogs
Introduction: Starting form 12c Release 1 (12.1) USING CURRENT LOGFILE is deprecated and no longer required to start real-time apply. In this blog will list the commands to start/stop managed recovery process on 12cR1 and 12cR2 dataguard. Description : When the...
by S-Square | Feb 2, 2021 | Blogs
Introduction: Performance statistics for the database are obtained, analysed and managed by the Automated Workload Repository (AWR). The collected data can be displayed in reports and views. We can configure and modify the default snapshot interval and retention...
by S-Square | Jun 26, 2020 | Blogs
Introduction: Prior to 11g release 2, it was not possible to upgrade database objects while these were being actively accessed by the applications. But Oracle have introduced a concept of EBR (Edition-Based Redefinition) from 11gR2 which make it possible to perform....
by S-Square | Jun 23, 2020 | Blogs
Introduction :  From 11gR2, a physical standby database can be opened in read only mode for the benefit of query and reporting which is the feature known as an Active Data guard (ADG). We can also perform database backups on standby when opened in ADG to offload...
by S-Square | Jun 5, 2020 | Blogs
Introduction: An ACL, as the name infers, is basically a list of who can access what and with which privileges. Who denote for Principal of an ACL/User/Role or Public. What denote for Host/Port ranges. Which denote for Connect or Resolve or both Connect and Resolve....
