Comparing Oracle Database Backup Service (ODBS) and Oracle Secure Backups (OSB) to Amazon Web Services (AWS) This is part 3 of a 3 part series on “Getting Started with Oracle Cloud Backups”. Part 1 covers setting up RMAN to backup…Read More >
Getting Started with Oracle Cloud Backups – Amazon Web Services (AWS) This is part 2 of a 3 part series on “Getting Started with Oracle Cloud Backups”. Part 1 covers setting up RMAN to backup directly to the new Oracle…Read More >
Getting Started with Oracle Cloud Backups – Oracle Cloud Database Backup Service (ODBS) This is part 1 of 3 in a series on “Getting Started with Oracle Cloud Backups”. Part 1 covers setting up RMAN to backup directly to the new…Read More >
There are lots of considerations to be taken into account when migrating databases to the Exadata. It’s like any other migration. DBAs and other stakeholders of the system have to evaluate what to migrate and what not to, physical and…Read More >
Background I ran into a situation where we needed to recover from an old online backup which (due to some issues with the RMAN “KEEP” command) was missing the archived redo log backups/files needed to make the backup consistent. The…Read More >
I am a simple person who likes simple things, especially RMAN backup implementation. I have yet to understand why RMAN backup implementation does not use configure command, and if you have a good explanation, please share. Examples for RMAN configure…Read More >
Among the most critical but often most neglected database administration tasks is testing restore from backup. But sometimes, you don’t have a test system handy, and need to test the restore on the same host as the source database. In…Read More >
Lately, I am becoming infatuated with RMAN again. Have you ever run “restore database preview”? Are you curious about how the recovery SCN are determined? Media recovery start SCN is 1515046 Recovery must be done beyond SCN 1515051 to clear…Read More >
The RMAN VALIDATE RECOVERY FILES command is a simple way to validate all backups, or so I thought.
In some versions it is broken, and in the versions where the bug has been fixed, it is even more broken.
Update: 09/March/2015 .- I wrote a second part and followed up on this on my personal blog RMAN 12cR1 : Say goodbye to your backup when dropping your PDB – Part II I was working on my presentations for IOUG Collaborate,…Read More >