Error BRARCHIVE stage for Oracle Standby Database

[Former Member]

Hi guys.

Iu00B4m testing the Oracle Standby Database Configuration for an SAP 4.7 with Oracle 9.2.

The Oracle Standby Database configuration is working OK.

But Iu00B4m presenting a problem with the script I'm doing to redolog offline copy of the primary server to server Disaster Recovery (DR), using the service

BRARCHIVE sapftp.exe. In the DR server is installed the FTP service.

Primary Server

server: host1

Oarcle: 9.2

OS: Windows Server 2003

SID: TVX

DR Server

server: host2

Oarcle: 9.2

OS: Windows Server 2003

SID: TVX

The script I'm setting up is as follows: brarchive.exe -u / -s -d stage -c -n 10

The file initTVX.sap primary server is configured as follows:

archive_function = save

archive_copy_dir = X:\oracle\TVX\sapbackup

archive_stage_dir = saparch

remote_host = host2

remote_user = "domain\tvxadm *password"

stage_copy_cmd = ftp

primary_db = TVX

The error log gives me the script is run:

BR0002I BRARCHIVE 6.40 (48)

BR0006I Start of offline redo log processing: aecvpflt.sve 2010-03-22 15.57.57

BR0484I BRARCHIVE log file: X:\oracle\TVX\saparch\aecvpflt.sve

BR0477I Oracle pfile X:\oracle\TVX\920\database\initTVX.ora created from spfile X:\oracle\TVX\920\database\spfileTVX.ora

BR0101I Parameters

Name Value

oracle_sid TVX

oracle_home X:\oracle\TVX\920

oracle_profile X:\oracle\TVX\920\database\initTVX.ora

sapdata_home X:\oracle\TVX

sap_profile X:\oracle\TVX\920\database\initTVX.sap

backup_dev_type stage

archive_stage_dir saparch

compress no

stage_copy_cmd ftp

remote_host host2

remote_user domain\tvxadm

system_info tvxadm HOST1 Windows 5.2 Build 3790 Service Pack 2 Intel

oracle_info TVX 9.2.0.7.0 8192 1006 49562112

sap_info 620 SAPTVX TVX R3_ORA

make_info NTintel OCI_920_SHARE Apr 2 2008

