The "Oracle Cloning" is a new feature provided by OpsCenter, which is a free of charge web based monitoring & reporting tool. It comes with NBU7 and allows you to restore RMAN backups to an alternate client with a new instance and/or db name.
I can send you a preso off-list with screenshots showing how it goes.
On Wed, Mar 17, 2010 at 11:29 PM, William Brown <william.d.brown < at > gsk.com ([email]william.d.brown < at > gsk.com[/email])> wrote:
I have a PDF presentation that came from a 'Symantec Vision' entitled " Best Practices for protecting Oracle with NetBackup" - that has a section on 'Redirected Oracle Database Clone Restore', that has a number of steps. I'm not a DBA so I've not tried it. I can send it off-list to anyone who would like to look at it.
William D L Brown
-----Original Message-----
From: veritas-bu-bounces < at > mailman.eng.auburn.edu ([email]veritas-bu-bounces < at > mailman.eng.auburn.edu[/email]) [mailto:veritas-bu-bounces < at > mailman.eng.auburn.edu ([email]veritas-bu-bounces < at > mailman.eng.auburn.edu[/email])] On Behalf Of Adams, Dwayne
Sent: 17 March 2010 15:43
To: DRAKE, MICHAEL (ATTCINW); Carlos Alberto Lima dos Santos; VERITAS-BU < at > mailman.eng.auburn.edu ([email]VERITAS-BU < at > mailman.eng.auburn.edu[/email])
Subject: Re: [Veritas-bu] Res: Restoring RMAN files
Hello,
RMAN can do a DB level restore to an alternate machine. I worked at a company a few years back where we used the process for quarterly DR testing. I have the RMAN book at home.
http://www.amazon.com/Database-Application-Clusters-Handbook-Osborne/dp/007146509X/ref=pd_bxgy_b_img_a (non 10g version) I will take a look at it and see if there are any options for doing a file level restore of the DB files and report back tomorrow.
Dwayne
-----Original Message-----
From: veritas-bu-bounces < at > mailman.eng.auburn.edu ([email]veritas-bu-bounces < at > mailman.eng.auburn.edu[/email]) [mailto:veritas-bu-bounces < at > mailman.eng.auburn.edu ([email]veritas-bu-bounces < at > mailman.eng.auburn.edu[/email])] On Behalf Of DRAKE, MICHAEL (ATTCINW)
Sent: Wednesday, March 17, 2010 8:25 AM
To: Carlos Alberto Lima dos Santos; VERITAS-BU < at > mailman.eng.auburn.edu ([email]VERITAS-BU < at > mailman.eng.auburn.edu[/email])
Subject: Re: [Veritas-bu] Res: Restoring RMAN files
Good point Carlos,
In fact there is no restore option for RMAN in the NBU GUI or CLI. Veritas has purposely set it up that way as did other vendors in collaboration with Oracle. All the NBU RMAN policy really does is act as a master scheduler to launch the RMAN script. The DBA has to log into RMAN and look at its own set of logs to do a restore. Not an RMAN expert, but I do not believe it can do an alternate machine restore like NBU does.
I think what Alan is trying to do is get Oracle to dump out some sort of file that can be backed up as a regular file. So a separate standard policy is created, backs up this regular file, then uses an alternate restore method to point to restore to a different destination machine. If he is talking about the Oracle export method, then that should work.
Mike Drake
Storage Administrator
GNO Operations
EMC Proven Professional
desk 404-303-5008
cell 404-368-8079
-----Original Message-----
From: veritas-bu-bounces < at > mailman.eng.auburn.edu ([email]veritas-bu-bounces < at > mailman.eng.auburn.edu[/email]) [mailto:veritas-bu-bounces < at > mailman.eng.auburn.edu ([email]veritas-bu-bounces < at > mailman.eng.auburn.edu[/email])] On Behalf Of Carlos Alberto Lima dos Santos
Sent: Wednesday, March 17, 2010 7:58 AM
To: VERITAS-BU < at > mailman.eng.auburn.edu ([email]VERITAS-BU < at > mailman.eng.auburn.edu[/email])
Subject: [Veritas-bu] Res: Restoring RMAN files
If backup was done using RMAN the restore should be initialized by RMAN, in the RMAN script the DBA can recover the DB or not. To redirect the restore to another server has a procedure in the NetBackup Oracle administrator's guide.
========================================
Carlos Alberto L. dos Santos (TOCA)
Eng. de Computação - Jundiaí - SP Brasil
http://www.linkedin.com/in/carlostoca
http://netbackupblog.blogspot.com/
carlos_listas < at > yahoo.com.br ([email]carlos_listas < at > yahoo.com.br[/email])
----------------------------------------
----- Mensagem original ----
De: awiggins <netbackup-forum < at > backupcentral.com ([email]netbackup-forum < at > backupcentral.com[/email])>
Para: VERITAS-BU < at > MAILMAN.ENG.AUBURN.EDU ([email]VERITAS-BU < at > MAILMAN.ENG.AUBURN.EDU[/email])
Enviadas: Terça-feira, 16 de Março de 2010 16:59:37
Assunto: [Veritas-bu] Restoring RMAN files
This is for an alternate client restore to a client that I cannot get the nbu ports opened for. I've been told that if I can restore the rman files as plain files, they can then be moved to an appropriate server where the dba's will be able to restore the db from them. Does this sound correct?
Thanks,
Alan
+----------------------------------------------------------------------
|This was sent by awiggins < at > juniper.net ([email]awiggins < at > juniper.net[/email]) via Backup Central.
|Forward SPAM to abuse < at > backupcentral.com ([email]abuse < at > backupcentral.com[/email]).
+----------------------------------------------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu < at > mailman.eng.auburn.edu ([email]Veritas-bu < at > mailman.eng.auburn.edu[/email])
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
_______________________________________________
Veritas-bu maillist - Veritas-bu < at > mailman.eng.auburn.edu ([email]Veritas-bu < at > mailman.eng.auburn.edu[/email])
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu < at > mailman.eng.auburn.edu ([email]Veritas-bu < at > mailman.eng.auburn.edu[/email])
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu < at > mailman.eng.auburn.edu ([email]Veritas-bu < at > mailman.eng.auburn.edu[/email])
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
-----------------------------------------------------------
This e-mail was sent by GlaxoSmithKline Services Unlimited
(registered in England and Wales No. 1047315), which is a
member of the GlaxoSmithKline group of companies. The
registered address of GlaxoSmithKline Services Unlimited
is 980 Great West Road, Brentford, Middlesex TW8 9GS.
-----------------------------------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu < at > mailman.eng.auburn.edu ([email]Veritas-bu < at > mailman.eng.auburn.edu[/email])
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
