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...)
So there I was, reading on the internet about having set echo on for RMAN and started to incorporate it into RMAN scripts.
It was a waste of time since it is not needed according to my test cases.
Lesson learned is that don’t trust what is provided to you (more...)
So there I was, working on a request for how to restore from a specific backup.
Since the backup was using TAG, the easy solution is:
start database mount.
restore controlfile from autobackup
startup mount database
restore database from tag ‘TAG’;
recover database / recover database until sequence
open database (more...)