brrestore from EMC Networker and DataDomain

BRRESTORE from Networker software: ORACLE DATABASE.

Scenario explaining how to restore using backup from EMC DD& Netwroker using BRrestore.  Database should be backed up using backnit tools from EMC. The backup should be completed successfully at the application level as well as database level. User can check the backup status using TXN db12 and verify the status.

Source system and target system should be the same database and patch level as well OS also. (recommended) try to keep the same drive as source system.

On the target machine EMC networker backup should be configure and backed up before restoring the source.

STEP1:

initSID.utl File must be created while configuring the backup to the target machine. Edit the  “initSID.utl” file and add the following parameter. Normally the file located in to % ORACLE_HOME% database folder

NSR_NWPATH = C:\Program Files\EMC NetWorker\nsr\bin\

NSR_DEVICE_INTERFACE=DATA_DOMAIN

NSR_RECOVER_POOL = GEP2018

client = eccsapgrp.TEST.local 

server = backupsrvr.TEST.local

debug_level=9

verbose=TRUE

#NSR_DPRINTF=TRUE

Above parameter details:

NSR_NWPATH= networker installed path in target machine

NSR_RECOVER_POOL = source system data backup pool

Client= sources system hostname  FQN if configured.

Server = networker backup server(media server)

Save the file after adding the parameter, in to same location.File should have read and write access to the ora_dba user and sapSIDadm user.

TOTAL FILE details below.

###########################################################################

#

# This is the <init>.utl file.

#

# This file contains settings for the NetWorker Module for SAP with

# Oracle (a.k.a. NMSAP).

#

# Note: Comments have a "#" in the first column.

#

###########################################################################

# Default Value: 8

# Valid Values: > 0 integer

# Number of simultaneous savesets/savestreams to send to server.

# Be sure your server and devices are configured to support at least

# as many streams.

#

# parallelism = 8

parallelism = 30

# Default Value: no

# Valid Values: no/yes

# Group saveset by file system

# If set to 'yes', savesets parameter will be ignored

#

# ss_group_by_fs = yes

ss_group_by_fs = FALSE

# Additional configuration options.

# These are optional fields.

#

NSR_NWPATH = C:\Program Files\EMC NetWorker\nsr\bin\

NSR_DEVICE_INTERFACE=DATA_DOMAIN

NSR_RECOVER_POOL = GEP2018

client = eccsapgrp.geepas.local

server = backupsrvr.geepas.local

debug_level=9

verbose=TRUE

#NSR_DPRINTF=TRUE

STEP 2:

Copy xxx.anf file to the %sapdata_home%\sapbackup. .anf file either located in to source system %sapdata_home%\sapbackup – folder or into the backup location where you backed up last backup.

Brrestore will perform the restore based on .anf file.

Once place the .anf file into the sapbackup folder open cmd with administrative right and run the below scrip:

You must edit the script based on the file location and .anf file name.

brrestore -p C:\oracle\GEP\102\database\initGEP.sap -d util_file -r C:\oracle\GEP\102\database\initGEP.utl -m full -b beybvnzl.anf -m full -m all=X:\restore -c force

Above script I am restoring all 6TB database data file in to the X: drive\restore folder. In this scenario all data file will be restored into the X:\restore folder without parent and subfolder. Once restore complete you can see the logs into the same sapbackup folder with file extension .rsb.


datadomain
=========================
ddboost show stats interval 2      =
=========================

Once all data file completely restored into the drive you need to restore archive logs from the backup location.

STEP3:

After that create control file using control file script.

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "GEP" RESETLOGS  ARCHIVELOG

    MAXLOGFILES 255

    MAXLOGMEMBERS 3

    MAXDATAFILES 508

    MAXINSTANCES 50

    MAXLOGHISTORY 93484

LOGFILE

  GROUP 1 (

    'E:\ORACLE\GEP\ORIGLOGA\LOG_G11M1.DBF',

    'F:\ORACLE\GEP\MIRRLOGA\LOG_G11M2.DBF'

  ) SIZE 150M,

  GROUP 2 (

    'E:\ORACLE\GEP\ORIGLOGB\LOG_G12M1.DBF',

    'F:\ORACLE\GEP\MIRRLOGB\LOG_G12M2.DBF'

  ) SIZE 150M,

  GROUP 3 (

    'E:\ORACLE\GEP\ORIGLOGA\LOG_G13M1.DBF',

    'F:\ORACLE\GEP\MIRRLOGA\LOG_G13M2.DBF'

  ) SIZE 150M,

  GROUP 4 (

    'E:\ORACLE\GEP\ORIGLOGB\LOG_G14M1.DBF',

    'F:\ORACLE\GEP\MIRRLOGB\LOG_G14M2.DBF'

  ) SIZE 150M

-- STANDBY LOGFILE

