It's been a while for me doing Oracle recoveries, but based on the error below,
I thought that the Oracle instance has to be up in either a "startup mount" or
"startup nomount" mode where it's not really running, but mounted enough to
take a restore/recovery.
(5 mins pass asking one of our DBAs)
"startup mount", assuming you're doing a full restore.
~ Robin
>>> <ratheesh.das AT mindspeed DOT com> 12/12/2007 2:44 AM >>>
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
|