OraFAQ Forum: Backup & Recovery » Image copy and Backupset Using.

Home » RDBMS Server » Backup & Recovery » Image copy and Backupset Using.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Image copy and Backupset Using. [message #245823 is a reply to message #245548]

Mon, 18 June 2007 22:35

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

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?

Report message to a moderator

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.

Report message to a moderator

Re: Image copy and Backupset Using. [message #246428 is a reply to message #246024]

Wed, 20 June 2007 22:15

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

DreamzZ wrote on Tue, 19 June 2007 21:43

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?

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?

Report message to a moderator

Re: Image copy and Backupset Using. [message #246469 is a reply to message #246428]

Thu, 21 June 2007 01:13

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You can specify FROM BACKUPSET with the RESTORE command.

Report message to a moderator

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

Previous Topic:	Export with compress=y not working?
Next Topic:	I cant open my Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 09:41:47 CDT 2025