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