Strange signs in names of backup files

Hi!

I have strange names of backup files after the backup from windows --> to Unix via FTP. There files contains ~ ,§, %, -, _, etc.

Which parameter is responsible for this issue?

E.g. I have seen in DB 13 Log protocol parameter
Archive format ARC%S_%R.%T

The further problem is that druing the archive redo logs a very strange path is being created:
FolderFolder and all the files are named SAPSID ile.

With which parameter can I change these settings?

Thank you very much!

regards

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

dont touch Archive format ARC%S_%R.%T.

%S,%R,%T are placeholders for the Oracle Kernel which will be replace with the database SID, revision number and thread number.

The have nothing to do with additional characters in filenames.

can you please post brbackup' logfile to see what he is copying?

~ ,§, %, -, _, may result from codepage conversion problems between Windows and Linux FTP or from using Windows Short filenames (which should be disabled anyway).

Peter

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Peter!

Thank you very much for response.

The files look like:

B3JOTZ~6

B3JOTZ~7

B4HSMT~9

B3JOTZ~9

Is there some parameters or other possibilities to fix the problem?

you did not post the logfile of brbackup.

I am interested in that one, not just two or three filenames.

peter

Ok!

I have run the online backup. The names of the files are, as described, look like temporare files with ~.

The second problem is, that the path given in stage_root_dir= sap/SSMBackup will be ignored, so all the files are writen to up level to sap-directory.

Here the log file

Detailliertes Protokoll: bdvvgusw.ans

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bdvvgusw.ans 2007-08-01 14.43.06

BR0049W Last BRBACKUP run was probably killed

BR0477I Oracle pfile C:\oracle\SSM\102\database\initSSM.ora created from spfile C:\oracle\SSM\102\database\spfileSSM.ora

BR0280I BRBACKUP time stamp: 2007-08-01 14.43.09

BR0319I Control file copy created: H:\oracle\SSM\sapbackup\CNTRLSSM.DBF 12664832

BR0101I Parameters

Name Value

oracle_sid SSM

oracle_home C:\oracle\SSM\102

oracle_profile C:\oracle\SSM\102\database\initSSM.ora

sapdata_home H:\oracle\SSM

sap_profile C:\oracle\SSM\102\database\initSSM.sap

backup_mode ALL

backup_type online

backup_dev_type stage

stage_root_dir sap/SSMBackup

compress no

stage_copy_cmd ftp

remote_host Nas_stor02

remote_user sapbackup

exec_parallel 0

system_info SAPServiceSSM SAPDEV Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info SSM 10.2.0.1.0 8192 450 4611729 SAPDEV UTF8 UTF8

sap_info 700 SAPSR3

make_info NTAMD64 OCI_10201_SHARE Oct 26 2006

command_line brbackup -u / -jid ALL__20070801143916 -c force -t online -m all -p initSSM.sap

BR0116I ARCHIVE LOG LIST before backup for database instance SSM

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination H:\oracle\SSM\oraarch\SSMarch

Archive format ARC%S_%R.%T

Oldest online log sequence 447

Next log sequence to archive 450

Current log sequence 450 SCN: 4611729

Database block size 8192 Thread: 1

Current system change number 4625064 ResetId: 627493290

BR0118I Tablespaces and data files

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

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_10\SR3.DATA10 440410112 13 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_1\SR3.DATA1 2097160192 4 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_2\SR3.DATA2 2097160192 5 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_3\SR3.DATA3 2097160192 6 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_4\SR3.DATA4 2097160192 7 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_5\SR3.DATA5 2097160192 8 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_6\SR3.DATA6 2097160192 9 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_7\SR3.DATA7 2097160192 10 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_8\SR3.DATA8 2097160192 11 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA2\SR3_9\SR3.DATA9 2097160192 12 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA3\SR3700_1\SR3700.DATA1 2474647552 14 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA3\SR3700_2\SR3700.DATA2 2579505152 15 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA3\SR3700_3\SR3700.DATA3 2579505152 16 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA3\SR3700_4\SR3700.DATA4 2464161792 17 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA4\SR3DB_1\SR3DB.DATA1 2097160192 19 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA4\SR3DB_2\SR3DB.DATA2 2097160192 20 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA4\SR3DB_3\SR3DB.DATA3 1048584192 21 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA4\SR3USR_1\SR3USR.DATA1 20979712 18 4 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ E:\ORACLE\SSM\SAPDATA1\TEMP_1\TEMP.DATA1 891297792 -1 4 NOLINK FILE 10485760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ E:\ORACLE\SSM\SAPDATA1\UNDO_1\UNDO.DATA1 2474647552 2 4 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ E:\ORACLE\SSM\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 209723392 3 4 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ E:\ORACLE\SSM\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 471867392 1 4 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

H:\ORACLE\SSM\ORIGLOGA\LOG_G11M1.DBF 52429312 1 7 INUSE NOLINK FILE

H:\ORACLE\SSM\MIRRLOGA\LOG_G11M2.DBF 52429312 1 7 INUSE NOLINK FILE

H:\ORACLE\SSM\ORIGLOGB\LOG_G12M1.DBF 52429312 2 7 INUSE NOLINK FILE

H:\ORACLE\SSM\MIRRLOGB\LOG_G12M2.DBF 52429312 2 7 INUSE NOLINK FILE

H:\ORACLE\SSM\ORIGLOGA\LOG_G13M1.DBF 52429312 3 7 INUSE NOLINK FILE

H:\ORACLE\SSM\MIRRLOGA\LOG_G13M2.DBF 52429312 3 7 INUSE NOLINK FILE

H:\ORACLE\SSM\ORIGLOGB\LOG_G14M1.DBF 52429312 4 7 INUSE NOLINK FILE

H:\ORACLE\SSM\MIRRLOGB\LOG_G14M2.DBF 52429312 4 7 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

H:\oracle\SSM\origlogA\cntrl\cntlrSSM.dbf 12664832 0 7 NOLINK FILE

H:\oracle\SSM\origlogB\cntrl\cntrlSSM.dbf 12664832 0 7 NOLINK FILE

H:\oracle\SSM\sapdata1\cntrl\cntrlSSM.dbf 12664832 0 7 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0280I BRBACKUP time stamp: 2007-08-01 14.43.10

BR0057I Backup of database: SSM

BR0058I BRBACKUP action ID: bdvvgusw

BR0059I BRBACKUP function ID: ans

BR0110I Backup mode: ALL

BR0077I Database file for backup: H:\oracle\SSM\sapbackup\CNTRLSSM.DBF

BR0061I 22 files found for backup, total size 36092.242 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: stage

BR0106I Files will be saved on disk in directory: Nas_stor02:sap/SSMBackup\bdvvgusw

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0370I Directory Nas_stor02:sap/SSMBackup\bdvvgusw created

BR0370I Directory sap/SSMBackup\SSM created

BR0202I Saving init_ora

BR0203I to sap/SSMBackup\SSM ...

BR0202I Saving C:\oracle\SSM\102\database\initSSM.sap

BR0203I to sap/SSMBackup\SSM ...

BR0280I BRBACKUP time stamp: 2007-08-01 14.43.11

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2007-08-01 14.43.13

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_10\SR3.DATA10

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA10 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_10\SR3.DATA10

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA10 #1/1

BR0280I BRBACKUP time stamp: 2007-08-01 14.45.14

BR0063I 1 of 22 files processed - 420.008 MB of 36092.242 MB done

BR0204I Percentage done: 1.16%, estimated end time: 17:39

BR0001I *_________________________________________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_1\SR3.DATA1

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA1 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_1\SR3.DATA1

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA1 #1/2

BR0280I BRBACKUP time stamp: 2007-08-01 14.57.42

BR0063I 2 of 22 files processed - 2420.016 MB of 36092.242 MB done

BR0204I Percentage done: 6.71%, estimated end time: 18:19

BR0001I ***_______________________________________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_2\SR3.DATA2

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA2 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_2\SR3.DATA2

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA2 #1/3

BR0280I BRBACKUP time stamp: 2007-08-01 15.08.01

BR0063I 3 of 22 files processed - 4420.023 MB of 36092.242 MB done

BR0204I Percentage done: 12.25%, estimated end time: 18:05

BR0001I ******____________________________________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_3\SR3.DATA3

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA3 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_3\SR3.DATA3

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA3 #1/4

BR0280I BRBACKUP time stamp: 2007-08-01 15.20.17

BR0063I 4 of 22 files processed - 6420.031 MB of 36092.242 MB done

BR0204I Percentage done: 17.79%, estimated end time: 18:11

BR0001I *********_________________________________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_4\SR3.DATA4

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA4 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_4\SR3.DATA4

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA4 #1/5

BR0280I BRBACKUP time stamp: 2007-08-01 15.32.37

BR0063I 5 of 22 files processed - 8420.039 MB of 36092.242 MB done

BR0204I Percentage done: 23.33%, estimated end time: 18:15

BR0001I ************______________________________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_5\SR3.DATA5

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA5 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_5\SR3.DATA5

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA5 #1/6

BR0280I BRBACKUP time stamp: 2007-08-01 15.46.15

BR0063I 6 of 22 files processed - 10420.047 MB of 36092.242 MB done

BR0204I Percentage done: 28.87%, estimated end time: 18:21

BR0001I **************____________________________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_6\SR3.DATA6

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA6 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_6\SR3.DATA6

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA6 #1/7

BR0280I BRBACKUP time stamp: 2007-08-01 15.58.29

BR0063I 7 of 22 files processed - 12420.055 MB of 36092.242 MB done

BR0204I Percentage done: 34.41%, estimated end time: 18:22

BR0001I *****************_________________________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_7\SR3.DATA7

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA7 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_7\SR3.DATA7

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA7 #1/8

BR0280I BRBACKUP time stamp: 2007-08-01 16.12.23

BR0063I 8 of 22 files processed - 14420.063 MB of 36092.242 MB done

BR0204I Percentage done: 39.95%, estimated end time: 18:26

BR0001I ********************______________________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_8\SR3.DATA8

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA8 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_8\SR3.DATA8

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA8 #1/9

BR0280I BRBACKUP time stamp: 2007-08-01 16.24.21

BR0063I 9 of 22 files processed - 16420.070 MB of 36092.242 MB done

BR0204I Percentage done: 45.49%, estimated end time: 18:25

BR0001I ***********************___________________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA2\SR3_9\SR3.DATA9

BR0203I to sap/SSMBackup\bdvvgusw\SR3.DATA9 ...

#FILE..... E:\ORACLE\SSM\SAPDATA2\SR3_9\SR3.DATA9

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA9 #1/10

BR0280I BRBACKUP time stamp: 2007-08-01 16.33.24

BR0063I 10 of 22 files processed - 18420.078 MB of 36092.242 MB done

BR0204I Percentage done: 51.04%, estimated end time: 18:19

BR0001I **************************________________________

BR0280I BRBACKUP time stamp: 2007-08-01 16.33.25

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0280I BRBACKUP time stamp: 2007-08-01 16.33.26

BR0315I 'Alter tablespace PSAPSR3700 begin backup' successful

BR0202I Saving E:\ORACLE\SSM\SAPDATA3\SR3700_1\SR3700.DATA1

BR0203I to sap/SSMBackup\bdvvgusw\SR3700.DATA1 ...

#FILE..... E:\ORACLE\SSM\SAPDATA3\SR3700_1\SR3700.DATA1

#SAVED.... sap/SSMBackup\bdvvgusw\SR3700.DATA1 #1/11

BR0280I BRBACKUP time stamp: 2007-08-01 16.43.42

BR0063I 11 of 22 files processed - 20780.086 MB of 36092.242 MB done

BR0204I Percentage done: 57.57%, estimated end time: 18:12

BR0001I *****************************_____________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA3\SR3700_2\SR3700.DATA2

BR0203I to sap/SSMBackup\bdvvgusw\SR3700.DATA2 ...

#FILE..... E:\ORACLE\SSM\SAPDATA3\SR3700_2\SR3700.DATA2

#SAVED.... sap/SSMBackup\bdvvgusw\SR3700.DATA2 #1/12

BR0280I BRBACKUP time stamp: 2007-08-01 16.51.50

BR0063I 12 of 22 files processed - 23240.094 MB of 36092.242 MB done

BR0204I Percentage done: 64.39%, estimated end time: 18:02

BR0001I ********************************__________________

BR0202I Saving E:\ORACLE\SSM\SAPDATA3\SR3700_3\SR3700.DATA3

BR0203I to sap/SSMBackup\bdvvgusw\SR3700.DATA3 ...

#FILE..... E:\ORACLE\SSM\SAPDATA3\SR3700_3\SR3700.DATA3

#SAVED.... sap/SSMBackup\bdvvgusw\SR3700.DATA3 #1/13

BR0280I BRBACKUP time stamp: 2007-08-01 17.00.25

BR0063I 13 of 22 files processed - 25700.102 MB of 36092.242 MB done

BR0204I Percentage done: 71.21%, estimated end time: 17:55

BR0001I ************************************______________

BR0202I Saving E:\ORACLE\SSM\SAPDATA3\SR3700_4\SR3700.DATA4

BR0203I to sap/SSMBackup\bdvvgusw\SR3700.DATA4 ...

#FILE..... E:\ORACLE\SSM\SAPDATA3\SR3700_4\SR3700.DATA4

#SAVED.... sap/SSMBackup\bdvvgusw\SR3700.DATA4 #1/14

BR0280I BRBACKUP time stamp: 2007-08-01 17.07.49

BR0063I 14 of 22 files processed - 28050.109 MB of 36092.242 MB done

BR0204I Percentage done: 77.72%, estimated end time: 17:49

BR0001I ***************************************___________

BR0280I BRBACKUP time stamp: 2007-08-01 17.07.50

BR0317I 'Alter tablespace PSAPSR3700 end backup' successful

BR0280I BRBACKUP time stamp: 2007-08-01 17.07.50

BR0315I 'Alter tablespace PSAPSR3DB begin backup' successful

BR0202I Saving E:\ORACLE\SSM\SAPDATA4\SR3DB_1\SR3DB.DATA1

BR0203I to sap/SSMBackup\bdvvgusw\SR3DB.DATA1 ...

#FILE..... E:\ORACLE\SSM\SAPDATA4\SR3DB_1\SR3DB.DATA1

#SAVED.... sap/SSMBackup\bdvvgusw\SR3DB.DATA1 #1/15

BR0280I BRBACKUP time stamp: 2007-08-01 17.14.52

BR0063I 15 of 22 files processed - 30050.117 MB of 36092.242 MB done

BR0204I Percentage done: 83.26%, estimated end time: 17:45

BR0001I ******************************************________

BR0202I Saving E:\ORACLE\SSM\SAPDATA4\SR3DB_2\SR3DB.DATA2

BR0203I to sap/SSMBackup\bdvvgusw\SR3DB.DATA2 ...

#FILE..... E:\ORACLE\SSM\SAPDATA4\SR3DB_2\SR3DB.DATA2

#SAVED.... sap/SSMBackup\bdvvgusw\SR3DB.DATA2 #1/16

BR0280I BRBACKUP time stamp: 2007-08-01 17.20.37

BR0063I 16 of 22 files processed - 32050.125 MB of 36092.242 MB done

BR0204I Percentage done: 88.80%, estimated end time: 17:40

BR0001I ********************************************______

BR0202I Saving E:\ORACLE\SSM\SAPDATA4\SR3DB_3\SR3DB.DATA3

BR0203I to sap/SSMBackup\bdvvgusw\SR3DB.DATA3 ...

#FILE..... E:\ORACLE\SSM\SAPDATA4\SR3DB_3\SR3DB.DATA3

#SAVED.... sap/SSMBackup\bdvvgusw\SR3DB.DATA3 #1/17

BR0280I BRBACKUP time stamp: 2007-08-01 17.23.54

BR0063I 17 of 22 files processed - 33050.133 MB of 36092.242 MB done

BR0204I Percentage done: 91.57%, estimated end time: 17:38

BR0001I **********************************************____

BR0280I BRBACKUP time stamp: 2007-08-01 17.23.55

BR0317I 'Alter tablespace PSAPSR3DB end backup' successful

BR0280I BRBACKUP time stamp: 2007-08-01 17.23.55

BR0315I 'Alter tablespace PSAPSR3USR begin backup' successful

BR0202I Saving E:\ORACLE\SSM\SAPDATA4\SR3USR_1\SR3USR.DATA1

BR0203I to sap/SSMBackup\bdvvgusw\SR3USR.DATA1 ...

#FILE..... E:\ORACLE\SSM\SAPDATA4\SR3USR_1\SR3USR.DATA1

#SAVED.... sap/SSMBackup\bdvvgusw\SR3USR.DATA1 #1/18

BR0280I BRBACKUP time stamp: 2007-08-01 17.23.57

BR0063I 18 of 22 files processed - 33070.141 MB of 36092.242 MB done

BR0204I Percentage done: 91.63%, estimated end time: 17:38

BR0001I **********************************************____

BR0280I BRBACKUP time stamp: 2007-08-01 17.23.58

BR0317I 'Alter tablespace PSAPSR3USR end backup' successful

BR0280I BRBACKUP time stamp: 2007-08-01 17.23.58

BR0315I 'Alter tablespace PSAPUNDO begin backup' successful

BR0202I Saving E:\ORACLE\SSM\SAPDATA1\UNDO_1\UNDO.DATA1

BR0203I to sap/SSMBackup\bdvvgusw\UNDO.DATA1 ...

#FILE..... E:\ORACLE\SSM\SAPDATA1\UNDO_1\UNDO.DATA1

#SAVED.... sap/SSMBackup\bdvvgusw\UNDO.DATA1 #1/19

BR0280I BRBACKUP time stamp: 2007-08-01 17.30.05

BR0063I 19 of 22 files processed - 35430.148 MB of 36092.242 MB done

BR0204I Percentage done: 98.17%, estimated end time: 17:33

BR0001I *************************************************_

BR0280I BRBACKUP time stamp: 2007-08-01 17.30.05

BR0317I 'Alter tablespace PSAPUNDO end backup' successful

BR0280I BRBACKUP time stamp: 2007-08-01 17.30.06

BR0315I 'Alter tablespace SYSAUX begin backup' successful

BR0202I Saving E:\ORACLE\SSM\SAPDATA1\SYSAUX_1\SYSAUX.DATA1

BR0203I to sap/SSMBackup\bdvvgusw\SYSAUX.DATA1 ...

#FILE..... E:\ORACLE\SSM\SAPDATA1\SYSAUX_1\SYSAUX.DATA1

#SAVED.... sap/SSMBackup\bdvvgusw\SYSAUX.DATA1 #1/20

BR0280I BRBACKUP time stamp: 2007-08-01 17.30.45

BR0063I 20 of 22 files processed - 35630.156 MB of 36092.242 MB done

BR0204I Percentage done: 98.72%, estimated end time: 17:32

BR0001I *************************************************_

BR0280I BRBACKUP time stamp: 2007-08-01 17.30.45

BR0317I 'Alter tablespace SYSAUX end backup' successful

BR0280I BRBACKUP time stamp: 2007-08-01 17.30.46

BR0315I 'Alter tablespace SYSTEM begin backup' successful

BR0202I Saving E:\ORACLE\SSM\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

BR0203I to sap/SSMBackup\bdvvgusw\SYSTEM.DATA1 ...

#FILE..... E:\ORACLE\SSM\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

#SAVED.... sap/SSMBackup\bdvvgusw\SYSTEM.DATA1 #1/21

BR0280I BRBACKUP time stamp: 2007-08-01 17.31.51

BR0063I 21 of 22 files processed - 36080.164 MB of 36092.242 MB done