command_line brarchive -u system/******* -s -d stage -c -n 10

BR0038I Maximum number 10 of offline redo log files to be processed reached

BR0280I BRARCHIVE time stamp: 2010-03-22 15.58.00

BR0008I Offline redo log processing for database instance: TVX

BR0009I BRARCHIVE action ID: aecvpflt

BR0010I BRARCHIVE function ID: sve

BR0048I Archive function: save

BR0011I 10 offline redo log files found for processing, total size 499.984 MB

BR0112I Files will not be compressed

BR0130I Backup device type: stage

BR0106I Files will be saved on disk in directory: host2:saparch

BR0126I Unattended mode active - no operator confirmation required

BR0202I Saving init_ora

BR0203I to saparch\TVX ...

BR0278E Command output of 'X:\usr\sap\TVX\SYS\exe\run\sapftp.exe -v -n -i host2 -u X:\oracle\TVX\saparch\.aecvpflt.ftp -a -c put X:\oracle\TVX\920\database\initTVX.ora saparch\TVX\initTVX.ora -c bin -c put X:\oracle\TVX\920\database\spfileTVX.ora saparch\TVX\spfileTVX.ora':

Connected to host2 Port 21.

220 Microsoft FTP Service331 Password required for domain\tvxadm.230 User domain\tvxadm logged in.200 Type set to A.200 PORT command successful.550

saparch\TVX\initTVX.ora: Access is denied.

200 Type set to I.

200 PORT command successful.

550 saparch\TVX\spfileTVX.ora: Access is denied.

221

BR0280I BRARCHIVE time stamp: 2010-03-22 15.58.01

BR0279E Return code from 'X:\usr\sap\TVX\SYS\exe\run\sapftp.exe -v -n -i host2 -u X:\oracle\TVX\saparch\.aecvpflt.ftp -a -c put X:\oracle\TVX\920\database\initTVX.ora saparch\TVX\initTVX.ora -c bin -c put X:\oracle\TVX\920\database\spfileTVX.ora saparch\TVX\spfileTVX.ora': 0

BR0222E Copying init_ora to/from saparch\TVX failed due to previous errors

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0007I End of offline redo log processing: aecvpflt.sve 2010-03-22 15.58.01

BR0280I BRARCHIVE time stamp: 2010-03-22 15.58.01

BR0005I BRARCHIVE terminated with errors

I do not understand because when you connect via FTP gives me this error: 550 saparch\TVX\initTVX.ora: Access is denied, when this directory: saparch\TVX\initTVX.ora does not exist? I do not see why taking the ftp directory. Because both spfile and init file. are now located in the directory X:\oracle\TVX\920\database.

Thanks for your help guys

Desiru00E9e

Edited by: Desiru00E9e Cu00E1rdenas on Mar 23, 2010 2:33 AM

[Former Member]

Hi guys.

Iu00B4m testing the Oracle Standby Database Configuration for an SAP 4.7 with Oracle 9.2. The Oracle Standby Database configuration is working OK.

But Iu00B4m presenting a problem with the script I'm doing to redolog offline copy of the primary server to server Disaster Recovery (DR), using the service BRARCHIVE sapftp.exe. In the DR server is installed the FTP service.

Primary Server

server: host1

Oarcle: 9.2

OS: Windows Server 2003

SID: TVX

DR Server

server: host2

Oarcle: 9.2

OS: Windows Server 2003

SID: TVX

The script I'm setting up is as follows: brarchive.exe -u / -s -d stage -c -n 10

The file initTVX.sap primary server is configured as follows:

archive_function = save

archive_copy_dir = X:\oracle\TVX\sapbackup

archive_stage_dir = saparch

remote_host = host2

remote_user = "domain\tvxadm *password"

stage_copy_cmd = ftp

primary_db = TVX

The error log gives me the script is run:

BR0202I Saving init_ora

BR0203I to saparch\TVX ...

BR0278E Command output of 'X:\usr\sap\TVX\SYS\exe\run\sapftp.exe -v -n -i host2 -u X:\oracle\TVX\saparch\.aecvpflt.ftp -a -c put X:\oracle\TVX\920\database\initTVX.ora saparch\TVX\initTVX.ora -c bin -c put X:\oracle\TVX\920\database\spfileTVX.ora saparch\TVX\spfileTVX.ora': Connected to host2 Port 21.

220 Microsoft FTP Service

331 Password required for domain\tvxadm.

230 User domain\tvxadm logged in.

200 Type set to A.

200 PORT command successful.

550 saparch\TVX\initTVX.ora: Access is denied.

200 Type set to I.

200 PORT command successful.

550 saparch\TVX\spfileTVX.ora: Access is denied.

BR0280I BRARCHIVE time stamp: 2010-03-22 15.58.01

BR0279E Return code from 'X:\usr\sap\TVX\SYS\exe\run\sapftp.exe -v -n -i host2 -u X:\oracle\TVX\saparch\.aecvpflt.ftp -a -c put X:\oracle\TVX\920\database\initTVX.ora saparch\TVX\initTVX.ora -c bin -c put X:\oracle\TVX\920\database\spfileTVX.ora saparch\TVX\spfileTVX.ora': 0

BR0222E Copying init_ora to/from saparch\TVX failed due to previous errors

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0007I End of offline redo log processing: aecvpflt.sve 2010-03-22 15.58.01

BR0280I BRARCHIVE time stamp: 2010-03-22 15.58.01

BR0005I BRARCHIVE terminated with errors

I do not understand this directory saparch\TVX\initTVX.ora does not exist. I do not see why taking the ftp directory, because both spfile and init file are located in the directory X:\oracle\TVX\920\database.

Thanks for your help guys

Desiru00E9