Alejandro Vargas' Blog
- June 5, 2008
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
Join the discussion
Comments ( 6 )
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
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
thanks for the amazing detailed presentation!
Ofir
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.