0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email Note: You can review the environment setup part of the tutorial here. Now that we have all DRPGs created and associated, it is time to add members to each DRPG (primary and standby). For the primary (Ashburn) DRPG we will add:…
Category: 12c
Playing with the new OCI Full Stack DR – Part 1 – Preparing the Environment
2 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 1 Whatsapp 1 Email I am very happy to announce the GA of the new Oracle Cloud Infrastructure (OCI) solution that the Oracle MAA team has been working very hard to bring to you (Thank you, Suraj Ramesh). Today we will play with the new,…
Back-to-Basics: Understanding Backup and Recovery plus High Availability(Part II – Redo)
2 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 2 Whatsapp 0 Email What is redo? Let’s look briefly at the redo process. When Oracle blocks (the smallest unit of storage in a database) are changed, including UNDO blocks, Oracle records the changes in vector changes, which are referred to as redo entries or…
Back-to-Basics: Understanding Backup and Recovery plus High Availability(Part I)
3 Shares 0 Facebook 0 Twitter 1 Linkedin 0 Facebook-messenger 2 Whatsapp 0 Email The constant evolution of IT has, among other things, affected the role of a database administrator (DBA). Today the DBA is not merely a Database Administrator anymore but is morphing more into the Database Architect role. If you want to become…
Playing with Active Data Guard – DML Redirection and Automatic Block Media Recovery
5 Shares 0 Facebook 1 Twitter 3 Linkedin 0 Facebook-messenger 1 Whatsapp 0 Email Today we will be playing with two functionalities of Oracle Active Data Guard (ADG): DML Redirection Automatic Block Media Recovery DML Redirection is the capability ADG has to redirect DML operations made in the active-standby node to the primary node without…
Playing with Oracle Database Security Assessment Tool (DBSAT)
2 Shares 1 Facebook 1 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email The Database Security Assessment Tool (DBSAT) is an incredible free command line tool provided by Oracle Corporation as a utility to help you verify your database for common database security issues(including security policies and controls in place), as well as helping to identify possible…
Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email The idea for this scenario is to learn how to migrate an Oracle Database from on-premises to Oracle Cloud DBaaS by using a previously done backup using Oracle Cloud Backup Services. First, we will create an Oracle Database Cloud Services database deployment…
Playing with Oracle Database Cloud Backup Service
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email This article will show you how easy is to make use of Oracle Cloud to securely store all our on-premises Oracle Database Backups. Note that backups stored in Oracle Cloud can also be used to create new Oracle Database Instances (DBaaS)….
Playing with CrashSimulator
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email Hi everyone, Today I will show you how CrashSimulator (Shell Script – current version 1.04) works in detail. When unzipping the zip file you will find the following files within it: CrashSimulator.sh.x – For high-resolution ssh emulator screens, it shows all…
Playing with Oracle Database Cloud Service – Virtual Image – How to use and create a database STEP by STEP
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email The Oracle Database Cloud Service (ODCS) Virtual Image option gives you some extra flexibility on how to deploy databases in the Oracle Cloud. When deploying an instance using the normal Oracle Database Cloud Service it will per default create an instance…