[OCM 12C] Configuring and monitoring Flashback Database

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

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 brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a…

[OCM 12C] Configuring recovery catalog

Database Backup and Recovery User’s Guide -> 13 Managing a Recovery Catalog brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely…

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 brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc…

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…