Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
Backup and Recovery | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Performing a database clone using a Data Guard Snapshot Database

  • Posted by Gavin Soorma
  • On January 28, 2015
  • 1 Comments
Some times we need to have an exact replica of the production database data to urgently test an issue encountered in production. If the production database is very large having a clone process running on the production server or taking a fresh full database backup just for the clone is also not desirable as well […]
Read More
 

12c RMAN New Feature – Cross Platform Data Transport Using Incremental Backups

  • Posted by Gavin Soorma
  • On August 12, 2014
  • 1 Comments
In Oracle 12c we can now transport data across platforms using full as well as incremental backup sets. The use of RMAN Incremental backups can significantly reduce overall application downtime during cross-platform data migration and will be useful in any 11g to 12c future upgrades. In this example we look at migrating data from an […]
Read More
 1

Creating an Oracle 12c Data Guard Active Standby Database

  • Posted by Gavin Soorma
  • On November 19, 2013
  • 1 Comments
This note examines how to create an Oracle 12.1.0 physical standby Active Data Guard database using the RMAN DUPLICATE FROM ACTIVE command. We will be creating the data guard configuration in a 12c Container Database. Remember – in 12c Data Guard is set up at the Container level and not the individual Pluggable database level […]
Read More
 1

12c New Feature – RMAN RECOVER TABLE

  • Posted by Gavin Soorma
  • On July 26, 2013
  • 0 Comments
One of the good new features in Oracle 12c is the ability to restore a single table or a single partition of a partitioned table from an RMAN backup via the RECOVER TABLE command. Prior to 12c restoring a table was a long drawn out and difficult affair. So when may we use this fearure? […]
Read More
 

Restore RMAN backup to another server for testing disaster recovery procedures as well as for cloning

  • Posted by Gavin Soorma
  • On July 5, 2013
  • 0 Comments
This note explains the procedure used to restore an Oracle Suggested Strategy incremental backup on another server. This is useful when we have to do periodic  testing of disaster recovery procedures where we simulate a scenario when the complete database server has crashed and a new server has been provisioned. But let us assume that […]
Read More
 

RMAN Backup and Recovery scenarios involving loss of SPFILE

  • Posted by Gavin Soorma
  • On June 17, 2013
  • 3 Comments
Let us look at some backup and recovery scenarios pertaining to the SPFIILE. The SPFILE is a small but very important file and if we lose the spfile, we cannot start the database even if all the other database files are present and intact. So in my opinion, it is quite an important thing to […]
Read More
 3

Restoring a ASM backup to non-ASM and restoring from RAC to single-instance

  • Posted by Gavin Soorma
  • On February 25, 2013
  • 2 Comments
Scenario: 1) We want to restore the production database which is running on two-node RAC environment in a test non-RAC environment 2) We want to restore the backup residing on ASM disk groups in a non-ASM file system. Note: The production database orcl has two instances named orcl1 and orcl2. The database will be restored […]
Read More
 1

Performing a 32 bit to 64 bit migration using the Transportable Database RMAN feature

  • Posted by Gavin Soorma
  • On October 17, 2012
  • 0 Comments
This note describes the procedure used to perform a 32 bit to 64 bit conversion of an 11.2.0.3 database on the Linux platform. The RMAN CONVERT DATABASE command is used to automate the movement of an entire database from one platform (the source platform) to another (the destination platform). This is provided that the source […]
Read More
 

RMAN 11g new feature – Backup Fast Recovery Area (FRA) to Disk

  • Posted by Gavin Soorma
  • On August 3, 2012
  • 1 Comments
  In Oracle 11gR2, there is a good new feature whereby we can backup the fast or flash recovery area to a disk location which could be a remote destination via a NFS attached file system. In earlier releases, we could only backup the Flash Recovery Area to tape and not disk via RMAN. Recovery […]
Read More
 

Diagnosing and Repairing Failures with 11g Data Recovery Advisor

  • Posted by Gavin Soorma
  • On July 12, 2012
  • 0 Comments
The 11g Data Recovery Advisor is part of the 11g database health checking framework and diagnoses persistent data failures and not only presents options to repair and fix the problem but also can execute the repair and recovery process at our request. The Repair Advisor can take away lot of the stress associated with peforming […]
Read More
 

Performing a database clone using a Data Guard physical standby database

  • Posted by Gavin Soorma
  • On April 19, 2012
  • 3 Comments
A common DBA task is to perform regular clones and database refreshes of the production database for the purpose of setting up training or test or development environments. If we are having a physical standby Data Guard environment, then we can easily offload the potentially I/O and CPU intensive backup process required for creating these […]
Read More
 

RMAN Duplicate Database RAC to RAC

  • Posted by Gavin Soorma
  • On April 4, 2012
  • 0 Comments
This note outlines the procedure to clone or refresh an Oracle Real Application Clusters database using the RMAN Duplicate Database feature. In case of a RAC to RAC clone, with RMAN Duplicate we first create a target or duplicate single instance database and then convert the single instance database to a RAC database. While the […]
Read More
 1

Oracle 11g Cross Platform Active Standby – Windows Primary database and Linux Active Standby

  • Posted by Gavin Soorma
  • On November 8, 2011
  • 0 Comments
This note describes the procedure of configuring a cross platform using the 11g RMAN Active Duplicate as well as an Active Standby Database setup over a Windows and Linux platform. The Metalink note Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1] describes the supported cross platform combinations […]
Read More
 

Recovery through RESETLOGS and reset of the incarnation of the database

  • Posted by Gavin Soorma
  • On October 27, 2011
  • 1 Comments
Prior to Oracle 10g, the redo log files generated after opening the database with RESETLOGS could not be used with the backups taken before the RESETLOGS was performed. Therefore, whenever a resetlogs was done, it was important to take an immediate full database backup, since all previous backups became invalid. Just to recap, a RESETLOGS […]
Read More
 4

11g RMAN Duplicate from Active Database and ORA-01017

  • Posted by Gavin Soorma
  • On September 8, 2010
  • 0 Comments
Recently while performing an 11g Release 2 Active Database duplication, I encountered an error which one would normally associate with password files and the fact that the SYS password is not the same on the source and target databases. RMAN-03002: failure of Duplicate Db command at 09/01/2010 09:17:39 RMAN-03015: error occurred in stored script Memory […]
Read More
 

Some more RMAN Recovery Scenarios

  • Posted by Gavin Soorma
  • On June 25, 2010
  • 11 Comments
I have added a few more RMAN recovery scenarios which I have come across recently and may be faced by others – so thought I’d share those with the community. The first relates to a case where we need to create a replica of a production database on a test or development environment and we […]
Read More
 

RMAN KEEP FOREVER, KEEP UNTIL TIME and FORCE commands

  • Posted by Gavin Soorma
  • On April 9, 2010
  • 2 Comments
The KEEP FOREVER option in 11g has been improved over what was available in Oracle 10g from the point of view that in 11g, only the archivelogs which are required to keep the online backup consistent are retained. In Oracle 10g we could roll forward this backup taken with the KEEP FOREVER option allowing point […]
Read More
 

Duplicate from active database – ASM Primary to ASM Standby

  • Posted by Gavin Soorma
  • On December 8, 2009
  • 0 Comments
In my earlier post 11g Standby Database Creation Without Any RMAN Backups I had illustrated how to create a standby database using the 11g Active Duplication feature which enabled us to create a standby database without any backup taken of the primary database. In this case it was a ASM Primary and a non ASM […]
Read More