Re: Database Size
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Fri, 15 Nov 2013 10:07:59 -0700
Message-ID: <528654EF.2090106_at_gmail.com>
On 14/11/2013 4:55 AM, Howard Latham wrote:
>
> A quick question that MAY promote some discussion.
> Whats the easiest/ most accurate way to get a database size with a
> view to copying it to another server (resizing is ok) ? Excluding 3rd
> party tools - well Ok spotlight gives a quick summary so forget that
> condition!
>
While you are looking at the other good answers, when thinking at the OS level - which, admittedly, may not be part of your concern right now - also remember to take into account
Date: Fri, 15 Nov 2013 10:07:59 -0700
Message-ID: <528654EF.2090106_at_gmail.com>
On 14/11/2013 4:55 AM, Howard Latham wrote:
>
> A quick question that MAY promote some discussion.
> Whats the easiest/ most accurate way to get a database size with a
> view to copying it to another server (resizing is ok) ? Excluding 3rd
> party tools - well Ok spotlight gives a quick summary so forget that
> condition!
>
While you are looking at the other good answers, when thinking at the OS level - which, admittedly, may not be part of your concern right now - also remember to take into account
- SAN/NAS mirroring policy and/or ASM redundancy
- mirroring for redo and control files
- space for control file auto backup
- space for logs, traces and alert files - especially the ADR ($ORACLE_BASE/diag) (you'd be surprised how many do not rotate alert and listener log)
- and, of course, the ($ORACLE_HOME) itself.
/Hans
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 15 2013 - 18:07:59 CET