DATAFILE

  'X:\restore\SYSTEM.DATA1',

  'X:\restore\UNDO.DATA1',

  'X:\restore\SYSAUX.DATA1',

  'X:\restore\SR3.DATA1',

  'X:\restore\SR3.DATA2',

  'X:\restore\SR3.DATA3'

CHARACTER SET UTF8

;

SQL> @h:\geP.sql
ORACLE instance started.
Total System Global Area 1.0452E+10 bytes
Fixed Size                  2094864 bytes
Variable Size            5268048112 bytes
Database Buffers         5167382528 bytes
Redo Buffers               14680064 bytes
Control file created.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'H:\GED\V\ORACLE\GED\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> recover database using backup controlfile;
ORA-00279: change 3368505684 generated at 03/11/2018 18:30:18 needed for thread
1
ORA-00289: suggestion : G:\ORACLE\GEP\ORAARCH\GEDARCH1_51014_713190785.DBF
ORA-00280: change 3368505684 for thread 1 is in sequence #51014

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
G:\ORACLE\GEP\ORAARCH\GEDARCH1_51014_713190785.DBF
ORA-00279: change 3368506852 generated at 03/11/2018 18:38:41 needed for thread
1
ORA-00289: suggestion : G:\ORACLE\GEP\ORAARCH\GEDARCH1_51015_713190785.DBF
ORA-00280: change 3368506852 for thread 1 is in sequence #51015
ORA-00278: log file 'G:\ORACLE\GEP\ORAARCH\GEDARCH1_51014_713190785.DBF' no
longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 3368506852 generated at 03/11/2018 18:38:41 needed for thread
1
ORA-00289: suggestion : G:\ORACLE\GEP\ORAARCH\GEDARCH1_51015_713190785.DBF
ORA-00280: change 3368506852 for thread 1 is in sequence #51015

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> alter database open resetlogs;
Database altered.
SQL>

>.RSB file output

BR0401I BRRESTORE 7.20 (29)

BR0405I Start of file restore: reyebtvf.rsb 2018-04-02 17.16.43

BR0484I BRRESTORE log file: H:\oracle\GEP\sapbackup\reyebtvf.rsb

BR0101I Parameters

Name                           Value

oracle_sid                     GEP

oracle_home                    C:\oracle\GEP\102

oracle_profile                 C:\oracle\GEP\102\database\initGEP.ora

sapdata_home                   H:\oracle\GEP

sap_profile                    C:\oracle\GEP\102\database\initGEP.sap

recov_interval                 30

restore_mode                   ALL=X:\restore

backup_dev_type                util_file

util_par_file                  C:\oracle\GEP\102\database\initGEP.utl

system_info                    gepadm TESTGEP Windows 6.0 Build 6001 Service Pack 1 AMD64

oracle_info                    GEP 10.2.0.5.0

make_info                      NTAMD64 OCI_10201_SHARE Jan 16 2013

command_line                   brrestore -p C:\oracle\GEP\102\database\initGEP.sap -d util_file -r C:\oracle\GEP\102\database\initGEP.utl -m full -b beybvnzl.anf -m full -m all=X:\restore -c force

BR0460W Termination message not found in H:\oracle\GEP\sapbackup\beybvnzl.anf - log file incomplete (this is OK if the log file has been restored)

BR0456I Probably the database must be recovered due to restore from online backup

BR0280I BRRESTORE time stamp: 2018-04-02 17.16.43

BR0407I Restore of database: GEP

BR0408I BRRESTORE action ID: reyebtvf

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: ALL=X:\restore

BR0419I Files will be restored from backup: beybvnzl.anf 2018-03-21 21.00.49

BR0416I 296 files found to restore, total size 5933436.313 MB

BR0421I Restore device type: util_file

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRRESTORE time stamp: 2018-04-02 17.16.43

BR0229I Calling backup utility with function 'restore'...

BR0278I Command output of 'C:\usr\sap\GEP\SYS\exe\uc\NTAMD64\backint.exe -u GEP -f restore -i H:\oracle\GEP\sapbackup\.reyebtvf.lst -t file -p C:\oracle\GEP\102\database\initGEP.utl -c':

BR0280I BRRESTORE time stamp: 2018-04-03 05.02.11

#FILE..... L:\ORACLE\GEP\SAPDATA3\SR3_246\SR3.DATA246  X:\restore\SR3.DATA246

#RESTORED. 1521651712

BR0280I BRRESTORE time stamp: 2018-04-03 05.02.11

BR0374I 96 of 96 files restored by backup utility

BR0230I Backup utility called successfully

BR0406I End of file restore: reyebtvf.rsb 2018-04-03 05.02.11

BR0280I BRRESTORE time stamp: 2018-04-03 05.02.11

BR0403I BRRESTORE completed successfully with warnings