[OCM 12C] Setting up Fine-Grained Auditing

brunors

views: AUDIT_UNIFIED_ENABLED_POLICIES CDB_UNIFIED_AUDIT_TRAIL UNIFIED_AUDIT_TRAIL Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Security Guide -> Part VI Monitoring Database Activity with Auditing Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Security Guide -> 21 Introduction to Auditing Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Security Guide -> 22 Configuring Audit Policies Oracle Database Online Documentation 12c Release 1 (12.1) -> Database Security Guide -> 23 Administering the Audit Trail

[OCM 12C] Configuring and monitoring Flashback Database

brunors

Database Backup and Recovery User’s Guide -> 7 Using Flashback Database and Restore Points Database Backup and Recovery User’s Guide -> 18 Performing Flashback and Database Point-in-Time Recovery Database Backup and Recovery User’s Guide -> 21 Performing RMAN Tablespace Point-in-Time Recovery (TSPITR) Database Administration -> Database 2 Day DBA -> 9.8.2 Recovering a Dropped Table Using Oracle Flashback Drop – V$UNDOSTAT – DBA_RECYCLEBIN SQL> select CURRENT_SCN from v$database; “Creating a normal restore point assigns a restore point name to an SCN or specific point in time. Thus, a restore point…

[OCM 12C] Performing a full database backup

brunors

Database Backup and Recovery User’s Guide -> 4 Starting and Interacting with the RMAN Client Database Backup and Recovery User’s Guide -> 9 Backing Up the Database – Backing Up the Root with Oracle Enterprise Manager Cloud Control – Backing Up PDBs with Oracle Enterprise Manager Cloud Control Database Backup and Recovery User’s Guide -> 10 Backing Up the Database: Advanced Topics Database Backup and Recovery User’s Guide -> 11 Reporting on RMAN Operations Database Backup and Recovery User’s Guide -> 15 Diagnosing and Repairing Failures with Data Recovery Advisor…

Configuring RMAN

brunors

Database Backup and Recovery User’s Guide -> 5 Configuring the RMAN Environment Database Backup and Recovery User’s Guide -> 6 Configuring the RMAN Environment: Advanced Topics Database 2 Day DBA -> Performing Backup and Recovery -> Configuring Your Database for Basic Backup and Recovery -> Configuring Backup Settings Enabling the Fast Recovery Area – DB_RECOVERY_FILE_DEST_SIZE – DB_RECOVERY_FILE_DEST

Installing the EM Cloud Control agent

brunors

Enterprise Manager Command Line Interface -> 1 EM CLI Overview and Concepts Enterprise Manager Command Line Interface -> 2 Downloading and Deploying EM CLI Enterprise Manager Command Line Interface -> 3 Using EM CLI Enterprise Manager Cloud Control Advanced Installation and Configuration Guide -> 6 Installing Oracle Management Agent in Silent Mode Enterprise Manager Cloud Control Administrator’s Guide -> 22 Administering Enterprise Manager Using EMCTL Commands – Installing a Management Agent Using the AgentPull Script – Installing a Management Agent Using the agentDeploy Script – Installing a Management Agent Using…

Managing network file directories

brunors

Managing network file directories The purpose of this topic is create some files as tnsnames.ora, listener.ora and sqlnet.ora through SQL and GUI. – Oracle Net Manager (NETMGR) :Oracle Connection Manager is a proxy server that forwards connection requests to databases or other proxy servers. It operates on the session level. It usually resides on a computer separate from the database server and client computers. Oracle Connection Manager is available for installation with Oracle Database 12c Enterprise Edition. – Oracle Restart Configuration (You must install GRID configuration first); – Listener or…

Configuring shared server

brunors

“With the shared server architecture, many client processes connect to a dispatcher” “… is useful when a system is overloaded or has limited memory.” “Shared server is enabled by setting the SHARED_SERVERS initialization parameter to a value greater than 0. The other shared server initialization parameters need not be set.” – Some parameters: – SHARED_SERVERS > 0, MAX_SHARED_SERVERSDISPATCHERS, SHARED_SERVER_SESSIONS, MAX_DISPATCHERS, CIRCUITS “To calculate the initial number of dispatchers to create during instance startup, use the following formula: Number of dispatchers = CEIL ( max. concurrent sessions / connections for each…