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