Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th August 2001, 15:35
pcarlson pcarlson is offline
Newbie
 
Join Date: Aug 2001
Posts: 2
pcarlson is on a distinguished road
Lightbulb Oracle Partitioning

I am wondering if anyone has experimented with Oracle partitioning as a means of archiving data. We are looking into exercising the idea of partitioning tables into a read only tablespace instead of waiting for Baan archiving to be perfected. Any information will be greatly appreciated.
Reply With Quote
  #2  
Old 17th August 2001, 16:48
James James is offline
Retired Founder
 
Join Date: Aug 2001
Location: Bristol, UK
Posts: 158
James is on a distinguished road
Baan: Triton,Baan IV,ERP - DB: Oracle 7/8i/9i - OS: HPUX,Tru64,Linux
Not used Oracle Partitioning.

But what we have done in the past is to create new Archive Tablespaces within Oracle for "old companies".

For example, after the recent Euro Conversions, we preserved the pre-Euro Company data in special read-only tablespaces (Baan Companies).

Is your purpose for archiving to keep a read-only record of certain data? Or is the idea to eliminate old/unwanted data from the Production Companies? What is the root problem? Performance? Backup duration?

Splitting tables across tablespaces does not sound like the best idea. In fact, is this possible?

NB. For info, a useful feature of Oracle 8 (Recovery Manager), is that read-only tablespaces will be recognised as 'unchanged' and hence not backed up as part of the normal database backup. This is useful since backup time durations will decrease. But be aware that an original backup copy of the read-only datafiles must be kept safe for recovery purposes.
__________________
James Gittins
(c) 2002 Baanboard.com
Reply With Quote
  #3  
Old 17th August 2001, 16:54
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
Read Only problems

Hi Pete,

I cannot find give any hints on the partitioning subject as I have not used it before myself. More importantly however is the matter of using read-only tablespaces for archiving data. If you are going to use read-only tablespaces to store data you have to keep in mind that Baan has no notion of the fact that the data is read-only unless it was moved across using the Baan Archiving tools.

We have done a similar exercise in making archive companies (NOT using the Baan Archive tools) for EURO conversion purposes. We did not use partitioning but rather cloned a Baan company into a new, read-only tablespace.

2 major issues:

1) Backup the read-only tablespaces: using RMAN with Oracle 8.0.6 (assuming you are also using RMAN) will not backup those tablespaces except for the very first time. So it's important you saveguard your first backup or alternatively keep a logical export of the same data somewhere handy.

2) When changing the software objects of your Baan installation by installing data dictionary dumps, patches, development work etc, ultimately you might run into the situation that the package combination that is linked to your 'archive' company is changed and requires a data dictionary rebuild. In case this also may require a reorganize tables you are in trouble because Baan will try to update the tables, indexes and reference counters regardless whether they reside in a read-only or read-write tablespace. This will of course result in a fatal error.
The only way to circumvent this problem is to create a VRC layer of which you are sure it will not change and hence not require data dictionary rebuilds.

Bottomline is that you can use read-only tablespace with Baan but with adament care.

Hope the information is useful to you.
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #4  
Old 17th August 2001, 16:58
victor_cleto's Avatar
victor_cleto victor_cleto is offline
Guru
 
Join Date: Aug 2001
Location: Portugal
Posts: 776
victor_cleto is on a distinguished road
Baan: none (B40c4 was last) - DB: Oracle - OS: Linux (RHEL)
Problems and answers

Those "archived" companies bring also other problems if they are not moved into their own package combinations:

As soon you install something that needs a reorganizations of the tables/creation of runtime with reorg, Baan will try to reorganize also those companies that are read-only in Oracle - this must be adressed as well - we just encountered problems with that (right patrick?).

Regarding using tables splitted by several tablespaces, yes, that is possible and several companies do it (keeping tools tables away mostly, or the financial tables). Just create the tablespaces in Oracle and then adapt your $BSE/lib/ora/ora_storage accordingly before creating the tables:

So, if you ever wondered what those '*' reffer to:

*:*:T:... or
*:*:I:...

1st '*' field: table(s) ! - you can use wildcards here
2nd '*' field: company
Reply With Quote
Sponsored Links
  #5  
Old 17th August 2001, 17:23
pcarlson pcarlson is offline
Newbie
 
Join Date: Aug 2001
Posts: 2
pcarlson is on a distinguished road
Smile

Thanks much for the replies and advice. As this is a long term project I will not be experimenting with it for some time. I will keep you posted on our results. The reason we would like to do something like this is to reduce backup/recovery time frame and reduce the size of our development environment (copies of production).
Is anyone using Baan archiving for either BaanIV or Baan ERP? We have both applications and have not been succesful in implementing archiving on either one.
Reply With Quote
  #6  
Old 17th August 2001, 17:30
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
Backup

Hi Pete,

If you want to reduce your backup window and/or volume, you could also consider using incremental backups. RMAN is very powerful with that.

About the archiving I have not much to tell but I suggest you make a new thread just about your arching question in the Tools Admin and Installation forum
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle partitioning moreau Performance & Tuning 12 15th February 2006 17:40
Anyone have any BAAN/Oracle security links petefinnigan Operating Systems & Databases 3 9th September 2003 22:45
Error installing B4c4 with Oracle 8.1.7 on NT syllepage Tools Administration & Installation 2 22nd July 2002 13:52
Baan on Oracle Guru for Hire Will travel OracleBaanGuru Jobs and Resumes 1 19th June 2002 15:57
How to prevent passing of hints generated by Oracle Driver ? baaniac Performance & Tuning 6 24th May 2002 11:16


All times are GMT +2. The time now is 02:42.


©2001-2017 - Baanboard.com - Baanforums.com