OraFAQ Forum: Backup & Recovery » How to Backup and Recovery TABLE with RMAN

Home » RDBMS Server » Backup & Recovery » How to Backup and Recovery TABLE with RMAN

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

How to Backup and Recovery TABLE with RMAN [message #263316]

Wed, 29 August 2007 12:49

tony_pe
Messages: 17
Registered: August 2007

Junior Member

Hi, my question is: How to backup and recovery TABLE with RMAN?; this is because my single policy of backup this cradle in RMAN.

Additional questions:
1) NOT it can single with RMAN?
2) I must use import/export necessarily?
3) Flash recovery Area?

thanks

Report message to a moderator

Re: How to Backup and Recovery TABLE with RMAN [message #263317 is a reply to message #263316]

Wed, 29 August 2007 12:52

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

How to backup and recovery TABLE with RMAN?;

You can't

Quote:

this is because my single policy of backup this cradle in RMAN.

whats your policy??

Quote:

1) NOT it can single with RMAN?

No you can't

Quote:

2) I must use import/export necessarily?

Yes

Quote:

3) Flash recovery Area?

new in 10g keeps recover related files.

Report message to a moderator

Re: How to Backup and Recovery TABLE with RMAN [message #263319 is a reply to message #263317]

Wed, 29 August 2007 12:57

tony_pe
Messages: 17
Registered: August 2007

Junior Member

thanks DreamzZ for your answer,

According to your appreciation, a strategy of backup to be cradle in RMAN and Import/Export?

Report message to a moderator

Re: How to Backup and Recovery TABLE with RMAN [message #263329 is a reply to message #263319]

Wed, 29 August 2007 13:43

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Backup policy depends on your data importance.

Report message to a moderator

Re: How to Backup and Recovery TABLE with RMAN [message #263380 is a reply to message #263316]

Wed, 29 August 2007 22:27

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

Senior Member

For table handling specially I recommend you to on your flashback feature.

Alter database flashback on

Report message to a moderator

Re: How to Backup and Recovery TABLE with RMAN [message #263381 is a reply to message #263316]

Wed, 29 August 2007 22:29

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

Senior Member

Quote:

recovery TABLE

@Questioner,

Export/import restores table. If you are looking for recovery look at RMAN.

Report message to a moderator

Re: How to Backup and Recovery TABLE with RMAN [message #264016 is a reply to message #263381]

Fri, 31 August 2007 09:13

tony_pe
Messages: 17
Registered: August 2007

Junior Member

The question goes, if it is that only using RMAN can be recovered one TABLE;
if this is feasible, then how to takes Backup/recovery with RMAN.
But, as it is the best form to do import/export?

Report message to a moderator