Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Backup with SPLIT COPY

Hi,

I have a windows cluster SAP R3 4.7 with oracle 10.2.

I have implemented backup with brtools 7.0 with split copy, using split_cmd command to split filesystem and post_split_cmd to start sap.

Bac

Brbackup finish successfully but with the warning:

"BR0068W SAP system is running or SAP user is connected to database PRD - database cannot be shut down"

We attach the log of brbackup .

Any idea ?

Thanks.

Maurizio Manera

-


Detail log: beajdpzw.aff

-


BR0051I BRBACKUP 7.00 (40)

BR0055I Start of database backup: beajdpzw.aff 2009-04-16 01.50.28

BR0484I BRBACKUP log file: Z:\oracle\PRD\sapbackup\beajdpzw.aff

BR0351I Restoring F:\oracle\PRD\102\database\sapPRD.ora

BR0355I from F:\oracle\PRD\102\database\sapPRD.ora ...

BR0477I Oracle pfile F:\oracle\PRD\102\database\initPRD.ora created from spfile F:\oracle\PRD\102\database\spfilePRD.ora

BR0613I Database instance PRD/PRIMARY is shut down

BR0280I BRBACKUP time stamp: 2009-04-16 01.50.29

BR0304I Starting and opening database instance PRD/PRIMARY ...

BR0280I BRBACKUP time stamp: 2009-04-16 01.50.38

BR0305I Start and open of database instance PRD/PRIMARY successful

BR0101I Parameters

Name Value

oracle_sid PRD

oracle_home F:\oracle\PRD\102

oracle_profile F:\oracle\PRD\102\database\initPRD.ora

sapdata_home K:\oracle\PRD

sap_profile f:\splitscripts\PRD\initPRD_ReplicationManager.sap

backup_mode ALL

backup_type offline_split

backup_dev_type util_file

util_par_file F:\splitscripts\PRD\initPRD_ReplicationManager.utl

primary_db PRD

split_cmd F:\splitscripts\PRD\ERM_PRD.cmd > F:\splitscripts\PRD\logs\split_log.txt

resync_cmd NULL

post_split_cmd F:\splitscripts\PRD\start_PRD_sap.cmd > F:\splitscripts\PRD\logs\post_split_log.txt

system_info prdadm SRB44 Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info PRD 10.2.0.2.0 8192 24929 2831181212 SRB31 UTF8 UTF8

sap_info 620 SAPPRD PRD S0893011436 R3_ORA 0020174098

make_info NTAMD64 OCI_10201_SHARE Feb 1 2009

