RE: RMAN backup Basic question

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bala Sent: Tuesday, April 17, 2007 1:30 PM
To: Jared Still
Cc: deryaoktay_at_gmail.com; Chandra.Pabba_at_fmr.com; 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_at_gmail.com> 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_at_gmail.com > 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_at_fmr.com > 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_at_freelists.org [mailto: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> ] 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.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 17 2007 - 14:56:53 CDT