Home » RDBMS Server » Backup & Recovery » Rman backup restore (Oracle 11.2.0.2.0, SunOS 5.10)
Rman backup restore [message #620708] Tue, 05 August 2014 09:41 Go to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Hi,

There was a RMAN backup taken every week and my requirement is to restore last month backup to target database ( only for one schema)?

Thanks

Re: Rman backup restore [message #620711 is a reply to message #620708] Tue, 05 August 2014 09:48 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
Welcome to this forum.

RMAN restores the whole database.
Re: Rman backup restore [message #620712 is a reply to message #620708] Tue, 05 August 2014 10:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Hello Balaji/Ajit/Jack/Mohan/Mathew/Suhas/Srini/william/Srikanth, here you are with a new account.
So now you are "david". Twisted Evil

Re: Rman backup restore [message #620713 is a reply to message #620711] Tue, 05 August 2014 10:03 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Thank you Blackswan.

Let me explain you in detail.Backup team takes Rman full backup every week and from Rman full backup
i want to restore backup taken on 28th July from RMAN full backup and apply it for only one schema to database.

Both full Backup and schema ( to restore) exist in same server.

Can you guide me how to do that ?

Thanks

[Updated on: Tue, 05 August 2014 10:04]

Report message to a moderator

Re: Rman backup restore [message #620714 is a reply to message #620713] Tue, 05 August 2014 10:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
i want to restore backup taken on 28th July from RMAN full backup and apply it for only one schema to database.


You can't.

Re: Rman backup restore [message #620715 is a reply to message #620713] Tue, 05 August 2014 10:07 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
ok you caught me . i aceept it Razz

Can you answer to my question ?

Re: Rman backup restore [message #620716 is a reply to message #620715] Tue, 05 August 2014 10:08 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Can you answer to my question ?


I already did.

So you are still a liar and a fraud and you will blame me for this.

Re: Rman backup restore [message #620717 is a reply to message #620715] Tue, 05 August 2014 10:08 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Quote:
You can't.

Are you sure Michel?

[Updated on: Tue, 05 August 2014 10:09]

Report message to a moderator

Re: Rman backup restore [message #620718 is a reply to message #620713] Tue, 05 August 2014 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
with a full RMAN backup, you can only do a full database restore; regardless of what you may want to do.
Re: Rman backup restore [message #620719 is a reply to message #620718] Tue, 05 August 2014 10:11 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
>Are you sure Michel?

post steps to prove Michel wrong.
Re: Rman backup restore [message #620721 is a reply to message #620719] Tue, 05 August 2014 10:29 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Blackswan,
Quote:
regardless of what you may want to do

I want to use backup taken on 28th July and restore it in a schema.

Note:--
Its a Rman full database backup taken every week only and archive backup will run once in 12 hrs.

Quote:
post steps to prove Michel wrong.

I am not saying Michel is wrong.I am just double checking whether his answer is final one.

Regards,

[Updated on: Tue, 05 August 2014 10:30]

Report message to a moderator

Re: Rman backup restore [message #620729 is a reply to message #620721] Tue, 05 August 2014 11:11 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes it is my final one.

Re: Rman backup restore [message #620738 is a reply to message #620729] Tue, 05 August 2014 11:41 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Quote:
So you are still a liar and a fraud and you will blame me for this.

No i wont.You are a very very ..... i am afraid to tell you about Crying or Very Sad

Michel,
You can fill whatever you want in the blank


Re: Rman backup restore [message #620742 is a reply to message #620738] Tue, 05 August 2014 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
No i wont.


You already did.

Re: Rman backup restore [message #620743 is a reply to message #620738] Tue, 05 August 2014 11:52 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
You can fill whatever you want in the blank


I know, I know: "smart".

Re: Rman backup restore [message #620776 is a reply to message #620743] Wed, 06 August 2014 00:56 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Michel and all,

Actually there is a way to accomplish this task using RMAN backup.

Here are the steps
----------------------

1.Take a full export backup of database ORCL ( where one schema has to restore )

2.shutdown database

3.startup mount

4.connt to RMAN

5. RMAN> run
{
allocate channel dev1 type disk;
set until time "to_date('2011-12-30:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore database;
recover database; }

RMAN> alter database open resetlogs;

I have not executed the above steps.Just gathered the steps and wanted to verify with you all.

Regards,

[Updated on: Wed, 06 August 2014 00:58]

Report message to a moderator

Re: Rman backup restore [message #620779 is a reply to message #620776] Wed, 06 August 2014 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Here are the steps


They are wrong for "my requirement is to restore last month backup to target database ( only for one schema)?".


Re: Rman backup restore [message #620788 is a reply to message #620779] Wed, 06 August 2014 03:28 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Michel,

Are you saying the steps i have provided is wrong ? How do you say that ?

Regards,


Re: Rman backup restore [message #620789 is a reply to message #620788] Wed, 06 August 2014 03:31 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I think there is no doubt about what I posted.

Re: Rman backup restore [message #620790 is a reply to message #620789] Wed, 06 August 2014 03:42 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Michel,

Please tell me why it is wrong and can't done.I need to know the reason so that i can take it forward .

Regards,

Re: Rman backup restore [message #620820 is a reply to message #620790] Wed, 06 August 2014 07:39 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Michel,

Quote:
I think there is no doubt about what I posted.

Can you answer this ?

Regards,
Re: Rman backup restore [message #620824 is a reply to message #620820] Wed, 06 August 2014 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

"This" is not a question but an assertion, so there is no answer.

Re: Rman backup restore [message #620859 is a reply to message #620824] Wed, 06 August 2014 12:13 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Quote:
This" is not a question but an assertion, so there is no answer.

Prove it if you can. if you refuse to do so then it means you are BIG liar .
Re: Rman backup restore [message #620862 is a reply to message #620859] Wed, 06 August 2014 12:27 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
consider to act as a professional here instead of a 4 year old child.
Re: Rman backup restore [message #620865 is a reply to message #620862] Wed, 06 August 2014 12:31 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

+1

Re: Rman backup restore [message #621025 is a reply to message #620865] Thu, 07 August 2014 14:21 Go to previous messageGo to next message
Flyby
Messages: 144
Registered: March 2011
Location: Belgium
Senior Member
with a bit of luck the schema has a seperate tablespace
Re: Rman backup restore [message #621027 is a reply to message #620776] Thu, 07 August 2014 14:23 Go to previous messageGo to next message
tim2boles
Messages: 34
Registered: August 2008
Location: Clarksburg, WV
Member
The ability and procedure to recover a table is going to depend on your situation, the table, and the database architecture.

The simplest recovery is the following (only available in 12c):

http://docs.oracle.com/database/121/BRADV/rcmresind.htm

However...having said that the process that is used basically can be used in the lower editions as well.

1. Determine which backup has the table that needs to be recovered based on your point in time.
2. Create an auxiliary database and recover until the specified point in time.
3. Export the table using datapump from the auxiliary database
4. Truncate the table in the target instance
5. Import the table into the target instance

Having outlined that we are assumming that there are no triggers to handle. No foreign key constraints or any other architecturial hooks into other tables.

Does this answer your question in an appropriate way?

Re: Rman backup restore [message #621030 is a reply to message #621027] Thu, 07 August 2014 14:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It surely answers in a way he can't understand.

Re: Rman backup restore [message #621294 is a reply to message #621027] Tue, 12 August 2014 07:53 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Hi Tim,

I would like to Thank you for answering my question and providing the steps in professional way.

When requested ask me to restore a single table using Rman backup i replied him stating that this is not possible to restore at schema level as Rman restores only entire backup.And if we try to restore the database at specific time then there might chance of data loss.

The only option is to create a new duplicate database and restore the Rman backup at specified time into duplicate database. Then take the export from duplicate database and import that one into our target database.

However there is a need to create an auxiliary database and space is required to hold database files.

After going through this,requester has put this request on hold and asked us not to proceed for now since they need business approval to create auxiliary database and for space.

Sorry for my delay in my reply as i did not logged into orafaq for few days.

Regards,
Re: Rman backup restore [message #621295 is a reply to message #621027] Tue, 12 August 2014 07:53 Go to previous messageGo to next message
tim2boles
Messages: 34
Registered: August 2008
Location: Clarksburg, WV
Member
Yes that is the major issue.

In our shop we do exports of "important" tables, objects, or even entire databases nightly. Those exports are then backed up to tape and sent off site with a retention period of about 1 month. This has helped us now and then in situations that are similar to yours.

In your case, what is disappointing is that they did not realize a need to revert back for almost a month.

Regards
Tim

[Updated on: Tue, 12 August 2014 07:59]

Report message to a moderator

Re: Rman backup restore [message #621298 is a reply to message #621295] Tue, 12 August 2014 07:58 Go to previous message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Quote:
did not see answer earlier..

Yes i understand .It was my mistake that i did not reply on time.
Thats why i asked you sorry
Quote:
Sorry for my delay in my reply as i did not logged into orafaq for few days.
Previous Topic: Flashback Table gives snapshot too old
Next Topic: Number of Archive Logs to retain
Goto Forum:
  


Current Time: Sun Sep 21 07:25:50 CDT 2014

Total time taken to generate the page: 0.04613 seconds