OraFAQ Forum: Backup & Recovery » RMAN BACKUP from SNAPSHOT

Home » RDBMS Server » Backup & Recovery » RMAN BACKUP from SNAPSHOT

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

RMAN BACKUP from SNAPSHOT [message #457856]

Wed, 26 May 2010 03:52

saptek
Messages: 4
Registered: May 2010

Junior Member

Hello,

Is it possible to backup a pointer-based snapshot with RMAN ?

How does RMAN works with this kind of snapshot ?

Any doc appreciated..

Thanks
SAPTEK.

Report message to a moderator

Re: RMAN BACKUP from SNAPSHOT [message #457859 is a reply to message #457856]

Wed, 26 May 2010 04:00

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

if "pointer-based" means "point in time", no it is not possible, RMAN backs up what is current and not what was in the past.

Regards
Michel

Report message to a moderator

Re: RMAN BACKUP from SNAPSHOT [message #457864 is a reply to message #457859]

Wed, 26 May 2010 04:10

saptek
Messages: 4
Registered: May 2010

Junior Member

Thanks for reply....

I don't understand what "in the past means" ...

A point-in time snapshot is just a frozen picture of the DB....

if you shutdown your DB now and backup it with RMAN next week, it is also in the past....

what's the problem ???

Regards

Report message to a moderator

Re: RMAN BACKUP from SNAPSHOT [message #457865 is a reply to message #457864]

Wed, 26 May 2010 04:14

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So what do you mean with your "point-in-time" backup?
If you want to mean backup at a precise scn for all data, RMAN does not do this, it backups the data as there are when it reads them.

Regards
Michel

Report message to a moderator

Re: RMAN BACKUP from SNAPSHOT [message #457869 is a reply to message #457865]

Wed, 26 May 2010 04:22

saptek
Messages: 4
Registered: May 2010

Junior Member

a pointer based snapshot is a set of pointers addressing reals blocks of the DB if not modified and a copy of the modified blocks before modification for those modified since snapshot...

it's a kind of dynamic clone...

understand what i mean ?

Michel si tu es français on pourrais peut etre changer de langue Razz

Thanks

Report message to a moderator

Re: RMAN BACKUP from SNAPSHOT [message #457877 is a reply to message #457869]

Wed, 26 May 2010 04:44

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ok I understand what you mean.
As far as I know RMAN does not natively offer this feature, maybe through a MML.

Regards
Michel

Report message to a moderator

Re: RMAN BACKUP from SNAPSHOT [message #457878 is a reply to message #457877]

Wed, 26 May 2010 04:45

saptek
Messages: 4
Registered: May 2010

Junior Member

Thanks for your reply...

SAPTEK.

Report message to a moderator

Re: RMAN BACKUP from SNAPSHOT [message #457884 is a reply to message #457878]

Wed, 26 May 2010 04:52

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I keep this topic in english as other more skilled people like Mahesh Rajendran can answer (if we move to french then the topic should have to be moved to French forum).

Regards
Michel

Report message to a moderator

Previous Topic:	rman tablespace restore
Next Topic:	Archive log files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 03:07:17 CST 2025