OraFAQ Forum: Backup & Recovery » RMAN - Time Interval Backup and Restore

Home » RDBMS Server » Backup & Recovery » RMAN - Time Interval Backup and Restore (Oracle 11gR2, Red Hat Enterprise Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN - Time Interval Backup and Restore [message #549053]

Tue, 27 March 2012 14:48

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.

Report message to a moderator

Re: RMAN - Time Interval Backup and Restore [message #549055 is a reply to message #549053]

Tue, 27 March 2012 14:52

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?

Report message to a moderator

Re: RMAN - Time Interval Backup and Restore [message #549056 is a reply to message #549055]

Tue, 27 March 2012 14:54

syedshehzaad
Messages: 8
Registered: March 2012

Junior Member

At the End of Every day the Transaction is being Committed !!!

Report message to a moderator

Re: RMAN - Time Interval Backup and Restore [message #549057 is a reply to message #549056]

Tue, 27 March 2012 14:57

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/

Report message to a moderator

Re: RMAN - Time Interval Backup and Restore [message #549058 is a reply to message #549057]

Tue, 27 March 2012 15:03

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 .

Report message to a moderator

Re: RMAN - Time Interval Backup and Restore [message #549073 is a reply to message #549058]

Wed, 28 March 2012 01:10

Michel Cadot
Messages: 68421
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

Report message to a moderator

Re: RMAN - Time Interval Backup and Restore [message #549234 is a reply to message #549073]

Thu, 29 March 2012 01:15

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

Report message to a moderator

Re: RMAN - Time Interval Backup and Restore [message #549235 is a reply to message #549234]

Thu, 29 March 2012 01:23

Michel Cadot
Messages: 68421
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

Report message to a moderator

Previous Topic:	Incremental backup
Next Topic:	tablespace resize

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 30 15:06:41 CDT 2023