Re: SAP Oracle Database Restore

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sat, 26 Feb 2011 10:10:07 +0100
Message-ID: <AANLkTikiaggWp-dz9F5xt+bvvEh3m50sa3kiATPAqghx_at_mail.gmail.com>

For a critical operation like a full restore and recovery, I would probably contact the official support channels for help, if I have not done this before.

Since it's Oracle 9, you probably won't get support from Oracle, but SAP should be able to help.

Stefan

---

Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

On Fri, Feb 25, 2011 at 5:08 PM, Roger Xu <wellmetus_at_gmail.com> wrote:

> Hi,
>
> We had a legacy SAP database (2.1 TB) and the people who managed it are all
> gone. Now I have a task to restore it from tapes.
>
> Sun Solaris 9
> Oracle 9i
> SAP 40B
> NetWorker 7.1 or 7.2
> Legato NetWorker Module for SAP on Oracle 2.1
> Quantum M1500 tape library
> LTO tapes
>
> According to the backup log (/oracle/SID/sapbackup/bebsvyuz.anf), the
> backup was done on 10/22/2009 and it used 5 tapes.
> Any idea? My thoughts is:
> 1) scan all 5 tapes using "scanner -m" command for media index (do I need
> file index?)
> 2) use brrestore to restore all the oracle data files
> 3) use brrecover to recover the database
>
> Am I on the right track? Can you let me know the commands whould be like? I
> think the brrestore command would be: brrestore -m full -b bebsvyuz.anf
> ........ how abover recovery?
>
> Thanks,
>
> Roger Xu
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Feb 26 2011 - 03:10:07 CST