Re: [Veritas-bu] recovery of oracle database using netbackup

Hi,
I am attaching the log file of the error which I am getting while doing the restore through script.

Script ./database_restore.sh ==== started on Tue Dec 11 01:14:44 PST 2007 ==== RMAN: /opt/app/oracle/product/9.2.0.4_32bit/bin/rman ORACLE_SID: EAI ORACLE_USER: oracle ORACLE_HOME: /opt/app/oracle/product/9.2.0.4_32bit ============================================================== This is a Mindspeed Technologies Inc. server. Unauthorized Access is prohibited. For operational problems please file a helpdesk ticket (or) call +1 949 579-5000 (or) mail to basis.unix AT mindspeed DOT com ============================================================== You have new mail. RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> RMAN> n Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database (not started) connected to recovery catalog database RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of allocate command at 12/11/2007 01:14:49 RMAN-06403: could not obtain a fully authorized session ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory
Thanks & Regards,

Ratheesh R Das
M I N D S P E E D Technologies
Storage and Backup | 866-772-4252 ext 2301
ratheesh.das AT mindspeed DOT com

"Bobby Williams" <bobbyrjw AT comcast DOT net>

12/12/2007 03:37 AM

Please respond to
<bobbyrjw AT comcast DOT net>

To	<ratheesh.das AT mindspeed DOT com>, <veritas-bu AT mailman.eng.auburn DOT edu>
cc
Subject	RE: [Veritas-bu] recovery of oracle database using netbackup

If it is an oracle backup, should the type not be a "4" instead of a "2" like you have. I don't know of a type "2".

If it is a type 4, then you have to pull it back with RMAN from the Oracle client.

Bobby Williams
2205 Peterson Drive
Chattanooga, Tennessee 37421
423-296-8200

From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of ratheesh.das AT mindspeed DOT com
Sent: Tuesday, December 11, 2007 3:35 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] recovery of oracle database using netbackup

Hi All,

Can anyone tell what is the procedure to recover oracle database which are being backed up from netbackup using netbackup script. I tried using the following command, but it is failing from error 227.

bprestore -B -C aloe-b -D aloe-b -p ORA-ALOE-EAI-DD -s 12/05/2007 -e 12/07/2007 -f /home/dasrr/restore_EAI_aloe_source -L /home/dasrr/restore_log_aloe -t 2

Here our client is aloe and I have added the file list in the file restore_EAI_aloe_source. Is it required to make a restore script and do the restore using that??

Thanks & Regards,

Ratheesh R Das
M I N D S P E E D Technologies
Storage and Backup | 866-772-4252 ext 2301
ratheesh.das AT mindspeed DOT com

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu