| RMAN backup [message #493743] |
Wed, 09 February 2011 11:00  |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
Is it possible to restore dropped table OR wrongly updated table using RMAN backup.
Or we have to take daily export for this purpose......
|
|
|
|
|
|
| Re: RMAN backup [message #493750 is a reply to message #493743] |
Wed, 09 February 2011 11:23  |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
Yes, you can restore dropped table from an rman backup, but unfortunately it involves first restore and PIT recovery to new instance and then export the table from there.
[Updated on: Fri, 11 February 2011 07:53] by Moderator Report message to a moderator |
|
|
|
| Re: RMAN backup [message #493788 is a reply to message #493743] |
Wed, 09 February 2011 21:39 |
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
|
Senior Member |
|
|
RMAN, itself, cannot restore tables. You can use TSPITR (Tablespace Point In Time Recovery) to restore an entire tablespace via an Auxiliary Instance.
If you want only one table, you have to do a Manual RESTORE+RECOVER of the tablespace that contains the table (PLUS SYSTEM, SYSAUX and UNDO) *INTO A SEPERATE DATABASE INSTANCE* and then export that one table out of that database instance.
Hemant K Chitale
|
|
|
|
| Re: RMAN backup [message #493931 is a reply to message #493750] |
Thu, 10 February 2011 10:31 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
U mean First I have to restore entire RMAN backup to another machine then export desire table...... And finally import it into affected DB.
If it is so.....
Then I thing we have to take daily export also for this purpose....
Am I right...
|
|
|
|
|
|
| Re: RMAN backup [message #493941 is a reply to message #493932] |
Thu, 10 February 2011 10:58 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
No it is not possible..
But the solution is Export Level 0 on first day of week and export incremental rest of days of week.....
|
|
|
|
|
|
| Re: RMAN backup [message #493947 is a reply to message #493946] |
Thu, 10 February 2011 11:05 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
Not tried yet But planning to adopt it...
If RMAN backup cannot be used to restore a single table and export is not possible because 1TB Database....
Then what is the best solution...
|
|
|
|
|
|
|
|
|
|
|
|
| Re: RMAN backup [message #494015 is a reply to message #493947] |
Thu, 10 February 2011 20:04 |
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
|
Senior Member |
|
|
Error Correction Support for Incremental Export ended 31-Dec-1999 and Extended Assistance Support ended 31-Dec-2002.
Incremental Export actually exports the whole table for every table that has had at least one modified row.
So, if your 1TB database consists of 400 tables at least 1 row in 320 of them has been modified (insert/update/delete), those 320 tables will be exported in their entirety.
The Backup-Restore method doesn't require the whole database to be restored -- only the SYSTEM, UNDO, SYSAUX Tablespaces and the datafiles that contain the table you need to access (you don't really have to restore the whole tablespace if you have a map of which datafiles contain that table - e.g. from dba_extents).
Hemant K Chitale
|
|
|
|
| Re: RMAN backup [message #494429 is a reply to message #494015] |
Mon, 14 February 2011 11:11 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
So I conclude RMAN backup is not for single table restore (logical error) Even It is for physical error like datafile lost etc....
Am I right..
|
|
|
|
|
|
| Re: RMAN backup [message #494435 is a reply to message #494431] |
Mon, 14 February 2011 11:37 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
I understand I cannot export 1TB daily. even using incremental.
But if I have about 5G daily export than I can do export daily....
with RMAN backup parallel.
|
|
|
|
| Re: RMAN backup [message #494444 is a reply to message #494435] |
Mon, 14 February 2011 12:24 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:even using incremental.
Above all when it no more exists!
Quote:But if I have about 5G daily export than I can do export daily....
And you accept to lose the current day modifications.
Why not configuring flasback if this is a real concern for you?
Regards
Michel
[Updated on: Mon, 14 February 2011 12:25] Report message to a moderator |
|
|
|
| Re: RMAN backup [message #494691 is a reply to message #494444] |
Wed, 16 February 2011 10:35 |
smunir362
Messages: 310
Registered: September 2007
|
Senior Member |
|
|
AS your previous post
"RMAN, restore, recover and export/import.
If you use a 10 years old product you have 10 years old features."
Unfortunately I am using that release i.e. 9i....
I cannot upgrade it to 10g to get flashback power...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
