on 07-16-2014 5:14 PM
Hello experts,
on online backup, the brbackup can't connect with primary database, err: ORACLE initialization or shutdown in progress.
INIT_SID.SAP
backup_mode = full
restore_mode = all
backup_type = online_mirror
backup_dev_type = rman_util
backup_root_dir = /oracle/OR5/sapbackup
stage_root_dir = /oracle/OR5/sapbackup
compress = no
archive_function = save
archive_copy_dir = /oracle/OR5/sapbackup
archive_stage_dir = /oracle/OR5/sapbackup
tape_copy_cmd = rman
disk_copy_cmd = rman
stage_copy_cmd = scp
asm_ora_sid = +ASM
asm_ora_home = /oracle/GRID/11204'
rman_channels = 14
rman_filesperset = 1
rman_parms = "ENV=(NB_ORA_SAP=/oracle/OR5/112_64/dbs/initOR5_RMAN_FULL.utl)"
exec_parallel = 0
#expir_period = 30
util_par_file = /oracle/OR5/112_64/dbs/initOR5_BACKINT_FULL.utl
primary_db = OR5.WORLD
post_split_cmd = "/oracle/OR5/112_64/dbs/start_asm.ksh"
parallel_instances = (OR51:/oracle/OR5/112_64@OR51.WORLD,OR52:/oracle/OR5/112_64@OR52.WORLD)
backint_dir /oracle/OR5/sapbackup/backint_dir
switch_list /oracle/OR5/sapbackup/.switch.lis
switch_sem /oracle/OR5/sapbackup/.switch.sem
switch_log /oracle/OR5/sapbackup/.switch.log
server <private information removed by moderator>
client <private information removed by moderator>
class <private information removed by moderator>
schedule Default-Application-Backup
sort_backup_type size
sort_restore_type image
/usr/sap/OR5/SYS/exe/run/brbackup -p ${ORACLE_HOME}/dbs/initOR5_RMAN_FULL.sap -c -FTS -u sys/******
BR0051I BRBACKUP 7.40 (6)
BR0280I BRBACKUP time stamp: 2014-07-21 12:07:57
BR0262I Enter database user name[/password]:
BR0055I Start of database backup: beoiqxmz.fnr 2014-07-21 12:07:57
BR0484I BRBACKUP log file: /oracle/OR5/sapbackup/beoiqxmz.fnr
BR0351I Restoring /oracle/OR5/sapprof/sapOR5.ora
BR0355I from vhor51:/oracle/OR5/sapprof/sapOR5.ora ...
BR0351I Restoring /oracle/OR5/sapprof/spfileOR5.ora
BR0355I from vhor51:/oracle/OR5/sapprof/spfileOR5.ora ...
BR0280I BRBACKUP time stamp: 2014-07-21 12:08:00
BR0477I Oracle pfile /oracle/OR5/sapprof/initOR5.ora created from spfile /oracle/OR5/112_64/dbs/spfileOR5.ora
BR1805I Oracle spfile /oracle/OR5/sapprof/spfileOR5.ora created from pfile /oracle/OR5/sapprof/initOR5.ora
BR1304W Checking SAP license failed at location BrLicCheck-122
BR0602W No valid SAP license found - please contact SAP
BR0351I Restoring /oracle/OR5/sapbackup/cntrlOR5.dbf
BR0355I from vhor51:/oracle/OR5/sapbackup/cntrlOR5.dbf ...
BR0280I BRBACKUP time stamp: 2014-07-21 12:08:10
BR0319I Control file copy created: /oracle/OR5/sapbackup/cntrlOR5.dbf 32194560
BR2002W Database file '+OR5_RECO(CONTROLFILE)/OR5/cntrlOR5.dbf' not found in ASM
BR2002W Database file '+OR5_DATA(CONTROLFILE)/OR5/cntrlOR5.dbf' not found in ASM
BR0280I BRBACKUP time stamp: 2014-07-21 12:08:17
BR0295I Splitting mirror disks...
BR0280I BRBACKUP time stamp: 2014-07-21 12:08:17
BR0278I Command output of 'splitint -u OR5 -f split -i /oracle/OR5/sapbackup/.beoiqxmz.lst -t online -c':
Starting splitint
BR0280I BRBACKUP time stamp: 2014-07-21 12:18:36
#BEGIN SPLIT /oracle/OR5/sapbackup/sync/ER1begin.smf
BR0280I BRBACKUP time stamp: 2014-07-21 12:18:37
BR0315I 'Alter database begin backup' successful
BR0280I BRBACKUP time stamp: 2014-07-21 12:18:39
#END SPLIT /oracle/OR5/sapbackup/sync/ER1end.smf
BR0280I BRBACKUP time stamp: 2014-07-21 12:18:39
BR0317I 'Alter database end backup' successful
BR0280I BRBACKUP time stamp: 2014-07-21 12:23:45
BR0629I SPLITINT command sent success message: #SUCCESS
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:14
BR0296I Split of mirror disks successful
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:14
BR0340I Switching to the next online redolog file for database instance OR5 ...
BR0321I Switch to the next online redolog file for database instance OR5 successful
BR0340I Switching to the next online redolog file for database instance OR52 ...
BR0321I Switch to the next online redolog file for database instance OR52 successful
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:17
BR1374I Executing post-split command '/oracle/OR5/112_64/dbs/start_asm.ksh'...
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:33
BR1375I Post-split command '/oracle/OR5/112_64/dbs/start_asm.ksh' executed successfully
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:33
BR0330I Starting and mounting database instance OR5/SPLIT ...
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:45
BR0331I Start and mount of database instance OR5/SPLIT successful
BR0274W File '+OR5_RECO(CONTROLFILE)/OR5/cntrlOR5.dbf' not found
BR0274W File '+OR5_DATA(CONTROLFILE)/OR5/cntrlOR5.dbf' not found
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:49
BR0057I Backup of database: OR5
BR0058I BRBACKUP action ID: beoiqxmz
BR0059I BRBACKUP function ID: fnr
BR0110I Backup mode: FULL
BR0077I Database file for backup: /oracle/OR5/sapbackup/cntrlOR5.dbf
BR0061I 223 files found for backup, total size 566070.438 MB
BR0143I Backup type: online_mirror
BR0112I Files will not be compressed
BR0130I Backup device type: rman_util
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:49
BR0301E SQL error -1033 at location BrDbConnect-2, SQL statement:
'CONNECT sarepmgr/**********@OR5.WORLD'
ORA-01033: ORACLE initialization or shutdown in progress
BR0310E Connect to database instance OR5/PRIMARY failed
BR0311E Connect to database instance OR5 during online backup failed
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:49
BR0307I Shutting down database instance OR5/SPLIT ...
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:57
BR0308I Shutdown of database instance OR5/SPLIT successful
BR0056I End of database backup: beoiqxmz.fnr 2014-07-21 12:25:57
BR0280I BRBACKUP time stamp: 2014-07-21 12:25:57
BR0054I BRBACKUP terminated with errors
logout
Jorbson Oliveira
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jorbson,
From the attached logs
BR0248I BR_TRACE: level 1, function BrSparseCreate entry with '+OR5_DATA/or5/datafile/patrol.374.843428381'
BR0248I BR_TRACE: level 2, function BrNameBuild entry with '1 +OR5_DATA/or5/datafile/patrol.374.843428381 /oracle/OR5/sapbackup/beojbcbt.spa'
BR0250I BR_TRACE: level 2, function BrNameBuild exit with '/oracle/OR5/sapbackup/beojbcbt.spa/patrol.374.843428381'
BR0252E Function fopen() failed for '+OR5_DATA/or5/datafile/patrol.374.843428381' at location BrSparseCreate-1
BR0253E errno 2: No such file or directory
Please check whether such file exists or not.
Regards,
Deepak Kori
Dear Kori,
yes the file exist, but it's in a ASM.
When backup_type=online_mirror parameter is set, the brbackup create a filelog.spa directory, copy on the file header and then catalog in primary_db. Seems brbackup is not looking into the ASM, but in filesystem.
I do not know if the backup_type=online_mirror type is supported with +ASM?
Thank you,
Jorbson Oliveira
Dear Nick Loy,
with your help could move, but then the following error:
'CONNECT sarepmgr/**********@OR5.WORLD'
BR0300I BR_TRACE: SQL code: 0, number of processed rows: 0
BR0248I BR_TRACE: level 2, function BrOraSigPatch entry with 'TRUE 0'
BR0248I BR_TRACE: level 3, function BrZombieKill entry with 'void'
BR0270I Unknown process with ID 20185282 terminated
BR0250I BR_TRACE: level 3, function BrZombieKill exit with 'void'
BR0249I BR_TRACE: level 2, function BrOraSigPatch exit with 0
BR0644I BR_TRACE: location BrDbConnect-4, SQL statement:
'ALTER SESSION SET TRACEFILE_IDENTIFIER = "beoiwwoj_fnr"'
BR0300I BR_TRACE: SQL code: 0, number of processed rows: 0
BR0644I BR_TRACE: location BrDbConnect-5, SQL statement:
'ALTER SESSION SET SQL_TRACE = TRUE'
BR0300I BR_TRACE: SQL code: 0, number of processed rows: 0
BR0249I BR_TRACE: level 1, function BrDbConnect exit with 0
BR0248I BR_TRACE: level 1, function BrSparseCreate entry with '+OR5_DATA/or5/datafile/patrol.374.843428381'
BR0248I BR_TRACE: level 2, function BrNameBuild entry with '1 +OR5_DATA/or5/datafile/patrol.374.843428381 /oracle/OR5/sapbackup/beoiwwoj.spa'
BR0250I BR_TRACE: level 2, function BrNameBuild exit with '/oracle/OR5/sapbackup/beoiwwoj.spa/patrol.374.843428381'
BR0252E Function fopen() failed for '+OR5_DATA/or5/datafile/patrol.374.843428381' at location BrSparseCreate-1
BR0253E errno 2: No such file or directory
BR0249I BR_TRACE: level 1, function BrSparseCreate exit with -1
BR0248I BR_TRACE: level 1, function BrCleanup entry with 5
BR0248I BR_TRACE: level 2, function BrDbShutdown entry with 'OR5/SPLIT'
BR0248I BR_TRACE: level 3, function BrDbDisconnect entry with 'void'
BR0248I BR_TRACE: level 4, function BrOraSigPatch entry with 'FALSE 1'
BR0248I BR_TRACE: level 5, function BrZombieKill entry with 'void'
BR0250I BR_TRACE: level 5, function BrZombieKill exit with 'void'
BR0249I BR_TRACE: level 4, function BrOraSigPatch exit with 0
BR0280I BRBACKUP time stamp: 2014-07-22 17:33:22
BR0644I BR_TRACE: location BrDbDisconnect-2, SQL statement:
'COMMIT RELEASE'
Jorbson
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you able to connect to database using sqlplus?
Check permissions of brtools using SAP Note 113747.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.