RE: coping oracle to another server

  • From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
  • To: <Paula_Stankus@xxxxxxxxxxxxxxx>, <paul.baumgartel@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Apr 2005 09:05:00 -0500

Thank you all.
Someone startup oracle while tar was running.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Tuesday, April 12, 2005 3:29 PM
To: paul.baumgartel@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: coping oracle to another server


1-Shutdown entire database
2-Copy all files including the control files - don't need to create from
a script
3-Startup mount
4-alter database open resetlogs=20


The above steps should work - I have done same in the past.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[ mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Paul Baumgartel
Sent: Tuesday, April 12, 2005 4:24 PM
To: Oracle-L@Freelists. Org (E-mail)
Subject: Re: coping oracle to another server

IIRC, you will have to startup mount the new database and recover it
before you can open it.  The backup and recovery experts on the list
will correct me if I=3DE8m wrong.

On Apr 12, 2005 4:07 PM, Roger Xu <roger_xu@xxxxxxxxxxx> wrote:
> Oracle 9.2.0.4.0 on Solaris 8 (SUNW,Sun-Fire-V890) =3D20 =3D20 =20
>-----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
> Sent: Tuesday, April 12, 2005 2:59 PM
> To: Oracle-L@Freelists. Org (E-mail)
> Subject: coping oracle to another server =3D20  Hello List, =3D20  =
This is

>what I did:
> * alter database backup controlfile to trace
> * shutdown oracle on ServerA and tar everything under /oracle to a=20
>tape
> * on ServerB, untar the tape to /oracle
> * startup nomount and recreate controlfile =3D20  Here is the error:
>=3D20
> SQL> @/scripts/control.sql
>=3D20
> Control file created.
>=3D20
> SQL> alter database open resetlogs;
> alter database open resetlogs
> *
> ERROR at line 1:
> ORA-01152: file 1 was not restored from a sufficiently old backup
> ORA-01110: data file 1: '/oracle/DV1/sapdata1/system_1/system.data1'
>=3D20
> Did I do anything wrong? What could be the fix?
>=3D20
> Thanks,
>=3D20
> Roger
> This e-mail is intended solely for the person or entity to which it is

>ad=3D
dressed and may contain confidential and/or privileged information. Any
rev=3D iew, dissemination, copying, printing or other use of this e-mail
by person=3D s or entities other than the addressee is prohibited. If =
you
have received =3D this e-mail in error, please contact the sender
immediately and delete the =3D material.
> ____________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs Email=20
> Secu=3D
rity System. Any questions please call 972-721-8257 or email your
request t=3D o tech_support@xxxxxxxxxxxx
> --
> //www.freelists.org/webpage/oracle-l
>=3D20
> For technical support please email tech_support@xxxxxxxxxxx or you can

>call (972)721-8257.
> This email has been scanned for all viruses by the MessageLabs Email=20
>Secu=3D
rity System.
>=3D20
> This e-mail is intended solely for the person or entity to which it is

>ad=3D
dressed and may contain confidential and/or privileged information. Any
rev=3D iew, dissemination, copying, printing or other use of this e-mail
by person=3D s or entities other than the addressee is prohibited. If =
you
have received =3D this e-mail in error, please contact the sender
immediately and delete the =3D material.
> ____________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs Email=20
> Secu=3D
rity System. Any questions please call 972-721-8257 or email your
request t=3D o tech_support@xxxxxxxxxxxx
> --
> //www.freelists.org/webpage/oracle-l
>=3D20


--=3D20
Paul Baumgartel
paul.baumgartel@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 29431359) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds 
<https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D29431359&m=3Ddd28=> 
&i=3D29431359&m=3Ddd28=
2bdc6
e83
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn 
<https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D29431359&m=3Ddd28=> 
&i=3D29431359&m=3Ddd28=
2bdc6
e83
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df 
<https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D29431359&m=3Ddd28=> 
&i=3D29431359&m=3Ddd28=
2bdc6
e83
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

--
//www.freelists.org/webpage/oracle-l

For technical support please email tech_support@xxxxxxxxxxx or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security 
System.



This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. Any 
review, dissemination, copying, printing or other use of this e-mail by persons 
or entities other than the addressee is prohibited. If you have received this 
e-mail in error, please contact the sender immediately and delete the material. 
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security 
System. Any questions please call 972-721-8257 or email your request to 
tech_support@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l

Other related posts: