Re: SAP Oracle Database Restore

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@xxxxxxxx

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

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

=========================


On Fri, Feb 25, 2011 at 5:08 PM, Roger Xu <wellmetus@xxxxxxxxx> 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
>

Other related posts: