Do we need to backup RBS and TEMP tablespace. (247 Views)
Reply
Esteemed Contributor
Printaporn_1
Posts: 609
Registered: ‎02-06-2001
Message 1 of 8 (247 Views)

Do we need to backup RBS and TEMP tablespace.

Hi,

the backup method is
alter tablespace begin backup .....

do host copy of the datafile.

then
alter tablespace end backup.
do this one by one , tablespace.

question.
1. Do we need to backup Roll back segment tablespace and TEMP tablespace.
2. We encouter database performace in past 2 days , what can be the problem. No relevant error message in alert log.

Thanks
enjoy any little thing in my life
Honored Contributor
Tom Geudens
Posts: 962
Registered: ‎11-23-2001
Message 2 of 8 (247 Views)

Re: Do we need to backup RBS and TEMP tablespace.

Hi,
1. Treat both tablespaces as if they are ordinary tablespaces. Strictly speaking you do not need the TEMP tablespace. However, if you don't take the backup you'll have to drop/recreate the tablespace at recovery time.
We use an script that first makes a list of all tablespaces and then backups them one by one. Oh, btw, do NOT forget to backup your controlfiles as well !

2. You might want to - if you haven't already - set up measureware groups to monitor the DBapplications in glance. It's very difficult to pinpoint what is wrong exactly if you don't know what is the "normal" view of your environment. Maybe the following document can help : http://h21007.www2.hp.com/dspp/files/unprotected/devresource/Docs/TechPapers/UXPerfCookBook.pdf

Regards,
Tom
A life ? Cool ! Where can I download one of those from ?
Esteemed Contributor
Printaporn_1
Posts: 609
Registered: ‎02-06-2001
Message 3 of 8 (247 Views)

Re: Do we need to backup RBS and TEMP tablespace.

Hi Tom,

Thanks but this database running in NT.

Does anybody used to face this similar kind of problem.
This same script running fine before.
enjoy any little thing in my life
Honored Contributor
Alexander M. Ermes
Posts: 2,122
Registered: ‎06-15-1997
Message 4 of 8 (247 Views)

Re: Do we need to backup RBS and TEMP tablespace.

Hi there.
Yes, you need to backup ALL tablespaces ( the files, which belong to the tablespaces ).
The problem will occur, if you try to restore the database and the timestamps in the controlfile are not consistent. That is, why we try to do cold backups whenever possible.
If you do hot backups, you really need these tablespaces, because they can contain changed blocks, that might be needed for rollbacks or commits. These things are extremely important, if you want to do a recover until time.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Honored Contributor
Andreas D. Skjervold
Posts: 490
Registered: ‎03-14-2000
Message 5 of 8 (247 Views)

Re: Do we need to backup RBS and TEMP tablespace.

Hi

The performance issue could be a result of almost anything so you have to get inplace som monitoring of your server and try to pinpoint the bottleneck.

Try "Spotlight on Oracle" from Quest. Its a neat tool which displays the database and all processes as well as SGA and data transfer.

Check if you have exhausted our physical RAM and have began swapping, and check if some disks are taking the lot of the work.
Futher check the Oracle cache hits and Liberey chache hits. If these are low then you might have to enlarge your SGA (if you have memory for it).

Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Esteemed Contributor
Justo Exposito
Posts: 695
Registered: ‎10-14-2001
Message 6 of 8 (247 Views)

Re: Do we need to backup RBS and TEMP tablespace.

Hi Printaporn,

The recomendation from our Oracle DBA is to take a backup of all of the tablespace defined, included the RBS, system and TEMP.

We do it all the nights as a hot backup and one day in a week as a cold backup, in order to use a hot backup you need the archivelogs also and a copy of the controlfile. We do it with OBII and we use the pre-exec and post-exec in order to shutdown/startup the instances and to put the tablespace in backup mode.

About performance, the spootlight software is a good tool in order to investigate the problems, probably you can obtain a trial license.
There are so many posibilities of problems like:
You are using Dynamic SQL in your data loading proceses.
You can have a lot of fragmentation in your tablespace.
You can have the most offten used tables and index in the same fisical disks.
You can not have enought SGA defined.
etc...

Hope this helps,

Justo.
Help is a Beatiful word
Esteemed Contributor
Justo Exposito
Posts: 695
Registered: ‎10-14-2001
Message 7 of 8 (247 Views)

Re: Do we need to backup RBS and TEMP tablespace.

Hi Again,

This is the www page where you can download the Trial Spootlight for oracle from Quest Software Company:

http://www.quest.com/requests/?RequestDefID=182

When you download and installed the Spootlight you must setup your Oracle the Oracle variable TIMED_STATISTICS=true.

Regards,

Justo.
Help is a Beatiful word
Honored Contributor
Volker Borowski
Posts: 1,521
Registered: ‎04-20-1998
Message 8 of 8 (247 Views)

Re: Do we need to backup RBS and TEMP tablespace.

Hello,

yes, and after my special recovery thread described here,
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xbae85a3e6e0bd6118ff40090279cd0f9,00.html

I have to say, that it is even worth to schedule additional backups of SYSTEM and Rollbacktablespaces.

1) If you can only restore without index data, you can recreate it
2) If you can only restore with loss of some table data, you might loose data partially, but will be able to get at least a certain percentage
3) ... but without SYSTEM or a datafile containing an ACTIVE rollback segment, you will not be able to open the database at all, or might have the risk to need to go for data corruption!

Hope this helps
Volker
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.