BRRESTORE from Networker software: ORACLE DATABASE.

BRRESTORE from Networker software: ORACLE DATABASE.

https://wrongcodes.blogspot.com/2018/04/brrestore-from-emc-networker-and.html

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

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: {=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: {=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: {=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> alter database open resetlogs;
Database altered.
SQL>