Home » RDBMS Server » Backup & Recovery » RMAN backup
RMAN backup [message #493743] Wed, 09 February 2011 11:00 Go to next message
smunir362
Messages: 221
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 #493748 is a reply to message #493743] Wed, 09 February 2011 11:21 Go to previous messageGo to next message
Michel Cadot
Messages: 58494
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you can.

Regards
Michel
Re: RMAN backup [message #493750 is a reply to message #493743] Wed, 09 February 2011 11:23 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 424
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
smunir362
Messages: 221
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 #493932 is a reply to message #493931] Thu, 10 February 2011 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 58494
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you export 1TB each day?

Regards
Michel
Re: RMAN backup [message #493941 is a reply to message #493932] Thu, 10 February 2011 10:58 Go to previous messageGo to next message
smunir362
Messages: 221
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 #493946 is a reply to message #493941] Thu, 10 February 2011 11:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Incremental exports!.
Have you ever tried it before?
It does not work they way it literally means.
Re: RMAN backup [message #493947 is a reply to message #493946] Thu, 10 February 2011 11:05 Go to previous messageGo to next message
smunir362
Messages: 221
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 #493950 is a reply to message #493947] Thu, 10 February 2011 11:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Flashback?
Again, it depends on how you define "best".
Re: RMAN backup [message #493951 is a reply to message #493947] Thu, 10 February 2011 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 58494
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
IIRC incremental export is no more supported since a couple of versions.

The best is solution is... flashback.
Recycle bin and "flashback to before drop" command against drop table.
Flashback logs and "flashback database" command against delete/truncate.

Regards
Michel
Re: RMAN backup [message #493954 is a reply to message #493951] Thu, 10 February 2011 11:22 Go to previous messageGo to next message
smunir362
Messages: 221
Registered: September 2007
Senior Member
Nice option.
But I think it is available in 10g and on ward versions.
What to use in Oracle 9i.
Re: RMAN backup [message #493956 is a reply to message #493954] Thu, 10 February 2011 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 58494
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN, restore, recover and export/import.
If you use a 10 years old product you have 10 years old features.

Regards
Michel
Re: RMAN backup [message #494015 is a reply to message #493947] Thu, 10 February 2011 20:04 Go to previous messageGo to next message
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 Go to previous messageGo to next message
smunir362
Messages: 221
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 #494431 is a reply to message #494429] Mon, 14 February 2011 11:28 Go to previous messageGo to next message
Michel Cadot
Messages: 58494
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is MAINLY for that but there is NO direct recovery tool.
With an export you lose ALL modifications since the exports and as I said can you export 1TB each day?
Read again my previous posts, there is the solution.

Regards
Michel
Re: RMAN backup [message #494435 is a reply to message #494431] Mon, 14 February 2011 11:37 Go to previous messageGo to next message
smunir362
Messages: 221
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58494
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
smunir362
Messages: 221
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...
Previous Topic: Block Corruption in Expdp
Next Topic: Remove Duplicate DBID In Rman Catalog
Goto Forum:
  


Current Time: Wed Jul 23 03:32:51 CDT 2014

Total time taken to generate the page: 0.13149 seconds