Home » RDBMS Server » Backup & Recovery » How to Backup and Recovery TABLE with RMAN
icon5.gif  How to Backup and Recovery TABLE with RMAN [message #263316] Wed, 29 August 2007 12:49 Go to next message
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
Re: How to Backup and Recovery TABLE with RMAN [message #263317 is a reply to message #263316] Wed, 29 August 2007 12:52 Go to previous messageGo to next message
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.
Re: How to Backup and Recovery TABLE with RMAN [message #263319 is a reply to message #263317] Wed, 29 August 2007 12:57 Go to previous messageGo to next message
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?

Re: How to Backup and Recovery TABLE with RMAN [message #263329 is a reply to message #263319] Wed, 29 August 2007 13:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Backup policy depends on your data importance.
Re: How to Backup and Recovery TABLE with RMAN [message #263380 is a reply to message #263316] Wed, 29 August 2007 22:27 Go to previous messageGo to next message
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
Re: How to Backup and Recovery TABLE with RMAN [message #263381 is a reply to message #263316] Wed, 29 August 2007 22:29 Go to previous messageGo to next message
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.
Re: How to Backup and Recovery TABLE with RMAN [message #264016 is a reply to message #263381] Fri, 31 August 2007 09:13 Go to previous messageGo to next message
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?
Re: How to Backup and Recovery TABLE with RMAN [message #264052 is a reply to message #264016] Fri, 31 August 2007 10:20 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
The question goes, if it is that only using RMAN can be recovered one TABLE;


No.

Quote:

if this is feasible, then how to takes Backup/recovery with RMAN.

http://www.scribd.com/search?query=rman+document+author%3A%28DreamzZ%29

Quote:
But, as it is the best form to do import/export?


Yes if you can tolerate transactions loss.
Re: How to Backup and Recovery TABLE with RMAN [message #264152 is a reply to message #263316] Sat, 01 September 2007 03:28 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

As I already said you want to handle table data then as soon as make flashback feature on. Don't look other features.
Previous Topic: Oracle Backup
Next Topic: Rman can't open
Goto Forum:
  


Current Time: Mon Dec 05 04:57:07 CST 2016

Total time taken to generate the page: 0.10587 seconds