Veritas-bu

Re: [Veritas-bu] Res: Restoring RMAN files

2010-03-17 18:04:21
Subject: Re: [Veritas-bu] Res: Restoring RMAN files
From: "William Brown" <william.d.brown AT gsk DOT com>
To: "VERITAS-BU AT mailman.eng.auburn DOT edu" <VERITAS-BU AT mailman.eng.auburn DOT edu>
Date: Wed, 17 Mar 2010 22:29:52 +0100
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 DOT edu 
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] 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 DOT edu
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 DOT edu 
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] 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 DOT edu
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 DOT edu 
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Carlos 
Alberto Lima dos Santos
Sent: Wednesday, March 17, 2010 7:58 AM
To: VERITAS-BU AT mailman.eng.auburn DOT edu
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 DOT br
----------------------------------------



----- Mensagem original ----
De: awiggins <netbackup-forum AT backupcentral DOT com>
Para: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
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 DOT net via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
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 DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
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 DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

<Prev in Thread] Current Thread [Next in Thread>