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 FROM ( SELECT CASE WHEN s.backup_type='L' THEN 'ARCHIVELOG' WHEN s. (more...)
First and foremost, thank you to all the bloggers sharing their knowledge.
Free Block Corruption is from a data file block which is now Free but used (more...)
Here are 2 good documents for reference:
Merged Incremental Backup Strategies (Doc ID 745798.1)
Oracle Backup and Recovery for a VLDB
You can find my playing around here
I did find the results of switch database to copy awkward with the data file name.
LAX:(SYS@db01)> show parameter db_create NAME (more...)