| Image copy and Backupset Using. [message #245548] |
Mon, 18 June 2007 02:05  |
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
 
|
|
What I know is that Incremental backup cant be performed by Image copy. If I have an image copy of a datafile then I can use that backup image copy as online data file of a database(using set new name+ switch). (correct me if I am wrong).
Now if I have backup set then can I use set newname +switch command of that backup set file. i.e can I make the backup set data file as online by using these two commands?
[Updated on: Mon, 18 June 2007 02:07] Report message to a moderator |
|
|
|
| Re: Image copy and Backupset Using. [message #245708 is a reply to message #245548] |
Mon, 18 June 2007 10:32  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | What I know is that Incremental backup cant be performed by Image copy
|
Yes only in 10g by enabling change tracking.
If I have an image copy of a datafile then I can use that backup image copy as online data file of a database(using set new name+ switch). (correct me if I am wrong).
yes you can and for whole database you can use this command.
RMAN> switch database to copy
| Quote: | Now if I have backup set then can I use set newname +switch command of that backup set file
|
No need in backupset.
| Quote: | i.e can I make the backup set data file as online by using these two commands?
|
explain
|
|
|
|
|
|
| Re: Image copy and Backupset Using. [message #246024 is a reply to message #245823] |
Tue, 19 June 2007 10:43 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Arju wrote on Mon, 18 June 2007 21:35 | I have backup set of a database. I want to use that. How I will do that? Dream u said no need to use switch. But my question is how control file will find which backup set I will use?
|
when you take backup on rman rman write the backup information in your controlfile.if you have more than 1 backups then rman determine it from controlfile which 1 is the best and which i should use for recovery.
|
|
|
|
|
|
|
|
| Re: Image copy and Backupset Using. [message #246713 is a reply to message #246469] |
Thu, 21 June 2007 12:03 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | Suppose I have 2 backup set. If I restore then latest one will be restored. But I want to restore the oldest one. How I will do that? Got my point?
|
RMAN>BACKUP DATABASE TAG = 'FULL_BACKUP';
RMAN>RESTORE DATABASE from TAG ='FULL_BACKUP;
TAG OPTION overrides the default selection of the most recent backups or file copy available. The tag restricts the automatic selection to backup sets or file copies that have the specified tag. If multiple backup sets or file copies have a matching tag, then RMAN selects the most recent one.
[Updated on: Thu, 21 June 2007 12:03] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
