Do you mean we could backup/restore to other platform using RMAN?
Best Regards,
Achmad Dimyati
-----Original Message-----
From: Hornung Bruce W (US SSA)
[mailto:oracledba-ezmlmshield-x27773531.[Email address protected]
Sent: Saturday, September 29, 2007 6:56 PM
To: LazyDBA Discussion
Subject: RE: 500 GIG database refresh?
use transportable tablespaces feature and rman to change endian
________________________________
From: Michael Peel [mailto:oracledba-ezmlmshield-x46523255.[Email
address protected]
Sent: Sat 9/29/2007 4:45 AM
To: LazyDBA Discussion
Subject: RE: 500 GIG database refresh?
You could export all your objects, code etc but not the rows and then
insert
using selects.
An alternative would be sql copy.
M
-----Original Message-----
From: will landstrom
[mailto:oracledba-ezmlmshield-x59213598.[Email address protected]
Sent: 28 September 2007 21:49
To: LazyDBA Discussion
Subject: 500 GIG database refresh?
Hello DBAS. I need to take a 500 GIG 10.2.2 database from server A and
copy
it to server B. 2 ways I am considering (neither are very good)
A) just take a bib export file and import the whole thing (will take a
long
long time to run)
B) use a hotback of the database and recover (very quick but not
plausible
because server B has a file system (AIX) not compatible with server A
(Solaris).
By any chance does anyone have any other suggestions how to do this
efficiently?
Thanks, Will
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ
AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The content of this email is confidential and for the
addressee only. If you are not the addressee of this
email (or responsible for the delivery of this message
to such person) you may not copy, forward, disclose
or otherwise use it or any part of it in any form
whatsoever. If you have received this email in error
please email the sender by replying to this message
and delete this message thereafter.
Opinions, conclusions and other information in this
message that do not relate to the official business
of our Company shall be understood as neither
given nor endorsed by it.
Axon Solutions Limited
Registered Office: Axon Centre, Church Road, Egham, Surrey, TW20 9QB, UK
Registered in England & Wales under Company No. 2976395
Axon Solutions Limited is a limited company.
Axon Group plc
Registered Office: Axon Centre, Church Road, Egham, Surrey, TW20 9QB, UK
Registered in England & Wales under Company No. 3419641
Oracle LazyDBA home page