Originally posted by me on the Pythian blog. This is an older post that I somehow forgot to post on my own blog, but another recent redundancy foul-up reminded me of it.
The story you are about to read is based on actual events. Names and paths have been changed to protect the innocent. I call this scenario “The Perfect Storm” because it took just the right combination of events and configurations. Sadly, this doesn’t (more...)
This post is related to 12c and an active database duplication for a standby I did in my lab environment. I’d say although I first encountered it on 12c there is a chance you run into a similar situation with earlier releases too.
I would normally use ASM for all my databases to make my life easier but this time I had to be mindful of the available memory on the laptop-which at 8 GB-is (more...)
In this article, I’ll explain how to manualy recover a standby database using the oracle RMAN new feature “RECOVER FROM SERVICE”. Configuration for the test HOSTS : 2 Virtual Machines with 2 GB of Memory OS : Oracle Linux 6.4 ORACLE VERSION : Oracle 188.8.131.52 Standard Edition A database named DB12C in archivelog mode has [...]
The post Recover standby database over the network (Oracle 12c new feature) appeared first (more...)
Another one of the cool but underrated features in 12c is the possibility to recover a physical standby over the network with one line in RMAN.
Why do you need to perform this activity? Assume someone really clever created a segment “nologging” and the database was not in force logging mode. This operation cannot be replicated by redo apply on the standby, and you are bound to have a problem. Or, in my case, I (more...)
This time I will note procedure in form of the blog post.
Test is performed on Oracle version 184.108.40.206.
These were my unsuccessful attempts:
3> allocate channel c1 device type 'sbt_tape';
4> send 'NSR_ENV=(NSR_SERVER=backup_server,NSR_CLIENT=oracle_client,NSR_DATA_VOLUME=OrclPool)';
5> catalog backuppiece 'ARCH_ORCL_rep2dod5_s128878_p1';
Before oracle 12c, recover a table from loss or corruption was a difficult affair. Most of the time you notice that the table is lost or corrupted too late to use the flashback technology and then the only way to go is to duplicate your database to a time the table was still valid, export [...]
The post Recover a table with RMAN (Oracle 12c new feature) appeared first on Oracle DBA Scripts and (more...)
I was recently configuring backup on the customers Exadata with IBM TSM Data Protection for Oracle and run into weird RMAN error. The configuration was Oracle Database 11.2, TSM client version 6.1 and TSM Server version 5.5 and this was the error:
[oracle@oraexa01 ~]$ rman target / Recovery Manager: Release 220.127.116.11.0 - Production on Wed Jan 29 16:41:54 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. (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...)
rman target /
Recovery Manager: Release 18.104.22.168.0 - Production on Wed Sep 18 20:47:38 2013
I want to cover ASM to non-ASM (more...)
So I’ve performed some tests and decided to (more...)
Flashback database is not enabled by default so first step would be to enable it. When enabled a process RVWR (Recovery Writer) copies modified blocks to flashback buffer. Later this buffer (more...)
But I think it’s much better (more...)