Re: Cloning a database to same server using Rman. Possible?
Date: Fri, 21 Aug 2009 14:50:53 -0700 (PDT)
Message-ID: <000af9b6-f72d-4b70-b366-12027e2eaaca_at_c14g2000yqm.googlegroups.com>
On Aug 21, 4:05 pm, "steven_nospam at Yahoo! Canada" <steven_nos..._at_yahoo.ca> wrote:
> I already know that I could use the RMAN instead of my hot backup
> routines, and I believe implementing the "BACKUP DATABASE" routines
> using NOCATALOG mode would be perfect for our company needs.
>
> But my question is whether I could use RMAN to accomplish this clone
> method of backup. In the documents I have read, it indicates that you
> can use RMAN in 10g to "restore the database to a new host", but I was
> not able to figure out if I could restore a database to the same host
> but use a different ORACLE_SID.
>
> Has anyone done this and has some example steps? Or perhaps can
> recommend a reference to use? I have tried looking on
> tahiti.oracle.com for something similar to what I want to do but could
> not find it. It all suggests the same database on a different host.
>
> Thx in Advance
>
> Steve N.
Yes, what you are trying to achieve may be done. I suggest that you take a look at the book "RMAN Recipes for Oracle Database 11g A Problem-Solution Approach" which applies to Oracle 10g also. http://www.amazon.com/RMAN-Recipes-Oracle-Database-Problem-Solution/dp/1590598512
I posted a rather lengthy review for the above book on Amazon's site - I commented on the clone to a single host recipe in the review. The book is listed in Google's book library, although there are pages missing.
The other current RMAN book "Oracle Database 10g RMAN Backup and Recovery" makes the cloning process more difficult to follow than the Oracle documentation - that is just my personal opinion though.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Received on Fri Aug 21 2009 - 16:50:53 CDT