I was working on a script for the ultimate RMAN backup validation and hoping to submit the article for an Oracle conference.
To my chagrin, one version of the script was failing for one condition and the other version would failed for another condition.
Basically, the script was very buggy.
The objective is to create a RMAN script to validate 8 backupset at a time.
I decided to use Bulk Collect and Limit clause.
Please click link here to read my blog at Pythian.
Great post from Oracle on How to Deploy a Four-Node Oracle RAC 12c Cluster in Minutes.
Just a few notes to for me to remember and share.
From the section:
Import the Oracle VM Templates You Downloaded
4. From the Oracle VM Manager GUI, import the template files by providing both URLs for the same import session. The import process will take several minutes; be patient.
I used the URL below:
So there I was, working on a request to determine if users in the database are read only or read write. Sounds pretty simple, right?
Someone once said, “Good artists copy, great artists steal.” In my case, there was nothing to steal.
Basically, there are system, role, table, and (more...)
So there I was, working on a project to duplicate a database from a volume copy at the storage level with the database being shutdown.
Sounds pretty simple right? Wrong! Put the database on ASM and it becomes complicated and convoluted.
Volume1 has ASM disk group in the fashion +DG1/db01/datafile, +DG1/db01/onlinelog +DG1/db01/tempfile
So there I was, one Thanksgiving I came across Randy Pausch’s Last Lecture and wanted to share with you.
“Everything should be made as simple as possible, but not simpler.” – Albert Einstein
I am curious as to why anyone would use ASM for a standalone database as it introduce more complexity of having to install, maintain, and upgrade Grid Infrastructure.
I asked the DBAs and here are (more...)
I have shared this with a few friends and colleagues here and there and thought I would blog about them.
Challenge – bored to death is not a good way to die.
Commute – driving 2 hours to work in traffic kills a lot of time.
Compensation – total compensation (more...)
So there I was, looking for a script to calculate the backup size. After several thoughts, it was not exactly what I was looking for.
Here’s the one I created.
SELECT TO_CHAR(completion_time, 'YYYY-MON-DD') completion_time, type, round(sum(bytes)/1048576) MB, round(sum(elapsed_seconds)/60) min
WHEN s.backup_type='L' THEN 'ARCHIVELOG'
WHEN s. (more...)
First and foremost, thank you to all the bloggers sharing their knowledge.
My previous post on corruption is here
The corrupt.sql script was stolen from here
exec SYS.DBMS_BACKUP_RESTORE.resetCfileSection(35) was stolen from here
Free Block Corruption is from a data file block which is now Free but used (more...)