RE: RMAN backup Basic question
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <oratips@xxxxxxxxx>, "Jared Still" <jkstill@xxxxxxxxx>
- Date: Tue, 17 Apr 2007 13:56:53 -0600
No, you do not need to FTP any files. The RMAN catalog will find the
files that are of the correct backup set and perform the duplication.
Read up on DB cloning - this sounds like what you are attempting to do.
BTW, you can switch ENDIAN format using DB_FILE_NAME_CONVERT. Not too
sure if you can do it as you are performing the clone. I will be
testing this in the coming weeks.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bala
Sent: Tuesday, April 17, 2007 1:30 PM
To: Jared Still
Cc: deryaoktay@xxxxxxxxx; Chandra.Pabba@xxxxxxx; oracle-l
Subject: Re: RMAN backup Basic question
Thank you very much. To summarise .
1) use RMAN to backup -- use backup command -- RMAN Converts into
proprietary format pointing to a disk location -- and than FTP over
all the files of the backup - to different OS ( Windows, HP, AIX etc )
and use DUPLICATE command to create a database say from PROD to TEST
across platforms !
On 4/17/07, Jared Still <jkstill@xxxxxxxxx> wrote:
If you are referring to the DUPLICATE command, yes it may
duplicate a database to another platform.
From the fine user manual, under the DUPLICATE command
in the RMAN reference manual:
"If you can make an operating system copy of a database file on one
platform
and then restore it to another platform, then it is also possible to
duplicate a
database from one platform to another. Otherwise, duplication is not
possible."
On 4/17/07, Derya Oktay <deryaoktay@xxxxxxxxx > wrote:
Hello,
I heard about the TARGET parameter given in RMAN which enables to
transport backups from one platform to another, which has the same
ENDian. Is not that correct?
Regards,
Derya.
On 4/17/07, Pabba, Chandra <Chandra.Pabba@xxxxxxx > wrote:
If you are referring to ongoing/regular backups/restores from one
platform to another, the answer is NO for both the questions. Just
FYI....this is not a RMAN restriction or limitation but this is because
of the fact that the data files and its format is OS dependent. Of
course, you can use the Transportable Tablespace feature of Oracle10g
for cross platform transfer of datafiles, but may be a good option to
use for one time setup.
Thanks
Chandra Pabba
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> ]
On Behalf Of Bala
Sent: Monday, April 16, 2007 5:01 PM
To: oracle-l
Subject: RMAN backup Basic question
Excuse my ignorance -- Is RMAN Backup Platform/ OS independent ?
would RMAN Backup taken on Solaris work on say HP Unix or AIX ?
would RMAN Backup taken on Windows work on Unix ?
Thank you for clearing up lingering doubts.
--
Bala Rao
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
Bala Rao
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
Other related posts:
