Archive log backup ending with warnings to remote disk.Provided all inputs

[Former Member]

Hi Experts ,

Plan is to take Archive log backup to remote disk

ex- Terminal A IDES planned oraarch backup to Terminal B

I have created a file in Terminal B & shared with full permissions.

file name- mbi_stg

I set the following parameters in initSID.sap

backup_type = offline

backup_dev_type = stage

compress = yes

archive_stage_dir = mbi_stg

remote_host = MBPROD

remote_user = "sidadm password" of source system that is IDES

& apparently when i say brarchive it is ending with following warnings.

The following is the log

C:\Documents and Settings\mbiadm>brarchive

BR0002I BRARCHIVE 7.00 (31)

BR0169I Value 'stage_copy' of parameter/option 'backup_dev_type/-d' ignored for

'brarchive' - 'stage' assumed

BR0169I Value 'rcp' of parameter/option 'stage_copy_cmd' ignored for 'compress/-

k yes' - 'ftp' assumed

BR0006I Start of offline redo log processing: adyxzoze.dsv 2008-10-01 16.55.18

BR0484I BRARCHIVE log file: E:\oracle\MBI\saparch\adyxzoze.dsv

BR0477I Oracle pfile E:\oracle\MBI\102\database\initMBI.ora created from spfile

E:\oracle\MBI\102\database\spfileMBI.ora

BR0613I Database instance MBI is shut down

BR0013W No offline redo log files found for processing

BR0007I End of offline redo log processing: adyxzoze.dsv 2008-10-01 16.55.21

BR0280I BRARCHIVE time stamp: 2008-10-01 16.55.22

BR0004I BRARCHIVE completed successfully with warnings

Cant get where im missing. Pls provide inputs.

[former_member204746 · Accepted solution]

in initSID.ora, look for parameter LOG_ARCHIVE_DEST or LOG_ARCHIVE_DEST_1.

check that this path exists and also check that there are indeed recent offline redo logs in this directory to back up.

[Former Member]

Hi Rahul, Actually in BRARCHIVE we can use this function to Copy, Delete, Save so that the log files are saved in two different TAPE place before they get deleted from Archive Directory.