Home » RDBMS Server » Backup & Recovery » online tablespace backup issue
online tablespace backup issue [message #250017] Fri, 06 July 2007 23:45 Go to next message
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
Re: online tablespace backup issue [message #250022 is a reply to message #250017] Sat, 07 July 2007 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: online tablespace backup issue [message #250026 is a reply to message #250022] Sat, 07 July 2007 01:58 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
means, I can only take a Cold backup??
Saju
Re: online tablespace backup issue [message #250034 is a reply to message #250026] Sat, 07 July 2007 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: online tablespace backup issue [message #250046 is a reply to message #250017] Sat, 07 July 2007 05:15 Go to previous messageGo to next message
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
Re: online tablespace backup issue [message #250052 is a reply to message #250046] Sat, 07 July 2007 07:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: online tablespace backup issue [message #250471 is a reply to message #250052] Tue, 10 July 2007 03:12 Go to previous message
sajut
Messages: 69
Registered: January 2007
Member
Thank you very much Michel, for explaining me in detail
Previous Topic: Recovery after system crash
Next Topic: Export issue
Goto Forum:
  


Current Time: Sun Dec 04 00:34:56 CST 2016

Total time taken to generate the page: 0.08004 seconds