BRARCHIVE LOGSHIPPING ERROR

[former_member215439]

Hi Experts,

          OS: WS2012R2

          DB: Oracle 12c

     How can i fix the error below:

BR0036I The current redolog sequence number 2 of database instance PRD is not gr

eater than the sequence number 201345 of the last saved offline redo log file

BR0031I Probably the redolog sequence number of database instance PRD was reset

BR0280I BRARCHIVE time stamp: 2015-09-30 15.24.18

BR0008I Offline redolog processing for database instance: PRD

BR0009I BRARCHIVE action ID: aernapui

BR0010I BRARCHIVE function ID: sve

BR0048I Archive function: save

BR0011I 1 offline redolog file found for processing, size 8.056 MB

BR0112I Files will not be compressed

BR0130I Backup device type: stage

BR0106I Files will be saved on disk in directory: SAPRD-POCDR:PRDarch/

BR0127I Fill volume option set - waiting for offline redolog files possible

BR0136I Verify option set - double work to do

BR0126I Unattended mode active - no operator confirmation required

BR0202I Saving init_ora

BR0203I to SAPRD-POCDR:PRDarch/\PRD ...

BR0278E Command output of 'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i

SAPRD-POCDR -u G:\oracle\PRD\saparch\.aernapui.ftp -a -c put E:\oracle\PRD\1210

2\database\initPRD.ora PRDarch/\PRD\initPRD.ora -c bin -c put E:\oracle\PRD\1210

2\database\spfilePRD.ora PRDarch/\PRD\spfilePRD.ora':

inifilename = D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\sapftp.ini

open Failed

Connect failed : NIECONN_REFUSED

BR0280I BRARCHIVE time stamp: 2015-09-30 15.24.21

BR0279E Return code from 'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i

SAPRD-POCDR -u G:\oracle\PRD\saparch\.aernapui.ftp -a -c put E:\oracle\PRD\12102

\database\initPRD.ora PRDarch/\PRD\initPRD.ora -c bin -c put E:\oracle\PRD\12102

\database\spfilePRD.ora PRDarch/\PRD\spfilePRD.ora': 1

BR0222E Copying init_ora to/from PRDarch/\PRD failed due to previous errors

BR0016I 0 offline redolog files processed, total size 0.000 MB

BR0007I End of offline redolog processing: aernapui.sve 2015-09-30 15.24.21

BR0280I BRARCHIVE time stamp: 2015-09-30 15.24.21

BR0005I BRARCHIVE terminated with errors

E:\oracle\PRD\12102\database>pause

Press any key to continue . . .

[JamesZ]

Hi James,

I can see "PRDarch/\PRD\initPRD.ora" this path looks like combination of linux and windows, so I would suspect it may be brtools bug, or wrongly maintained in brtools profile.

Please check if this path mentioned in brtools profile initPRD.sap. If not, please update brtools to the latest level and see if the problem gets solved.

Good luck.

James

[former_member215439]

Hi James,

our brtools version is already 7.20

[JamesZ]

Did you check brtools profile as mentioned?

okay, the brtools is 7.20, what about the patch level?

[former_member215439]

how can i check our brtools profile? do you mean init<SID>.sap?

patch level : 419

[JamesZ]

Yes, init<SID>.sap is the brtools profile.

Can you attach the complete brtools log to this discussion?

[former_member215439]

backup_mode = all

restore_mode = all

backup_type = online

backup_dev_type = stage

backup_root_dir = G:\backup

stage_root_dir = stage/

compress = no

compress_cmd = "D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\mkszip -c $ > $"

uncompress_cmd = "D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\uncompress -c $ > $"

compress_dir = G:\backup

archive_function = save

archive_copy_dir = G:\backup\archive

archive_stage_dir = PRDarch/

remote_host = SAPRD-POCDR

remote_user = prdadm

tape_copy_cmd = cpio

disk_copy_cmd = copy

stage_copy_cmd = ftp

pipe_copy_cmd = rsh

cpio_flags = -ovB

cpio_in_flags = -iuvB

cpio_disk_flags = -pdcu

dd_flags = "bs=64k"

dd_in_flags = "bs=64k"

saveset_members = 1

copy_in_cmd = "dd ibs=64k obs=8k if=$"

rewind = "mt -f $ rewind"

rewind_offline = "mt -f $ offline"

tape_pos_cmd = "mt -f $ fsf $"

tape_size = 100G

exec_parallel = 0

tape_address = /dev/nmt0

tape_address_rew = /dev/mt0

expir_period = 30

tape_use_count = 100

[JamesZ]

You can find below:

archive_stage_dir = PRDarch/

Do you think it is a windows path?

Why not PRDarch\?

Best regards,
James

[former_member215439]

Hi Sir James,

     I have change it to PRDarch\ but still not working.

I'm thinking that the main error here is in this line

BR0278E Command output of 'D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\sapftp.exe -v -n -i

SAPRD-POCDR -u G:\oracle\PRD\saparch\.aernapui.ftp -a -c put E:\oracle\PRD\1210

2\database\initPRD.ora PRDarch/\PRD\initPRD.ora -c bin -c put E:\oracle\PRD\1210

2\database\spfilePRD.ora PRDarch/\PRD\spfilePRD.ora':

inifilename = D:\usr\sap\PRD\SYS\exe\uc\NTAMD64\sapftp.ini

open Failed

[former_member215439]

PRDarch/ is working on our LIVE server.