Home » RDBMS Server » Backup & Recovery » BAckup set,backup and backup piecec (windows xp,10.2.0.1)
BAckup set,backup and backup piecec [message #481135] Mon, 01 November 2010 00:12 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi guys I want to know the difference between backup,backup set and backup piececs in Rman.

1.Each backup set may consist of many backup pieces which are nothing but datafiles.

2.Each backup may consist of many backup sets.

Am I right about this?If so will all backup sets within a backup contain the same backup set number or different one.
Re: BAckup set,backup and backup piecec [message #481137 is a reply to message #481135] Mon, 01 November 2010 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Basics
For instance,
Chapter 1 Backup and Recovery Overview
Section 1.5 Backup and Recovery with RMAN
Paragraph 1.5.3.3 About Image Copies, Backup Sets and Backup Pieces
And follow the link "About RMAN Backup Formats: Image Copies and Backup Sets".

Regards
Michel


Re: BAckup set,backup and backup piecec [message #481140 is a reply to message #481137] Mon, 01 November 2010 01:58 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
I went through it.So suppose my backup consists of 3 backup sets.

1 backset--->datafile 1,2
2 backupset--->datafile 3,4
3 backupset--->archivelog

Now in my backup i have lost backup set 2 and 3 and I have only backup set 1.Does that mean RMAN can use it to recover datafile 1 and 2.

Thanks
Sekar
Re: BAckup set,backup and backup piecec [message #481141 is a reply to message #481140] Mon, 01 November 2010 02:07 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes and no, it depends of the purpose of your recovery and what you have beside that.

The best way to understand is to test by yourself.
Create a database and make some backup and recovery.

Regards
Michel
Previous Topic: Control file errors, ORA-00214
Next Topic: Rman backup mechanism
Goto Forum:
  


Current Time: Thu Mar 28 06:18:10 CDT 2024