Home » RDBMS Server » Backup & Recovery » RMAN - Time Interval Backup and Restore (Oracle 11gR2, Red Hat Enterprise Linux)
RMAN - Time Interval Backup and Restore [message #549053] Tue, 27 March 2012 14:48 Go to next message
syedshehzaad
Messages: 8
Registered: March 2012
Junior Member
Hi To all,

I came up with a query with rman and the query goes like

Scenario:

I have been updating data in my database by adding numerous rows and assume the insertion of rows started from 1st date of january month.

I have been entering somehow or the other part of data every day.And now the date is 25th of january.

Now i Wanted to know

How can i take a partial backup of my database of the transactions done between 15th of January to 20th of January Month

How to take Backup of a particular date say it be 12th of january month.

How to take backup of first 10 days i.e., 1st-10th of january.
Re: RMAN - Time Interval Backup and Restore [message #549055 is a reply to message #549053] Tue, 27 March 2012 14:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

If no COMMIT has been issued, then no other session can see the uncommitted DML changes.
When was last COMMIT issued?
Re: RMAN - Time Interval Backup and Restore [message #549056 is a reply to message #549055] Tue, 27 March 2012 14:54 Go to previous messageGo to next message
syedshehzaad
Messages: 8
Registered: March 2012
Junior Member
At the End of Every day the Transaction is being Committed !!!
Re: RMAN - Time Interval Backup and Restore [message #549057 is a reply to message #549056] Tue, 27 March 2012 14:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>At the End of Every day the Transaction is being Committed !!!
YEA!

expdp can be used to capture the contents of the table.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: RMAN - Time Interval Backup and Restore [message #549058 is a reply to message #549057] Tue, 27 March 2012 15:03 Go to previous messageGo to next message
syedshehzaad
Messages: 8
Registered: March 2012
Junior Member
i wanted to use the rman utility

i have a backup of entire 25 days as a full backup and even the database is working

i just wanted to know how can i backup data from specific date to other date and restore it

and

can i restore a part of backup from full backup

I wanted to use RMAN utility only .
Re: RMAN - Time Interval Backup and Restore [message #549073 is a reply to message #549058] Wed, 28 March 2012 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ RMAN is a PHYSICAL backup not a transational backup.

2/
Quote:
can i restore a part of backup from full backup


Yes.

Regards
Michel

Re: RMAN - Time Interval Backup and Restore [message #549234 is a reply to message #549073] Thu, 29 March 2012 01:15 Go to previous messageGo to next message
syedshehzaad
Messages: 8
Registered: March 2012
Junior Member
Michel:

Can u help me with the process of partial recovery from full backup

and also please help me in

How to take Backup of a particular date say it be 12th of january month.

How to take backup of first 10 days i.e., 1st-10th of january.
how to take partial backup as mentioned above

backup from
Re: RMAN - Time Interval Backup and Restore [message #549235 is a reply to message #549234] Thu, 29 March 2012 01:23 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can u help me with the process of partial recovery from full backup

If partial means some tablespace, then use "SKIP TABLESPACE" option.

Quote:
How to take backup of first 10 days i.e., 1st-10th of january.


This is meaningless.
Explain in details what does this mean.


Regards
Michel
Previous Topic: Incremental backup
Next Topic: tablespace resize
Goto Forum:
  


Current Time: Fri Mar 29 01:24:21 CDT 2024