command_line brbackup.exe -p f:\splitscripts\PRD\initPRD_ReplicationManager.sap -t offline_split -u system/****** -d util_file -m all -c

BR0116I ARCHIVE LOG LIST before backup for database instance PRD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination M:\oracle\PRD\oraarch\PRDarch

Archive format ARC%S_%R.%T

Oldest online log sequence 24926

Next log sequence to archive 24929

Current log sequence 24929 SCN: 2831181212

Database block size 8192 Thread: 1

Current system change number 2831210933 ResetId: 633955817

BR0280I BRBACKUP time stamp: 2009-04-16 01.50.44

BR0307I Shutting down database instance PRD/PRIMARY ...

BR0280I BRBACKUP time stamp: 2009-04-16 01.50.45

BR0308I Shutdown of database instance PRD/PRIMARY successful

BR0280I BRBACKUP time stamp: 2009-04-16 01.50.46

BR0295I Splitting mirror disks...

BR0280I BRBACKUP time stamp: 2009-04-16 02.04.56

BR0296I Split of mirror disks successful

BR0280I BRBACKUP time stamp: 2009-04-16 02.04.56

BR0304I Starting and opening database instance PRD/PRIMARY ...

BR0280I BRBACKUP time stamp: 2009-04-16 02.06.28

BR0305I Start and open of database instance PRD/PRIMARY successful

BR0117I ARCHIVE LOG LIST after backup for database instance PRD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination M:\oracle\PRD\oraarch\PRDarch

Archive format ARC%S_%R.%T

Oldest online log sequence 24926

Next log sequence to archive 24929

Current log sequence 24929 SCN: 2831181212

Database block size 8192 Thread: 1

Current system change number 2831214167 ResetId: 633955817

BR0280I BRBACKUP time stamp: 2009-04-16 02.06.29

BR1374I Executing post-split command...

BR0280I BRBACKUP time stamp: 2009-04-16 02.08.48

BR1375I Post-split command executed successfully

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA3\PRD_20\PRD.DATA20 10485768192 23 9 NOLINK FILE 10485760000 20971520 8192

.....

BR0120I Control files

File Size Id. Device Link Type

H:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf 15024128 0 7 NOLINK FILE

K:\oracle\PRD\sapdata1\system_1\cntrl\cntrlPRD.dbf 15024128 0 10 NOLINK FILE

K:\oracle\PRD\saparch\cntrl\cntrlPRD.dbf 15024128 0 10 NOLINK FILE

BR0280I BRBACKUP time stamp: 2009-04-16 02.08.48

BR0057I Backup of database: PRD

BR0058I BRBACKUP action ID: beajdpzw

BR0059I BRBACKUP function ID: aff

BR0110I Backup mode: ALL

BR0077I Database files for backup:

H:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF

H:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF

H:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF

H:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF

H:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf

BR0061I 89 files found for backup, total size 724314.986 MB

BR0143I Backup type: offline_split

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRBACKUP time stamp: 2009-04-16 02.08.48

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

BR0278I Command output of 'F:\usr\sap\PRD\SYS\exe\run\backint.exe -u PRD -f backup -i Z:\oracle\PRD\sapbackup\.beajdpzw.lst -t file -p F:\splitscripts\PRD\initPRD_ReplicationManager.utl -c':

BR0280I BRBACKUP time stamp: 2009-04-16 02.18.37

#FILE..... J:\ORACLE\PRD\SAPDATA3\PRD_21\PRD.DATA21

#SAVED.... 1239840533

....

BR0280I BRBACKUP time stamp: 2009-04-16 04.33.11

#FILE..... J:\ORACLE\PRD\SAPDATA3\PRD_57\PRD.DATA57

#SAVED.... 1239848995

BR0280I BRBACKUP time stamp: 2009-04-16 04.33.11

BR0232I 89 of 89 files saved by backup utility

BR0230I Backup utility called successfully

BR0280I BRBACKUP time stamp: 2009-04-16 04.33.14

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

BR0278I Command output of 'F:\usr\sap\PRD\SYS\exe\run\backint.exe -u PRD -f backup -i Z:\oracle\PRD\sapbackup\.beajdpzw.lst -t file -p F:\splitscripts\PRD\initPRD_ReplicationManager.utl -c':

BR0280I BRBACKUP time stamp: 2009-04-16 04.33.16

#PFLOG.... Z:\oracle\PRD\sapbackup\beajdpzw.aff

#SAVED.... 1239849194

BR0280I BRBACKUP time stamp: 2009-04-16 04.33.17

#PFLOG.... Z:\oracle\PRD\sapbackup\backPRD.log

#SAVED.... 1239849195

....

BR0280I BRBACKUP time stamp: 2009-04-16 04.33.21

#PFLOG.... F:\oracle\PRD\102\database\initPRD.ora

#SAVED.... 1239849201

BR0280I BRBACKUP time stamp: 2009-04-16 04.33.21

BR0232I 8 of 8 files saved by backup utility

BR0230I Backup utility called successfully

BR0068W SAP system is running or SAP user is connected to database PRD - database cannot be shut down

BR0056I End of database backup: beajdpzw.aff 2009-04-16 04.33.21

BR0280I BRBACKUP time stamp: 2009-04-16 04.33.22

BR0053I BRBACKUP completed successfully with warnings

Not what you were looking for? View more on this topic or Ask a question