- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Do we need to backup RBS and TEMP tablespace.
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 08:14 PM
тАО06-06-2002 08:14 PM
Do we need to backup RBS and TEMP tablespace.
the backup method is
alter tablespace
do host copy of the datafile.
then
alter tablespace
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 08:46 PM
тАО06-06-2002 08:46 PM
Re: Do we need to backup RBS and TEMP tablespace.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 08:53 PM
тАО06-06-2002 08:53 PM
Re: Do we need to backup RBS and TEMP tablespace.
Thanks but this database running in NT.
Does anybody used to face this similar kind of problem.
This same script running fine before.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 09:31 PM
тАО06-06-2002 09:31 PM
Re: Do we need to backup RBS and TEMP tablespace.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2002 11:27 PM
тАО06-06-2002 11:27 PM
Re: Do we need to backup RBS and TEMP tablespace.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2002 12:02 AM
тАО06-07-2002 12:02 AM
Re: Do we need to backup RBS and TEMP tablespace.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2002 12:10 AM
тАО06-07-2002 12:10 AM
Re: Do we need to backup RBS and TEMP tablespace.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2002 12:54 AM
тАО06-07-2002 12:54 AM
Re: Do we need to backup RBS and TEMP tablespace.
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