Oracle Backup query

[former_member759680]

Hello,

I plan to take a full offline backup of my database using brtools.

I am not clear with 4 parameters of the 'initSID.sap' file.

backup_root_dir

archive_copy_dir

stage_root_dir

archive_stage_dir

I plan to take the backup in a separate filesystem '/sapbackup/SID/'

Kindly help me understand the significance of the above parameters.

Thanks.

[Former Member]

Hi

backup_root_dir

This is the parameter that is used only by BRBACKUP to identify the directories in which database backups to disk are performed.

Syntax

backup_root_dir = <dir>|(<dir_list>)

Default value: <SAPDATA_HOME>/sapbackup

archive_copy_dir

This parameter identifies the directory used by BRARCHIVE to back up the offline redo log files to a local disk.

Default: First value of the parameter backup_root_dir

Required value: A directory in which the offline redo log files should be archived.

stage_root_dir

This parameter identifies the directories used by BRBACKUP to back up database backups to a remote disk.

archive_stage_dir

This parameter identifies the directory used by BRARCHIVE to back up the offline redo log files to a remote disk.

Regards,

Sudip...