FW: movement of database

From: Abhijit Saswadkar <Abhijit.Saswadkar_at_originindia.com>
Date: Tue, 31 Oct 2000 17:58:36 +0530
Message-Id: <10666.120656@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04336.1765D280
Content-Type: text/plain

ANY INFO AVAILABLE
> -----Original Message-----
> From: Rameshbabu Vaithyam [SMTP:vkrameshbabu_at_yahoo.com]
> Sent: Tuesday, October 31, 2000 5:44 PM
> Subject: movement of database
>
> Hi
>
> Fine. We r planning to move r prod DB (ORacle 73450)
> on Sun Solaris 2.6
> to
> separate storage disk called EMC. The advantage of EMC
> is, it can cater
> to
> any amount of disk storage as DB needs.
>
> Unfortunately, the DB has data, index, system, rbs,
> temp, snapshots all
> the
> tablespaces together on a single mount stage. (For eg
> /data6/oradata/VANPROD/..)PErhaps since it is going to
> moved, can u
> please
> tell me the best ways to do it ..i.e. I would like to
> keep separate
> disk
> for all the tablespaces(resources abundantly
> available) ..
>
> Under this context, what r the methods available to
> check up for the
> successful movement of DB..also since it is prod.
> environment, I would
> like
> to take all precautions togther..Of course, We shall
> get a downtime of
> 5hrs.. Database size is close to 95gigs..Contains 53
> datafiles, 3
> controlfiles..33 rollback segments. also tell me the
> website where I
> can
> seek more info, pl.
>
> Pl send me ur advise ASAP. Also I hv sent a TAR to
> ORacle.. and
> yet to reply..
>
> if U NEED FUTHER infos pl.let me know..
>
> Regds
>
> Ramesh
>

------_=_NextPart_001_01C04336.1765D280
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>FW: movement of database</TITLE>
</HEAD>
<BODY>

ANY INFO = AVAILABLE
 -----Original Message----- From:   Rameshbabu Vaithyam = [SMTP:vkrameshbabu_at_yahoo.com]
 Sent:   Tuesday, October 31, 2000 5:44 PM Subject:       = movement of database

Hi

Fine. We r planning to move r prod DB = (ORacle 73450)

<BR><FONT SIZE=3D2 FACE=3D"Arial">on Sun Solaris 2.6 </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">to </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">separate storage disk called EMC. The =

advantage of EMC

<BR><FONT SIZE=3D2 FACE=3D"Arial">is, it can cater </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">to </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">any amount of disk storage as DB =

needs.

Unfortunately, the DB has data, index, = system, rbs,

<BR><FONT SIZE=3D2 FACE=3D"Arial">temp, snapshots all </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">the </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">tablespaces together on a single =

mount stage. (For eg
 /data6/oradata/VANPROD/..)PErhaps = since it is going to

<BR><FONT SIZE=3D2 FACE=3D"Arial">moved, can u </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">please </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">tell me the best ways to do it =

..i.e.  I would like to

<BR><FONT SIZE=3D2 FACE=3D"Arial">keep separate </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">disk </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">for all the tablespaces(resources =

abundantly
 available) ..

Under this context, what r the methods = available to
 check up for the successful movement of DB..also since = it is prod.

<BR><FONT SIZE=3D2 FACE=3D"Arial">environment, I would </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">like </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">to take all precautions togther..Of =

course, We shall
 get a downtime of 5hrs.. Database size is close to = 95gigs..Contains 53
 datafiles, 3 controlfiles..33 rollback segments. = also tell me the

<BR><FONT SIZE=3D2 FACE=3D"Arial">website where I </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">can </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">seek more info, pl.</FONT>
</P>

Pl send me ur advise ASAP. Also I hv = sent a TAR to

<BR><FONT SIZE=3D2 FACE=3D"Arial">ORacle.. and </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">yet to reply..</FONT>
</P>

if U NEED FUTHER infos pl.let me = know..

Regds Received on Tue Oct 31 2000 - 06:28:36 CST