cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE initialization or shutdown in progress

0 Kudos

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)

INIT_SID.UTL

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

Err Log:

/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

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hi,

      full log attached.

Thanks,

Jorbson

former_member188883
Active Contributor
0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

To backup database from ASM you must to use RMAN only. What the parameter value for backup_dev_type in initOR5_RMAN_FULL.sap file?

0 Kudos

Roman,



   backup_dev_type = rman_util.


   All parameters is posted here.



Thank you,


Jorbson Oliveira

0 Kudos

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

Former Member
0 Kudos

Hi,

Could you try to connect with Schema owner and paste the errors? Or with a user who have sapdba,sysdba privilleges.

Regards,

Nick Loy

0 Kudos

Hi,

Now the error is no more CONNECTION, is:

BR0252E Function fopen() failed for '+OR5_DATA/or5/datafile/patrol.374.843428381' at location BrSparseCreate-1

BR0253E errno 2: No such file or directory

Thank you,

Jorbson

Former Member
0 Kudos

Yes,

Error clearly says!

But i just want to understand whether you are connecting using a user which has proper authorization or not?

Try to connect to database using the same id and Schema owner.

Regards,

Nick Loy

Former Member
0 Kudos

Can you attach full log file?

Former Member
0 Kudos

Are you able to connect to database using sqlplus?

Check permissions of brtools using SAP Note 113747.

Regards,

Nick Loy