Veritas-bu

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

2007-12-15 13:15:52
Subject: Re: [Veritas-bu] recovery of oracle database using netbackup
From: "Pedro Espinoza" <raindoctor AT gmail DOT com>
To: ratheesh.das AT mindspeed DOT com, veritas-bu AT mailman.eng.auburn DOT edu
Date: Sat, 15 Dec 2007 12:48:50 -0500
Logs without the script do not help anybody, except for a waste of time.

1. either you or the script has to the start the databse in nomount
state (startup nomount)
2. restore the controlfile (by copying the backup controlfiles to the
relevant locations mentioned in initEAI.ora) or using rman "restore
controlfile from
auto backup"

3. you need to bring the database to the mount state (alter database mount).
4. you need to restore the data files (restore database)
5. recover database
6. alter database open resetlogs
7. You are done.

In the restore and recover steps, you can call the netbackup master
server (allocating tape channels along with passing nb master server,
client)




>  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
>
_______________________________________________
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>