Year: 2018

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…

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…

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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based…

Database Backup and Recovery User’s Guide -> 13 Managing a Recovery Catalog brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general. (Continue reading)

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 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…

“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…

– 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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil,…

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…

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…