| Rman backup restore [message #620708] |
Tue, 05 August 2014 09:41  |
 |
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 #620713 is a reply to message #620711] |
Tue, 05 August 2014 10:03  |
|
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 #620721 is a reply to message #620719] |
Tue, 05 August 2014 10:29 |
|
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 #620776 is a reply to message #620743] |
Wed, 06 August 2014 00:56 |
|
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 #621027 is a reply to message #620776] |
Thu, 07 August 2014 14:23 |
tim2boles
Messages: 38
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 #621295 is a reply to message #621027] |
Tue, 12 August 2014 07:53 |
tim2boles
Messages: 38
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 |
|
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
