Back up in db13

[Former Member]

Hi,

I want to schedule Full Database Online Backup + Redo Log using db13.

I am running EHP6 for SAP ECC6.0 on oracle 11.2.0.2 database.

Now by default I understand that DB13 will try to backup to a tape device whose path is found in init<SID>.ora.

I want to change this path so that I can back upto a folder on the local disk.

Which parameters do change in init<SID>.ora to achieve this?

[JPReyes]

Mainly you just need to change backup_dev_type to disk and point the backup_root_dir to the right path.

Regards, Juan

[Former Member]

Please find below, contents of my file initPRD.ora and advise. I can not find the said parameters.

###########################################################

#  (c)Copyright SAP AG, Walldorf                          #

# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/INITSIDBASE.ORA#2 $

###########################################################

###########################################################

# PART I, TUNING PARAMETERS                               #

###########################################################

#### SYSTEM GLOBAL AREA BUFFERS

# Total System Global Area = sum(bytes) of all caches

# Variable Size = shared_pool_size (approx.)

# Database Buffers = db_block_buffers * db_block_size

# Redo Buffers = log_buffer

#

# unit of shared_pool_size: bytes

# unit of db_block_buffers: number of cached blocks

# unit of log_buffer: bytes

shared_pool_size = 4936276377

# 10% of shared_pool_size

shared_pool_reserved_size = 493627637

log_buffer = 4096512

#### MANAGING SORTS

# A small sort requires sort_area_retained_size in

# memory. Larger sorts are allocating segments in

# PSAPTEMP. They are using sort_area_size in memory.

#sort_area_retained_size = 0

#sort_area_size = 2097152

#sort_spacemap_size = 512

#### PGA-PARAMETERS

open_cursors = 2000

#cursor_space_for_time =  true

#### LOCKS

# dml_locks = processes * 50

dml_locks = 4000

#enqueue_resources = 8000

#### CPU-PARAMETERS

#spin_count = 200

#_cpu_count = 4

#### TUNING ARCHIVING

#log_archive_buffer_size      127

#log_archive_buffers      4

#### USE VECTOR READ

#use_readv = true

#### OTHER TUNING PARAMETERS

#sequence_cache_entries = 100

#sequence_cache_hash_buckets = 89

###########################################################

# PART II, CHANGEABLE PARAMETERS                          #

###########################################################

#### CONTROL-FILES

# the controlfiles should be mirrored to every new

# database mount point @SAPDATA_HOME@/sapdata<#>

#control_files = @SAPDATA1@/cntrl/cntrlPRD.dbf @SAPDATA2@/cntrl/cntrlPRD.dbf @SAPDATA3@/cntrl/cntrlPRD.dbf

#### AUTOMATICLY STARTED BACKGROUND PROCESSES

#### MANAGING LOG SWITCHES

# checkpoints occur only when switching logs, if

# log_checkpoint_interval * size of OS blocks > size of

# the actual redo log

#log_checkpoint_interval = 0

#log_checkpoint_timeout = 0

#### PROCESS-PARAMETERS

# The number of allocated semaphores is equal to the

# number of processes

# sessions = 1.2 * processes

processes = 80

sessions  = 160

#### AUDITING AND STATISTICS

# sql_trace=TRUE

# audit_trail = true

# db_block_lru_extended_statistics = 1000

# db_block_lru_statistics = true

###########################################################

# PART III, STATIC PARAMETERS                             #

###########################################################

#### DB-NAME

db_name = PRD

#### DB-BLOCKSIZE

db_block_size = 8192

#### DB-FILES

#db_files = 254

#### OPTIMIZER MODE

#optimizer_mode = choose

#optimizer_search_limit = 3

#### PATHS / DESTINATIONS / TRACES

# F:\oracle\PRD\saptrace\background: trace files of the background

# processes

# F:\oracle\PRD\saptrace\usertrace:  trace files of the user processes

# log_archive_dest is a destination, not a path.

# The archivefiles get the name

# F:\oracle\PRD\oraarch\PRDarch<thread#>_<log#>

# log_archive_dest     = F:\oracle\PRD\oraarch\PRDarch

#log_archive_format  = %t_%s

#### OTHER

# reduce_alarm only supported on HP

#reduce_alarm = TRUE

#### ORACLE OPS PARAMETER

remote_os_authent = true

# retention time for RMAN backup information in control file

control_file_record_keep_time = 30

#see SAP note 124361

#db_file_multiblock_read_count = 8

log_checkpoints_to_alert = true

#### OPTIMIZER MODE

#optimizer_index_cost_adj = 10

#### AUDITING AND STATISTICS

#timed_statistics = true

compatible = 11.2.0

parallel_execution_message_size = 16384

query_rewrite_enabled = false

replication_dependency_tracking = false

star_transformation_enabled = true

log_archive_dest_1 = 'LOCATION=F:\oracle\PRD\oraarch\PRDarch'

log_archive_format = %t_%s_%r.dbf

undo_tablespace = PSAPUNDO

pga_aggregate_target = 629145600

db_cache_size = 4936276377

remote_login_passwordfile = exclusive

recyclebin = off

FILESYSTEMIO_OPTIONS = setall

diagnostic_dest = F:\oracle\PRD\saptrace

audit_file_dest = F:\oracle\PRD\saptrace\audit

_OPTIM_PEEK_USER_BINDS = FALSE

_OPTIMIZER_MJC_ENABLED = FALSE

_B_TREE_BITMAP_PLANS = FALSE

_INDEX_JOIN_ENABLED = FALSE

_IN_MEMORY_UNDO = FALSE

_SORT_ELIMINATION_COST_RATIO = 10

_TABLE_LOOKUP_PREFETCH_SIZE = 0

db_recovery_file_dest = F:\oracle\PRD\oraflash

db_recovery_file_dest_size = 30000M

max_dump_file_size = 20000

parallel_threads_per_cpu = 1

control_files = (E:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf, E:\oracle\PRD\origlogB\cntrl\cntrlPRD.dbf, F:\oracle\PRD\sapdata1\cntrl\cntrlPRD.dbf)

[JPReyes]

That is your DB parameter file (pfile) not your backup file.

You should be looking for init<SID>.sap

Regards, Juan

[Former Member]

Where is init<SID>.sap usually located.

[JPReyes]

in the same directory as the init<SID>.ora...

Now , this is plain basic stuff, please do some research before posting.

Regards, Juan

[Former Member]

Oracle 11.2.0.2 doesn't have it that location. Thats why I am asking my friend.

[JPReyes]

I run Oracle 11.2.0.3 and its there. Anyhow you can do a search for init*.sap on you server or simply copy the file from another SAP system and modify the entries. If its an upgraded database you can look for it in the old oracle home too.

Regards, Juan