OraFAQ Forum: Backup & Recovery » Take back-up daily on the tables that are changing

Home » RDBMS Server » Backup & Recovery » Take back-up daily on the tables that are changing

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

Take back-up daily on the tables that are changing [message #185882]

Fri, 04 August 2006 00:55

aditya_gangadharam
Messages: 43
Registered: February 2005
Location: Hyderabad

Member

hi all,

I want to take the backup of my oracle database daily at 18.00 Hrs. where i want to store the same backup data in some other system for this i want take the backup such a way that the tables that are modified should be taken as the backup and this backup data are to be stored in second system

for example:

in system 1 i have three tables t1,t2,t3,t4
on t1 i will insert the data
on t2 i will update the data
and on t3 i will insert,update and delete
there is no change in t4.

i have to take the backup from t1.

i will keep the back-up file in the system 2 and the data should be stored in t1,t2,t3 only t4 should not be changed.

thanks in regards.

aditya.

Report message to a moderator

Re: Take back-up daily on the tables that are changing [message #186146 is a reply to message #185882]

Sun, 06 August 2006 07:43

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Switch logs then try sifting through the archive logs for the unchanged data. Log miner documentation will apply depending on your version.

If t4 should not be changed then don't backup it up. Take a backup when t4 is not changed and use that each time you restore.

Report message to a moderator

Previous Topic:	Help on a recovery scenario
Next Topic:	RMAN Writing to Tape

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 10 01:19:14 CDT 2025