Hi, i am having problem with backup in our quality system.
Orcale :10g
sap ecc6.0
we are taking online backup every monday, wednesday, thursday. DB12- last successful backup not available
overview of redo log files not yet backed up 300.
sapqas:orabqs 3> pwd
/oracle/BQS/102_64/dbs
sapqas:orabqs 4> ls
agent.lic initBQS.sap
dsmerror.log initBQS.sap.040107
hc_BQS.dat initBQS.sap.backup040407
init.ora initBQS.utl
initBQS.000 initBQS.utl.old
initBQS.001 initBQS2703.sap
initBQS.002 initdw.ora
initBQS.1.ora initoraBQS.bki.old
initBQS.2.ora initoraBQS.utl.old
initBQS.bki initorabqs.bki.old
initBQS.bki.cms initorabqs.utl.backup030407
initBQS.bki.old initorabqs.utl.old
initBQS.dba lkBQS
initBQS.ora orapwBQS
initBQS.ora.SAPINST-ORIG spfileBQS.ora
sapqas:orabqs 5> more initBQS.sap
@(#) $Id: //bas/700_REL/src/ccm/rsbr/initAIX.sap#5 $ SAP
########################################################################
#
SAP backup sample profile. #
The parameter syntax is the same as for init.ora parameters. #
Enclose parameter values which consist of more than one symbol in #
double quotes. #
After any symbol, parameter definition can be continued on the next #
line. #
A parameter value list should be enclosed in parentheses, the list #
items should be delimited by commas. #
There can be any number of white spaces (blanks, tabs and new lines) #
between symbols in parameter definition. #
#
########################################################################
backup mode [all | all_data | full | incr | sap_dir | ora_dir
| all_dir | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>)]
default: all
backup_mode = all
restore mode [all | all_data | full | incr | incr_only | incr_full
| incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>) | partial | non_db
redirection with '=' is not supported here - use option '-m' instead
default: all
restore_mode = all
backup type [offline | offline_force | offline_standby | offline_split
| offline_mirror | offline_stop | online | online_cons | online_split
| online_mirror
default: offline
backup_type = online_cons
#backup_type = offline_force
backup device type
[tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk
| disk_copy | disk_standby | stage | stage_copy | stage_standby
| util_file | util_file_online | rman_util | rman_disk | rman_stage
| rman_prep]
default: tape
backup_dev_type = tape
#backup_dev_type = util_file
#backup_dev_type = util_file
backup root directory [<path_name> | (<path_name_list>)]
default: $SAPDATA_HOME/sapbackup
backup_root_dir = /oracle/BQS/sapbackup
stage root directory [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter
stage_root_dir = /oracle/BQS/sapbackup
compression flag [no | yes | hardware | only]
default: no
compress = no
compress command
first $-character is replaced by the source file name
second $-character is replaced by the target file name
<target_file_name> = <source_file_name>.Z
for compress command the -c option must be set
recommended setting for brbackup -k only run:
"compress -b 12 -c $ > $"
no default
compress_cmd = "compress -c $ > $"
uncompress command
first $-character is replaced by the source file name
second $-character is replaced by the target file name
<source_file_name> = <target_file_name>.Z
for uncompress command the -c option must be set
no default
uncompress_cmd = "uncompress -c $ > $"
directory for compression [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter
compress_dir = /oracle/BQS/sapreorg
brarchive function [save | second_copy | double_save | save_delete
| second_copy_delete | double_save_delete | copy_save
| copy_delete_save | delete_saved | delete_copied]
default: save
archive_function = save_delete
directory for archive log copies to disk
default: first value of the backup_root_dir parameter
archive_copy_dir = /oracle/BQS/saparch
directory for archive log copies to stage
default: first value of the stage_root_dir parameter
archive_stage_dir = /oracle/BQS/sapbackup
delete archive logs from duplex destination [only | no | yes | check]
default: only
archive_dupl_del = only
new sapdata home directory for disk_copy | disk_standby
no default
new_db_home = /oracle/C11
stage sapdata home directory for stage_copy | stage_standby
default: value of the new_db_home parameter
stage_db_home = /oracle/C11
original sapdata home directory for split mirror disk backup
no default
orig_db_home = /oracle/C11
remote host name
no default
remote_host = <host_name>
remote user name
default: current operating system user
remote_user = <user_name>
tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_gnu
rman_dd | rman_dd_gnu]
default: cpio
tape_copy_cmd = dd
disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu]
default: copy
disk_copy_cmd = copy
stage copy command [rcp | scp | ftp]
default: rcp
stage_copy_cmd = rcp
pipe copy command [rsh | ssh]
default: rsh
pipe_copy_cmd = rsh
flags for cpio output command
default: -ovB
cpio_flags = -ovB
flags for cpio input command
default: -iuvB
cpio_in_flags = -iuvB
flags for cpio command for copy of directories to disk
default: -pdcu
use flags -pdu for gnu tools
cpio_disk_flags = -pdcu
flags for dd output command
default: "obs=16k"
recommended setting:
Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_flags = "obs=64k bs=64k"
flags for dd input command
default: "ibs=16k"
recommended setting:
Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_in_flags = "ibs=64k bs=64k"
number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]
default: 1
saveset_members = 1
additional parameters for RMAN
rman_channels and rman_filesperset are only used when rman_util,
rman_disk or rman_stage
rman_channels defines the number of parallel sbt channel allocations
rman_filesperset = 0 means:
one file per save set - for non-incremental backups
all files in one save set - for incremental backups
the others have the same meaning as for native RMAN
rman_channels = 1
rman_filesperset = 0
rman_maxpiecesize = 0 # in KB - former name rman_kbytes
rman_rate = 0 # in KB - former name rman_readrate
rman_maxopenfiles = 0
rman_maxsetsize = 0 # in KB - former name rman_setsize
additional parameters for RMAN version 8.1
the parameters have the same meaning as for native RMAN
rman_diskratio = 0 # deprecated in Oracle 10g
rman_pool = 0
rman_copies = 0 | 1 | 2 | 3 | 4 # former name rman_duplex
rman_proxy = no | yes | only
special parameters for an external backup library, example:
rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"
rman_send = "'<command>'"
rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",
"channel sbt_2 '<command2>' parms='<parameters2>'")
remote copy-out command (backup_dev_type = pipe)
$-character is replaced by current device address
no default
in oracle/sid/sapbackup folder i found one file bdxwbpsz.ant that was created on May 7th 2008( Wednesday)
plz check this:
sapqas:orabqs 21> more bdxwbpsz.ant
BR0051I BRBACKUP 7.00 (24)
BR0055I Start of database backup: bdxwbpsz.ant 2008-05-07 01.04.17
BR0484I BRBACKUP log file: /oracle/BQS/sapbackup/bdxwbpsz.ant
BR0477I Oracle pfile /oracle/BQS/102_64/dbs/initBQS.ora created from spfile /ora
cle/BQS/102_64/dbs/spfileBQS.ora
BR0280I BRBACKUP time stamp: 2008-05-07 01.04.18
BR0319I Control file copy created: /oracle/BQS/sapbackup/cntrlBQS.dbf 46383104
BR0101I Parameters
Name Value
oracle_sid BQS
oracle_home /oracle/BQS/102_64
oracle_profile /oracle/BQS/102_64/dbs/initBQS.ora
sapdata_home /oracle/BQS
sap_profile /oracle/BQS/102_64/dbs/initBQS.sap
backup_mode ALL
backup_type online
backup_dev_type tape
compress no
tape_copy_cmd dd
cpio_flags -ovB
cpio_in_flags -iuvB
dd_flags obs=64k bs=64k
dd_in_flags ibs=64k bs=64k
rewind tctl -f $ rewind
rewind_offline tctl -f $ offline
tape_size 307200.000 MB
tape_address /dev/rmt0.1
tape_address_rew /dev/rmt0
volume_backup BQSB29
expir_period 0
tape_use_count 100
exec_parallel 0
system_info bqsadm/orabqs sapqas AIX 3 5 00C0799E4C00
oracle_info BQS 10.2.0.2.0 8192 2370 485914644 sapqas WE8DEC
UTF8
sap_info 700 SAPSR3 0002LK0003BQS0011V18391775040013NetWea
ver_ORA
make_info rs6000_64 OCI_102 Mar 3 2007
command_line brbackup -u / -jid ALLOG20080507010416 -c force -
t online -m all -p initBQS.sap -v BQSB29 -a -c force -p initBQS.sap -sd
BR0116I ARCHIVE LOG LIST before backup for database instance BQS
Parameter Value
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/BQS/oraarch/BQSarch
Archive format %t_%s_%r.dbf
Oldest online log sequence 2367
Next log sequence to archive 2370
bdxwbpsz.ant (6%)
plz suggest how can I take online backup and redo log backup.