Oracle Automation / Cloud

Unified Audit (12c New Features) ------------------------------------------- new parameter: UNIFIED_AUDIT_SGA_QUEUE_SIZE (1 MB to 30MB) is introduced. This parameter configures the size of SGA queue for unified auditing. UNIFIED AUDIT: ----------------------- QUEUED Mode (default). Audit records stored in the SGA and periodically flushed. Immediate: Audit records written immediately. Roles: -------  AUDIT_ADMIN and AUDIT_VIEWER to administer unified auditing. Create auditing policy ----------------------- SQL> create audit policy mono_audit   privileges    alter database, select any table   actions    logon, select on HR.employees;  2    3    4    5  Audit policy created. SQL> audit policy mono_audit; Audit succeeded. ENABLE AUDIT POLICY --------------------------------- enable audit for all users SQL>  audit policy  mono_audit ; Audit succeeded. Check Audit : ...

DATA REDACTION ( 12c New Features) ---------------------------------- Oracle Data Redaction adds the ability to change the output from sql query field values (in full or in part), depending on conditions.  DBMS_REDACT package managed the Data Redaction.   create the redaction user: -------------------------- create user redact_user identified by oracle; User created. Grant appropriate privileges to manage redaction policies: ---------------------------------------------------------- grant connect, resource, unlimited tablespace to redact_user; grant select  on  Sys.redaction_policies to redact_user; grant select  on  Sys.redaction_columns to redact_user; grant execute on dbms_redact to redact_user; Grant succeeded. SQL> Grant succeeded. SQL> Grant succeeded. SQL> Grant succeeded. Create a test table redtest ----------------------------- SQL> conn / as sysdba Connected. SQL> grant select on hr...

12c Data Guard-Far Sync Standby     1.   Create the control file for the far sync instance (the primary database does not have to be open, but it must at least be mounted): SQL> startup mount; 2. Create Far-Sync control file mkdir-p /u01/app/oracle/oradata/FSTESTP SQL> ALTER DATABASE CREATE FAR SYNC INSTANCE CONTROLFILE AS '/u01/app/oracle/oradata/FSTESTP/control01.ctl'; Database altered. ·          copy the far sync instance control file created in Step 2 for the far sync instance. 3 . Create the required directories, oratab entry, password file. 4 . Create a parameter file (PFILE) from the server parameter file (SPFILE) used by the primary database and modified the below parameters for Primary Database, TESTP ·          DB_UNIQUE_NAME=TESTP ·          FAL_SERVER= TESTS; ·      ...