12c: Testing audit features for Data Pump (Export & Import) and RMAN jobs

Comments

Post a Comment

Popular posts from this blog

Oracle DataGuard – How to resize Redo Log and Standby Redo Log

Oracle DataGuard – How to resize Redo Log and Standby Redo Log set linesize 200 col dest_name for a30 select DEST_NAME,STATUS,PROTECTION_MODE,ARCHIVED_SEQ#,APPLIED_SEQ# from v$archive_dest_status; On Standby server - make file management parameter to manual if not: show parameter standby; alter system set standby_file_management=manual; ================== +     On Primary             + ==================  SQL> select group#,thread#,status from v$log; col member for a60 set linesize 200 select member,group#,status from v$logfile; SQL> select group#,thread#,status from v$log;     GROUP#    THREAD# STATUS ---------- ---------- ----------------          1          1 ACTIVE          2       ...
Read more

Oracle DBA Automation using Ansible - RU 18.5 Oracle Grid Infrastructure and Database Home from Oracle 18.3

Image
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ RAC RU 18.5 Oracle Grid Infrastructure and Database Home from Oracle 18.3  +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Ansible tools - easier to setup automation task instead of manually . In this article we will go through applying  RU into a Oracle GI and Database using Ansible script. Normally we need to manually run over 20 commands for patching Oracle GI and Oracle_HOME and time consuming ----but with ansible setup here I am going to execute a single command,   ansible-playbook racdatabase.yml to complete GI, RDBMS and Data Patch tasks. Tasks: main.yml - pre_tasks_before_apply [prepatch_apply.yml] + Backup opatch file from grid home / oracle home + Update required opatch utility in grid home / Oracle home + Update opatch ownership in grid home / Oracle home + OPatch Conflict Check in grid home / Oracle home + OPatch SystemSpace Check in gr...
Read more

12c ASM: Moving the Existing Cluster Mode to Flex Cluster

Image
In Oracle Flex ASM architecture, Oracle ASM instances can run only a small number of cluster nodes. These ASM instances are connected by all the database instances on the cluster to provide storage access for all these database instances. When an ASM instance fails, the database instances reconnect to other ASM instances for the failed ASM instance. This features supports the platform for variety of application which includes RAC with large number of nodes. There is a new type of network, ASM network with Flex ASM which is used for communication between ASM and its clients. ASM network is accessible from all nodes. In oracle Flex Cluster, the nodes are arranged in two ways i.e. Hub Node and Leaf Node. Hub Nodes : tightly connected with each other like standard configuration and have direct access to the shared storage. Leaf nodes: Leaf nodes can be added as many as more and can host different applications other than hub nodes. This type of nodes doesn't require direct ac...
Read more