Oracle Recovery Manager ( RMAN) Hands On Practice

Oracle Recovery Manager, RMAN, is at the same time simple and complex, it's sintax can be as direct as 'backup database' to make a whole database backup, and as complex as it can be to make possible the most sophisticated and complex backup and recovery tasks.

This post covers a series of tests I did prepare to show how Rman works, the tar of the scripts contained on the guide can be downloaded here.

This RMAN Hands-On guide, once you have configured the environment, can be followed in about 3 hours, it covers the basics of Backup, Restore and Recovery of Oracle Databases using RMAN.

This hands on practice is organized into 4 chapters

  • CATALOG
  • ADMINISTRATION    
  • BACKUP  
  • RESTORE AND RECOVERY

Each chapter contains a set of scripts that can be executed in order to implement the practice, it teaches the following points:

  • Build and administer an Rman Catalog
  • Use different techniques for backing up a Database
  • And the most important: How to restore and recover the database in different crisis scenarios

Comments:

Hi Alejandro, This is a Great Article! Thanks very much for your great rman Article. I am also using rman for our RAC Database.We are not using catalog database at the moment. I have a few questions: 1.Can we use the Oracle XE as rman catalog DB? and if we use a separate Catalog DB, do we have to license this Database? 2.When i want to make a rman consistent backup on RAC environment,i will have to first do a shutdown immediate, startup mount and then perform rman cold backup. Do we have to shutdown and startup mount all RAC instances to do this or we can just do this on one RAC instance while keeping the other instance(s) online? Do we have to change cluster_database=false before doing this? 3.We are using ASM + RMAN + FRA for our Databases.We are also backing up to tape using Networker software. Question: 3.1 I have rman default device type set to disk, but we also have tape channels configured. When i perform a crosscheck command , will this command be done for both disk and tape channels or will rman only crosscheck for files on disk? 3.2 What will be the behavior when i do a delete obsolete/expired command while having default device type disk, but at the same time having configured tape channels. 4.The rman commands: 4.1 backup recovery area and 4.2 backup recovery files command 4.1 backs up all recovery files + backupsets from FRA to tape. On what occasion do we have to use command 4.2? Do we use command 4.2 if one has not configured FRA? Best Regards, Pasko

Posted by Pasko on June 08, 2008 at 03:57 PM IDT #

Hi Alejandro, Have read your hands on with interest. I'm missing a part in the migration of datafiles to ASM. The tool used is RMAN. All files work freat except for the control files, as we have a standby which will migrate later in time I cannot afford to do a "alter database open resetlogs". How can I put the controlfiles in ASM without doing a resetlogs?? Greetings, Rick

Posted by Rick on June 11, 2008 at 05:40 PM IDT #

The link for the tar ball of scripts seems to be missing.

Posted by Cliff Wakefield on June 16, 2008 at 02:07 AM IDT #

Hi Alejandro, thanks for the amazing detailed presentation! Ofir

Posted by Ofir Manor on June 19, 2008 at 07:42 AM IDT #

Nice compilation.

Posted by Asif Momen on July 18, 2008 at 11:30 AM IDT #

Unfortunatly i deleted some archivelog in production 2 weeks back, then i found rman backup not successfull because of deleted archive, then i found deleted archived log from phycsical standby server & copied those to production archivelog location scn from 26420 to 27115. this week i took rman backup, it was completed but those copied archived not backedup atleast one. i checked tru a view v$archived_log column status,archived,backup_count result A yes 0 i crosschecked the archivelog, to delete unwanted archived & deleted using delete noprompt obsolete what is the work around to take backup those archive or no need to backup those archive (i took full backup only those archive only not backedup, so i could not delete those from archive location using absolete option) i m having daily Hotbacku & full dump backup also (20 GB )size of database. plase reply me. thanks in advance.

Posted by Mubarak Ali on March 28, 2009 at 06:19 AM IDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today