Re: one question on backup and restore

Hi!

You can do what you wanted without *any* clustering storage. An Oracle database can copied over and opened on another server, providing that the server has same architecture (e.g. 32bit i386) and the Oracle version used is supported on the operating system you run. For example, it is possible to transport a 8.1.7.0.0 database from PentiumIII running WinNT 4.0 to 8.1.7.0.0 running on Pentium4 Xeon running Win2000. Or from Sparc2 SunOS 2.6 to Sparc3 Solaris8.

What you have to worry about is, how to you get your clients to connect to server B after A is down? You can either transfer the IP address (manually or using cluster software) or create your tnsnames.ora files such that clients connect to server B if they can't access server A.

Also, it might be problematic to copy your database over if server A has hopelessly crashed. If you want more failure-proof system, look for standby databases (data guard in 9i)

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, September 02, 2003 6:39 AM

> Hi Zhu Chao,
>
> Yes, I think Jin is using shared external storage, otherwise if his server
A down how he going to copy all his files from
> server A to server B.
> if this is the case what Jin may do is propose an clustering software.
>
> Otherwise, he must backup his database into media.
>
> Sinardy
>
> -----Original Message-----
> Sent: 29 August 2003 11:09
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
> It can be done via cluster software like VCS (Veritas Cluster Server)
or
> Sun Cluster. But one mandetory requrement: you must place your oracle
> database(control,redo,data etc) on the shared storage, that is , server A
> and Server B can access the same disk array.
> If you really do not have shared storage, consider using oracle data
> guard.
>
> Regards
> zhu chao
> msn:chao_ping_at_163.com
> www.cnoug.org
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, August 29, 2003 6:34 AM
>
>
> > Hi Greetings,
> >
> > I have such a plan but not sure if it is feasible. Please help!
> > I install oracle server on two different machine (say A and B). In
> > general, we run on one instance on server A. If we met any problem
> > on server A, we copy all data files, control files and redo files
> > plus spfile<SID>.ora to server B. Can server B startup that
> > instance?
> >
> > Is there any restriction on this plan? or it is totally
> > impossible? Would you please advise why?
> >
> > Thanks alot!
> > Jin
> > btw, they both are Solaris.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: CHEN,JIN
> > INET: jinchen_at_ufl.edu
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: zhu chao
> INET: chao_ping_at_vip.163.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sinardy Xing
> INET: SinardyXing_at_bkgcomsvc.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).