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
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
[OCM 12C] Configuring recovery catalog
Database Backup and Recovery User’s Guide -> 13 Managing a Recovery Catalog
Installing the EM Cloud Control agent
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
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
“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…
Administering database configuration files
– Database Administrator’s Guide -> 11 Managing the Redo Log – Database Administrator’s Guide -> 9 Managing Diagnostic Data – Database Administrator’s Guide -> 14 Managing Data Files and Temp Files – Database Administrator’s Guide -> 40 Administering a CDB with SQL*Plus (ALTER SYSTEM SET) – Database Administrator’s Guide -> Initialization Parameters
Configuring the network environment to allow connections to multiple databases
Database Net Services Administrator’s Guide -> 2 Creating and Configuring an Oracle Database (to get the parameter file 2.6.1.1 Sample Initialization Parameter File) Database Net Services Administrator’s Guide -> 9 Configuring and Administering Oracle Net Listener Database Net Services Administrator’s Guide -> 9 Configuring and Administering Oracle Net Listener -> Configuring Listening Protocol Addresses Using Oracle Enterprise Manager Cloud Control Database Net Services Reference -> 7 Oracle Net Listener Parameters in the listener.ora File (There are some listener examples in this page) Database Net Services Reference -> 6 Local Naming…
Administering users, roles, and privileges
What you must to have in mind: – How to create an user; – Conceive grants for the created user; – Manage those grants through roles; – Query the information regarding the created user using views; – Understanding about local and common users also local and common profiles; – Manage tablespaces for the created user. — Users: “Common users perform administrative tasks for a CDB.” Local users exists only in the PDBs. “The root has its own data files, and each PDB has its own data files.” “There is a…
Creating and managing pluggable databases
1- Create a CDB with/without DBCA: The specific methods for creating a CDB are: – With the CREATE DATABASE SQL statement. (There is a slight difference between the script to create a database with/without CDB) – You must enable PDBs (ENABLE PLUGGABLE DATABASE clause must be set to TRUE in Pfile/Spfile) ; – You must specify the names and locations of the root’s files and the seed’s files. – Seed’s files (1 of the 3 options): 1- The SEED FILE_NAME_CONVERT clause 2- Oracle Managed Files 3- The PDB_FILE_NAME_CONVERT initialization parameter…