Database management strategy

[Yashik Vimal]

Hi there ! I am not a total stranger to database management but at
the same time neither am i a database expert by any means. I got a
serious hypothetical question. Assuming i have a Oracle database that
has been Online for a while and it is slowly running out of physical
hard disk space. How will anyone approach this issue strategically ?
Can a single database run on multiple physical Servers ?Appreciate
your answer in simple and understandable words with less technically
jargon
thks in advance

[Noons]

On Feb 6, 3:22 pm, Yashik Vimal <yashikvi...@yahoo.com> wrote:

> serious hypothetical question. Assuming i have a Oracle database that
> has been Online for a while and it is slowly running out of physical
> hard disk space. How will anyone approach this issue strategically ?

There are as many solutions as there is hardware out there.

A few that come to mind and ares relatively simple to implement:

1- Assuming the server hardware can be expanded, then add more disk(s)
and/or move existing data to larger disk(s).

2- Clean up - archive/delete - old data and free up the disk space it
is using for new data. Requires solid and sound SQL and Oracle DBA
knowledge.

3- If this server's use is to be expanded in future, consider using a
small SAN device such as Apple's X-Raid or similar. They are cheap
and easy to integrate with anything already there.

> Can a single database run on multiple physical Servers ?

Yes. But if your knowledge of Oracle doesn't tell you that already, I
strongly suggest you don't go that way unless you are prepared to get
some solid external, specialised consultancy.

> Appreciate
> your answer in simple and understandable words with less technically

I tried my best.

[joel garry]

In addition to Noon's basics, there would be some dependency on what
you currently have: Oracle version, platform, storage, data volume
and application. If it is more than some arbitrary age or version,
long-term (5 years plus) strategic planning would be called for. If
it is much more, sometimes throwing everything out and upgrading
everything to what is currently hot can make sense.

For example: If you are on 9.2 Oracle, you need to upgrade.

jg
--
http://news.softpedia.com/news/HP-Would-Like-to-Make-Peace-with-Oracle-But-Can-t-250731.shtml

[Mark D Powell]

Technically Real Application Cluster (RAC) instances are one Oracle database being accessed by multiple Oracle instances running on different physical servers so the answer to you one question is yes.

When the Oracle database is slowly consuming the available server resources you options would be to add cpu or upgrade cpu (same number, but newer faster cpu's), adding more memory, upgrading the IO cards, adding disks to the disk array, and/or upgrading or replacing the disk array depending on exactly what resources you are consuming.

Migration to RAC and tuning to ensure Oracle is efficiently using the resources it is consuming would also be options.

HTH -- Mark D Powell --

[Mladen Gogala]

On Sun, 05 Feb 2012 20:22:50 -0800, Yashik Vimal wrote:

> Can a single database run on multiple physical Servers ?

Yes.

> Appreciate your
> answer in simple and understandable words with less technically jargon
> thks in advance

You're welcome.



--
http://mgogala.byethost5.com

[Gerard H. Pille]

Mladen Gogala wrote:
> On Sun, 05 Feb 2012 20:22:50 -0800, Yashik Vimal wrote:
>
>> Can a single database run on multiple physical Servers ?
>
> Yes.
>

Your eloquence is unsurpassed.

[Mladen Gogala]

And adequate.



--
http://mgogala.byethost5.com

[onedbguru]

Add an HBA+SAN storage and you can expand until you completely exceed
your I/O bandwidth or the storage frame. This also makes it easier to
expand into a RAC (Real Application Cluster) configuration.

Can a single database run on multiple servers? that depends. RAC -
Yes. Bi-directional Streams - Yes, but I am not a fan of this
configuration. There are others like Active Data Guard (sort-of like
bi-directional streams) but better. The question is, how much $$$
are you willing to spend to get what you need.

[Mladen Gogala]

On Tue, 07 Feb 2012 16:59:27 -0800, onedbguru wrote:

> There are others like Active Data Guard (sort-of like bi-directional
> streams) but better.

Funny thing, I've just finished research of the active DG for the company
that I'm working for. The show stopper is the fact that it isn't possible
to use global temporary tables on active DG. The idea was to replace
streams replicated schema from 10G, but the software utilizing it relies
in some cases on populating a GTT before producing a report. Also, you
can use GTT on a logical standby (10G) but not on active standby. Logical
standby is also supposed to be read-only, but temporary tables can be
used. No such luck with an active DG.



--
http://mgogala.byethost5.com