BR0204I Percentage done: 99.97%, estimated end time: 17:31

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2007-08-01 17.31.51

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0202I Saving H:\oracle\SSM\sapbackup\CNTRLSSM.DBF

BR0203I to sap/SSMBackup\bdvvgusw\CNTRLSSM.DBF ...

#FILE..... H:\oracle\SSM\sapbackup\CNTRLSSM.DBF

#SAVED.... sap/SSMBackup\bdvvgusw\CNTRLSSM.DBF #1/22

BR0280I BRBACKUP time stamp: 2007-08-01 17.31.53

BR0063I 22 of 22 files processed - 36092.242 MB of 36092.242 MB done

BR0204I Percentage done: 100.00%, estimated end time: 17:31

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2007-08-01 17.31.57

BR0340I Switching to next online redo log file for database instance SSM ...

BR0321I Switch to next online redo log file for database instance SSM successful

BR0117I ARCHIVE LOG LIST after backup for database instance SSM

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination H:\oracle\SSM\oraarch\SSMarch

Archive format ARC%S_%R.%T

Oldest online log sequence 448

Next log sequence to archive 451

Current log sequence 451 SCN: 4630171

Database block size 8192 Thread: 1

Current system change number 4630173 ResetId: 627493290

BR0202I Saving space_log

BR0203I to sap/SSMBackup\SSM ...

BR0202I Saving H:\oracle\SSM\sapbackup\bdvvgusw.ans

BR0203I to sap/SSMBackup\SSM ...

BR0202I Saving H:\oracle\SSM\sapbackup\backSSM.log

BR0203I to sap/SSMBackup\SSM ...

BR0056I End of database backup: bdvvgusw.ans 2007-08-01 17.31.59

BR0280I BRBACKUP time stamp: 2007-08-01 17.31.59

BR0053I BRBACKUP completed successfully with warnings

Thank you very much

regards

can we now have a complete listing of (ls -ltR) of the sap Backup dir of the linux box?

maybe your ftp-server is unhappy with all these \ in the path of the destination file.

example:

#SAVED.... sap/SSMBackup\bdvvgusw\SR3.DATA1

B3JOTZ~6 looks very much like those funy 8.3 compliant Windows Short Filenames.

If my feelings are right the backslashes are not identified as directory delimiter in the path.

In this case the filename looks something like SSMBackupbdvvguswSR3.DATA1.

If the ftp server is doing something like windows is doing during generating 8.3 filenames on NTFS it may result in those funny filenames.

you can test that manually (without DB13). If I am right you will have to read the ftp-servers documentation how to avoid this.

peter

Hi Peter,

thank you very much.

Is it may be possible to use other option in stage_copy_cmd instead of ftp?

I have tried with stage_copy_cmd = rcp without success.

We have still scp...

Perpahs some other settings in init<DBSID>.sap are responsible fot this issue?

And second question regarding path of the destination.

We have, as mentionde earlier, share "sap" on the Unix Side and have created extra share for the backup (sap/SSMbackup) or archive (sap/SSMArchive).

The problem is, that this path (sap/SSMbackup) will be ignored, and the files will be written directly one level up into the "sap" instead of "sap/SSMBackup".

Thank you very much for your further help/information

regards

Axel

rcp should work in theory (when the unix side is set up properly).

But the rcp client (rcp.exe) is not able to handle files bigger than 2 GB - no option withing SAP environment.

scp has no client on Windows.

you would have to install cygwin or similar tools to setup Unix compatible secure socket communication tools. maybe that it will work, but the setup is not trivial.

what kind of Unix you are running?

I samba an option?

peter

Hi Peter,

thank you!

We use SAMBA, it is a SAMBA-share that is accessible via FTP

Can it be FTP or SAMBA-problem, that the files names are wrong interpreted during the transfer from Windows to UNIX?

E.g. it is not possible to use in SAMBA user with "$" oder " _"?

Is there no possibilities to set up/change parameter in the init<DBSID>.sap-file?

What are the other options?

Thank you in advance.

regards

Ask a Question

Top Q&A Solution Author

User

Count