Skip to Content
0
Former Member
May 09, 2008 at 05:39 AM

DB12 last successful back up not available

468 Views

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

  1. @(#) $Id: //bas/700_REL/src/ccm/rsbr/initAIX.sap#5 $ SAP

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

  1. #

  2. SAP backup sample profile. #

  3. The parameter syntax is the same as for init.ora parameters. #

  4. Enclose parameter values which consist of more than one symbol in #

  5. double quotes. #

  6. After any symbol, parameter definition can be continued on the next #

  7. line. #

  8. A parameter value list should be enclosed in parentheses, the list #

  9. items should be delimited by commas. #

  10. There can be any number of white spaces (blanks, tabs and new lines) #

  11. between symbols in parameter definition. #

  12. #

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

  1. backup mode [all | all_data | full | incr | sap_dir | ora_dir

  2. | all_dir | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

  3. | <generic_path> | (<object_list>)]

  4. default: all

backup_mode = all

  1. restore mode [all | all_data | full | incr | incr_only | incr_full

  2. | incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

  3. | <generic_path> | (<object_list>) | partial | non_db

  4. redirection with '=' is not supported here - use option '-m' instead

  5. default: all

restore_mode = all

  1. backup type [offline | offline_force | offline_standby | offline_split

  2. | offline_mirror | offline_stop | online | online_cons | online_split

  3. | online_mirror

  4. default: offline

backup_type = online_cons

#backup_type = offline_force

  1. backup device type

  2. [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

  3. | disk_copy | disk_standby | stage | stage_copy | stage_standby

  4. | util_file | util_file_online | rman_util | rman_disk | rman_stage

  5. | rman_prep]

  6. default: tape

backup_dev_type = tape

#backup_dev_type = util_file

#backup_dev_type = util_file

  1. backup root directory [<path_name> | (<path_name_list>)]

  2. default: $SAPDATA_HOME/sapbackup

backup_root_dir = /oracle/BQS/sapbackup

  1. stage root directory [<path_name> | (<path_name_list>)]

  2. default: value of the backup_root_dir parameter

stage_root_dir = /oracle/BQS/sapbackup

  1. compression flag [no | yes | hardware | only]

  2. default: no

compress = no

  1. compress command

  2. first $-character is replaced by the source file name

  3. second $-character is replaced by the target file name

  4. <target_file_name> = <source_file_name>.Z

  5. for compress command the -c option must be set

  6. recommended setting for brbackup -k only run:

  7. "compress -b 12 -c $ > $"

  8. no default

compress_cmd = "compress -c $ > $"

  1. uncompress command

  2. first $-character is replaced by the source file name

  3. second $-character is replaced by the target file name

  4. <source_file_name> = <target_file_name>.Z

  5. for uncompress command the -c option must be set

  6. no default

uncompress_cmd = "uncompress -c $ > $"

  1. directory for compression [<path_name> | (<path_name_list>)]

  2. default: value of the backup_root_dir parameter

compress_dir = /oracle/BQS/sapreorg

  1. brarchive function [save | second_copy | double_save | save_delete

  2. | second_copy_delete | double_save_delete | copy_save

  3. | copy_delete_save | delete_saved | delete_copied]

  4. default: save

archive_function = save_delete

  1. directory for archive log copies to disk

  2. default: first value of the backup_root_dir parameter

archive_copy_dir = /oracle/BQS/saparch

  1. directory for archive log copies to stage

  2. default: first value of the stage_root_dir parameter

archive_stage_dir = /oracle/BQS/sapbackup

  1. delete archive logs from duplex destination [only | no | yes | check]

  2. default: only

  3. archive_dupl_del = only

  4. new sapdata home directory for disk_copy | disk_standby

  5. no default

  6. new_db_home = /oracle/C11

  7. stage sapdata home directory for stage_copy | stage_standby

  8. default: value of the new_db_home parameter

  9. stage_db_home = /oracle/C11

  10. original sapdata home directory for split mirror disk backup

  11. no default

  12. orig_db_home = /oracle/C11

  13. remote host name

  14. no default

  15. remote_host = <host_name>

  16. remote user name

  17. default: current operating system user

  18. remote_user = <user_name>

  19. tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_gnu

  20. rman_dd | rman_dd_gnu]

  21. default: cpio

tape_copy_cmd = dd

  1. disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu]

  2. default: copy

disk_copy_cmd = copy

  1. stage copy command [rcp | scp | ftp]

  2. default: rcp

stage_copy_cmd = rcp

  1. pipe copy command [rsh | ssh]

  2. default: rsh

pipe_copy_cmd = rsh

  1. flags for cpio output command

  2. default: -ovB

cpio_flags = -ovB

  1. flags for cpio input command

  2. default: -iuvB

cpio_in_flags = -iuvB

  1. flags for cpio command for copy of directories to disk

  2. default: -pdcu

  3. use flags -pdu for gnu tools

cpio_disk_flags = -pdcu

  1. flags for dd output command

  2. default: "obs=16k"

  3. recommended setting:

  4. Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"

  5. Windows: "bs=nk", example: "bs=64k"

dd_flags = "obs=64k bs=64k"

  1. flags for dd input command

  2. default: "ibs=16k"

  3. recommended setting:

  4. Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"

  5. Windows: "bs=nk", example: "bs=64k"

dd_in_flags = "ibs=64k bs=64k"

  1. number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]

  2. default: 1

saveset_members = 1

  1. additional parameters for RMAN

  2. rman_channels and rman_filesperset are only used when rman_util,

  3. rman_disk or rman_stage

  4. rman_channels defines the number of parallel sbt channel allocations

  5. rman_filesperset = 0 means:

  6. one file per save set - for non-incremental backups

  7. all files in one save set - for incremental backups

  8. the others have the same meaning as for native RMAN

  9. rman_channels = 1

  10. rman_filesperset = 0

  11. rman_maxpiecesize = 0 # in KB - former name rman_kbytes

  12. rman_rate = 0 # in KB - former name rman_readrate

  13. rman_maxopenfiles = 0

  14. rman_maxsetsize = 0 # in KB - former name rman_setsize

  15. additional parameters for RMAN version 8.1

  16. the parameters have the same meaning as for native RMAN

  17. rman_diskratio = 0 # deprecated in Oracle 10g

  18. rman_pool = 0

  19. rman_copies = 0 | 1 | 2 | 3 | 4 # former name rman_duplex

  20. rman_proxy = no | yes | only

  21. special parameters for an external backup library, example:

  22. rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"

  23. rman_send = "'<command>'"

  24. rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",

  25. "channel sbt_2 '<command2>' parms='<parameters2>'")

  26. remote copy-out command (backup_dev_type = pipe)

  27. $-character is replaced by current device address

  28. 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.