OraFAQ Forum: Backup & Recovery » online tablespace backup issue

Home » RDBMS Server » Backup & Recovery » online tablespace backup issue

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

online tablespace backup issue [message #250017]

Fri, 06 July 2007 23:45

sajut
Messages: 69
Registered: January 2007

Member

Dear all

I have an Oracle 9i R2 database running on Suse Linux. I usually takes weekly online backup of datafiles after putting the respective tablespace in backup mode.
I use tar to backup the datafiles

Today after I put a tablespace in backup mode and tried to backup the datafiles, I got the following msg.

tar: appweb2.dbf: file changed as we read it

Is my backup consistent? Kindly advice
Saju

Report message to a moderator

Re: online tablespace backup issue [message #250022 is a reply to message #250017]

Sat, 07 July 2007 01:17

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can't directly use tar, you have to either:
- stop the database
- first copy the files in another directory then use tar of these copies

Regards
Michel

Report message to a moderator

Re: online tablespace backup issue [message #250026 is a reply to message #250022]

Sat, 07 July 2007 01:58

sajut
Messages: 69
Registered: January 2007

Member

means, I can only take a Cold backup??
Saju

Report message to a moderator

Re: online tablespace backup issue [message #250034 is a reply to message #250026]

Sat, 07 July 2007 03:23

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you want to only use tar, yes.
If you can use cp before, no.

Regards
Michel

Report message to a moderator

Re: online tablespace backup issue [message #250046 is a reply to message #250017]

Sat, 07 July 2007 05:15

sajut
Messages: 69
Registered: January 2007

Member

Thanks Michel for the reply

You mean, I should put the tablespace in backup mode, copy the datafiles to a different location, then tar the files ??. But even while the datafiles are being copied, their timestamp can change. Is that ok?

Regards
Saju Thomas

Report message to a moderator

Re: online tablespace backup issue [message #250052 is a reply to message #250046]

Sat, 07 July 2007 07:35

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, it is ok because Oracle knows that you're copying the file - this is the purpose of putting the begin backup - and cp works without any problem with concurrent reads/writes.
tar does not allow concurrent writes.

In addition, Oracle doesn't care about file timestamps. It uses its own internal timestamp aka SCN.

Regards
Michel

Report message to a moderator

Re: online tablespace backup issue [message #250471 is a reply to message #250052]

Tue, 10 July 2007 03:12

sajut
Messages: 69
Registered: January 2007

Member

Thank you very much Michel, for explaining me in detail

Report message to a moderator

Previous Topic:	Recovery after system crash
Next Topic:	Export issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 03:37:08 CDT 2024