This week I migrated our EM12c repository database to a new server as part of it's promotion to production status. Just to make it a little more exciting, the migration also involved an in-flight upgrade from 126.96.36.199 to 188.8.131.52. Much of this post is directly inspired by Martin Bach's post on the same subject
. I ran into a few other snags that weren't mentioned so I thought it would (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...)
Last Friday I kicked off a database backup to an NFS destination, using the standard "backup as compressed backupset database" syntax. Loyal readers of this blog may recall that I'm the proud custodian of a 25 Tb database, so this backup normally takes a few days, with an expected completion on Monday morning. However it was still running on Wednesday, and reviewing the logs I saw that there was just 1 channel (of the original (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 184.108.40.206 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 was tested on Oracle 11.2. I had an input or target database as follows:
SQL> select name from v$database
1 select tablespace_name, file_name
2* from dba_data_files order by 1
I wanted to create an output or auxiliary or clone database called (more...)
I've recorded backups on tape to RMAN repository several times already, but every next time I needed to do that I was searching through notes to find proper procedure.
This time I will note procedure in form of the blog post.
Test is performed on Oracle version 220.127.116.11.
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';
When I sat down at my desk yesterday morning I was greeted with some disturbing email alerts notifying me that one of the NFS mounts on my standby database host was full. This was the NFS mount that held an image copy of my database that is updated daily from an incremental backup. The concept and an example can be found in the documentation
. With a 25Tb database, waiting to restore from backups is not (more...)
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 18.104.22.168.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
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...)
We want restore backup from source. So we took backup from source and copied it to /dba/share/MYDB on target. My collouge sent me email saying restore failed with following error
rman target /
Recovery Manager: Release 22.214.171.124.0 - Production on Wed Sep 18 20:47:38 2013
In this post I want to explain how to create duplicate database from active 11gR2 database using RMAN. There are many blog posts covering that subject but most of them are covering non-ASM to non-ASM, ASM to ASM or non-ASM to ASM duplications.
I want to cover ASM to non-ASM (more...)
I am regular follower of Oracle-l
mailing list which is great source of knowledge for Oracle experts. Two days ago one Oracle DBA posted question “RMAN restore/recover problem
” which induced me to re-check my knowledge about some RMAN PITR scenarios.
So I’ve performed some tests and decided to (more...)
Starting with 11g Oracle can perform block media recovery using flashback logs to get good copies of the blocks.
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...)
In this post I will describe how to change Oracle SID using utility DBNEWID. As I can see DBNEWID is available from 9i version but I’ve never heard about it. Till now, I have used procedure where I’m manually editing and re-creating control file.
But I think it’s much better (more...)
When the 126.96.36.199.1 release of the Exadata Storage Server software was released, I was a little excited. There were numerous oneoff patches for the previous release, 188.8.131.52.0, which was the first version to support the Exadata X3, writeback flashcache, run UEK on the X#-2 systems, etc. With that many large changes introduced in one version, it was likely to see some bugs in the .0 release. Fortunately, Oracle was quick to fix many of those issues, but it resulted in several separate patches to update the cellsrv software.
I was working with (more...)