Oracle Database

Auditing is always about accountability, and is frequently done to protect and preserve privacy for the information stored in databases. Concern about privacy policies and practices has been rising steadily with the ubiquitous use of databases in businesses and on the Internet. Oracle Database provides a depth of auditing that readily enables system administrators to implement enhanced protections, early detection of suspicious activities, and finely-tuned security responses. If your  AUD$  table is in  SYSTEM  and  SYSTEM  tablespace, Then it is advised to move the  AUD$ to a dedicated tablespace. Use steps to move AUD$. 1 2 3 4 5 select owner , segment_name , segment_type , tablespace_name , bytes / 1024 / 1024 from dba_segments where segment_name = 'AUD$'   OWNER   SEGMENT_NAME     SEGMENT_TYPE   TABLESPACE_NAME   BYTES / 1024 / 1024 -- -- -- - -- -- -- -- -- -- -    -- -- -- -- -- --    -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- SYS

There are many approaches can convert file system to ASM, such as RMAn copy database image, as of 12c, you can move datafiles online, that feature enables you minimize the downtime. 1. Abstract My CDB named ora12c contain one PDB named pdb1 with local file system datafiles. I have my GI standalone installed with diffenert owner GRID contains two asm disk groups, I need to migrate the whole CDB to ASM. Below is the current environment before migration. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 #GI already installed with 2 disk groups [grid@linora:/home/grid]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -----------------------------------------------------------------------------