Re: RMAN backups of SAP database

So now the Basis admin tells me that backup log is from a different database. He no longer has the log from the database where it causes problems. He has several hosts and RMAN runs just fine on all the others. Helps to get all the pertinent information. I told him it sounds more like a server/disk issue than anything to do with RMAN.

On Mon, Feb 24, 2020 at 10:13 AM Sandra Becker <sbecker6925_at_gmail.com> wrote:

> Thanks everyone for you suggestions and comments. I can tell you they are
> definitely using the version 7 style of backup where they "alter tablespace
> <tablespace_name> begin backup".
>
> Here are the RMAN configuration and backup script they are using. I'm
> trying to see if they still have the rman backup log from their last
> attempt.
>
> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
> CONFIGURE BACKUP OPTIMIZATION ON;
> CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
> CONFIGURE CONTROLFILE AUTOBACKUP OFF;
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; #
> default
> CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT
> "/backup_new/Backups/dgcs064/DB01/rman/full_ol_%t_s%s_s%p";
> CONFIGURE MAXSETSIZE TO UNLIMITED; # default
> CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
> CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
> CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE
> FOR LOAD TRUE;
> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
> CONFIGURE SNAPSHOT CONTROLFILE NAME TO
> '/oracle/DB01/112_64/dbs/snapcf_DB01.f'; # default
>
>
> RUN
> {
> set command id to 'ORCLOnlineBackupFull';
> ALLOCATE CHANNEL c1 DEVICE TYPE disk;
> ALLOCATE CHANNEL c2 DEVICE TYPE disk;
> ALLOCATE CHANNEL c3 DEVICE TYPE disk;
> ALLOCATE CHANNEL c4 DEVICE TYPE disk;
> backup AS BACKUPSET full database tag ORCL_FULL format
> '/backup_new/XXX_SAP_Backups/XXX/rman/XXX_%d_%T_%s_%p_FULL
> ' plus archivelog ;
> backup tag ORCL_CONTROL current controlfile format
> '/backup_new/XXX_Backups/XXX/rman/%d_%T_%s_%p_CONTROL'
> ;
> DELETE NOPROMPT OBSOLETE;
> release channel c1;
> release channel c2;
> release channel c3;
> release channel c4;
> }
>
> Backup log:
>
> ----------------------------------------------------------------------
> Running: online_backup_disk.ksh on xxxxxxxxxxxxx
> AS: oraXXX
> At: 20:00:02 on 02/15/2020
>
> backup processes = 0
> Starting RMAN...
>
> Recovery Manager: Release 11.2.0.4.0 - Production on Sat Feb 15 20:00:02
> 2020
>
> Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights
> reserved.
>
> connected to target database: XXX (DBID=3807154456)
> connected to recovery catalog database
>
> RMAN> RUN
> 2> {
> 3> set command id to 'ORCLOnlineBackupFull';
> 4> ALLOCATE CHANNEL c1 DEVICE TYPE disk;
> 5> ALLOCATE CHANNEL c2 DEVICE TYPE disk;
> 6> ALLOCATE CHANNEL c3 DEVICE TYPE disk;
> 7> ALLOCATE CHANNEL c4 DEVICE TYPE disk;
> 8> backup AS BACKUPSET full database tag ORCL_FULL format
> '/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/%d_%T_%s_%p_FU
> LL' plus archivelog ;
> 9> backup tag ORCL_CONTROL current controlfile format
> '/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/%d_%T_%s_%p_CONTRO
> L';
> 10> DELETE NOPROMPT OBSOLETE;
> 11> release channel c1;
> 12> release channel c2;
> 13> release channel c3;
> 14> release channel c4;
> 15>
> 16> }
> 17>
> executing command: SET COMMAND ID
>
> allocated channel: c1
> channel c1: SID=21 device type=DISK
>
> allocated channel: c2
> channel c2: SID=85 device type=DISK
>
> allocated channel: c3
> channel c3: SID=15 device type=DISK
>
> allocated channel: c4
> channel c4: SID=51 device type=DISK
>
>
> Starting backup at 15-FEB-20
> current log archived
> channel c1: starting archived log backup set
> channel c1: specifying archived log(s) in backup set
> input archived log thread=1 sequence=37962 RECID=18943 STAMP=1032307471
> input archived log thread=1 sequence=37963 RECID=18944 STAMP=1032327553
> input archived log thread=1 sequence=37964 RECID=18945 STAMP=1032355400
> channel c1: starting piece 1 at 15-FEB-20
> channel c2: starting archived log backup set
> channel c2: specifying archived log(s) in backup set
> input archived log thread=1 sequence=37965 RECID=18946 STAMP=1032382820
> input archived log thread=1 sequence=37966 RECID=18947 STAMP=1032393884
> input archived log thread=1 sequence=37967 RECID=18948 STAMP=1032415345
> channel c2: starting piece 1 at 15-FEB-20
> channel c3: starting archived log backup set
> channel c3: specifying archived log(s) in backup set
> input archived log thread=1 sequence=37968 RECID=18949 STAMP=1032420919
> input archived log thread=1 sequence=37969 RECID=18950 STAMP=1032426942
> input archived log thread=1 sequence=37970 RECID=18951 STAMP=1032433588
> channel c3: starting piece 1 at 15-FEB-20
> channel c4: starting archived log backup set
> channel c4: specifying archived log(s) in backup set
> input archived log thread=1 sequence=37971 RECID=18952 STAMP=1032438208
> input archived log thread=1 sequence=37972 RECID=18953 STAMP=1032458451
> input archived log thread=1 sequence=37973 RECID=18954 STAMP=1032466012
> channel c4: starting piece 1 at 15-FEB-20
> channel c1: finished piece 1 at 15-FEB-20
> piece
> handle=/oracle/XXX/oraflash/XXX/backupset/2020_02_15/o1_mf_annnn_TAG20200215T200656_h4jmv1t3_.bkp
> tag=TAG20200215T 200656
> comment=NONE
> channel c1: backup set complete, elapsed time: 00:00:10
> channel c2: finished piece 1 at 15-FEB-20
> piece
> handle=/oracle/XXX/oraflash/XXX/backupset/2020_02_15/o1_mf_annnn_TAG20200215T200656_h4jmv1vz_.bkp
> tag=TAG20200215T 200656
> comment=NONE
> channel c2: backup set complete, elapsed time: 00:00:10
> channel c3: finished piece 1 at 15-FEB-20
> piece
> handle=/oracle/XXX/oraflash/XXX/backupset/2020_02_15/o1_mf_annnn_TAG20200215T200656_h4jmv2lp_.bkp
> tag=TAG20200215T 200656
> comment=NONE
> channel c3: backup set complete, elapsed time: 00:00:09
> channel c4: finished piece 1 at 15-FEB-20
> piece
> handle=/oracle/XXX/oraflash/XXX/backupset/2020_02_15/o1_mf_annnn_TAG20200215T200656_h4jmv4w5_.bkp
> tag=TAG20200215T 200656
> comment=NONE
> channel c4: backup set complete, elapsed time: 00:00:07
> Finished backup at 15-FEB-20
>
> Starting backup at 15-FEB-20
> channel c1: starting full datafile backup set
> channel c1: specifying datafile(s) in backup set
> input datafile file number=00008 name=/oracle/XXX/yyyyyyy5/sr3_5/sr3.data5
> input datafile file number=00025
> name=/oracle/XXX/yyyyyyy2/sr3700_1/sr3700.data1
> input datafile file number=00034
> name=/oracle/XXX/yyyyyyy4/sr3_25/sr3.data25
> input datafile file number=00002
> name=/oracle/XXX/yyyyyyy1/sysaux_1/sysaux.data1
> input datafile file number=00003
> name=/oracle/XXX/yyyyyyy1/undo_1/undo.data1
> input datafile file number=00001
> name=/oracle/XXX/yyyyyyy1/system_1/system.data1
> input datafile file number=00037
> name=/oracle/XXX/yyyyyyy1/system_2/system.data2
> input datafile file number=00015
> name=/oracle/XXX/yyyyyyy2/sr3_12/sr3.data12
> channel c1: starting piece 1 at 15-FEB-20
> channel c2: starting full datafile backup set
> channel c2: specifying datafile(s) in backup set
> input datafile file number=00035
> name=/oracle/XXX/yyyyyyy5/sr3_26/sr3.data26
> input datafile file number=00031
> name=/oracle/XXX/yyyyyyy3/sr3_22/sr3.data22
> input datafile file number=00029
> name=/oracle/XXX/yyyyyyy2/sr3usr_1/sr3usr.data1
> input datafile file number=00026
> name=/oracle/XXX/yyyyyyy2/sr3700_2/sr3700.data2
> input datafile file number=00030
> name=/oracle/XXX/yyyyyyy2/vertex/vertex.data1
> input datafile file number=00027
> name=/oracle/XXX/yyyyyyy2/sr3fact_1/sr3fact.data1
> input datafile file number=00028
> name=/oracle/XXX/yyyyyyy2/sr3ods_1/sr3ods.data1
> input datafile file number=00036
> name=/oracle/XXX/yyyyyyy5/sr3_27/sr3.data27
> input datafile file number=00032
> name=/oracle/XXX/yyyyyyy5/sr3_23/sr3.data23
> input datafile file number=00033
> name=/oracle/XXX/yyyyyyy5/sr3_24/sr3.data24
> channel c2: starting piece 1 at 15-FEB-20
> channel c3: starting full datafile backup set
> channel c3: specifying datafile(s) in backup set
> input datafile file number=00013
> name=/oracle/XXX/yyyyyyy5/sr3_10/sr3.data10
> input datafile file number=00004 name=/oracle/XXX/yyyyyyy1/sr3_1/sr3.data1
> input datafile file number=00005 name=/oracle/XXX/yyyyyyy2/sr3_2/sr3.data2
> input datafile file number=00007 name=/oracle/XXX/yyyyyyy4/sr3_4/sr3.data4
> channel c3: starting piece 1 at 15-FEB-20
> channel c4: starting full datafile backup set
> channel c4: specifying datafile(s) in backup set
> input datafile file number=00018
> name=/oracle/XXX/yyyyyyy5/sr3_15/sr3.data15
> input datafile file number=00009 name=/oracle/XXX/yyyyyyy1/sr3_6/sr3.data6
> input datafile file number=00006 name=/oracle/XXX/yyyyyyy3/sr3_3/sr3.data3
> input datafile file number=00010 name=/oracle/XXX/yyyyyyy2/sr3_7/sr3.data7
> channel c4: starting piece 1 at 15-FEB-20
> channel c3: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200215_35698_1_FULL
> tag=ORCL_FULL comment=NONE
> channel c3: backup set complete, elapsed time: 11:02:29
> channel c3: starting full datafile backup set
> channel c3: specifying datafile(s) in backup set
> input datafile file number=00023
> name=/oracle/XXX/yyyyyyy5/sr3_20/sr3.data20
> input datafile file number=00012 name=/oracle/XXX/yyyyyyy4/sr3_9/sr3.data9
> input datafile file number=00014
> name=/oracle/XXX/yyyyyyy1/sr3_11/sr3.data11
> input datafile file number=00011 name=/oracle/XXX/yyyyyyy3/sr3_8/sr3.data8
> channel c3: starting piece 1 at 16-FEB-20
> channel c4: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200215_35699_1_FULL
> tag=ORCL_FULL comment=NONE
> channel c4: backup set complete, elapsed time: 11:08:38
> channel c4: starting full datafile backup set
> channel c4: specifying datafile(s) in backup set
> input datafile file number=00017
> name=/oracle/XXX/yyyyyyy4/sr3_14/sr3.data14
> input datafile file number=00019
> name=/oracle/XXX/yyyyyyy1/sr3_16/sr3.data16
> input datafile file number=00016
> name=/oracle/XXX/yyyyyyy3/sr3_13/sr3.data13
> input datafile file number=00020
> name=/oracle/XXX/yyyyyyy2/sr3_17/sr3.data17
> channel c4: starting piece 1 at 16-FEB-20
> channel c1: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200215_35696_1_FULL
> tag=ORCL_FULL comment=NONE
> channel c1: backup set complete, elapsed time: 20:00:10
> channel c1: starting full datafile backup set
> channel c1: specifying datafile(s) in backup set
> input datafile file number=00022
> name=/oracle/XXX/yyyyyyy4/sr3_19/sr3.data19
> input datafile file number=00024
> name=/oracle/XXX/yyyyyyy1/sr3_21/sr3.data21
> input datafile file number=00021
> name=/oracle/XXX/yyyyyyy3/sr3_18/sr3.data18
> channel c1: starting piece 1 at 16-FEB-20
> channel c2: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200215_35697_1_FULL
> tag=ORCL_FULL comment=NONE
> channel c2: backup set complete, elapsed time: 20:19:31
> channel c2: starting full datafile backup set
> channel c2: specifying datafile(s) in backup set
> including current control file in backup set
> channel c2: starting piece 1 at 16-FEB-20
> channel c2: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200216_35703_1_FULL
> tag=ORCL_FULL comment=NONE
> channel c2: backup set complete, elapsed time: 00:00:35
> channel c2: starting full datafile backup set
> channel c2: specifying datafile(s) in backup set
> including current SPFILE in backup set
> channel c2: starting piece 1 at 16-FEB-20
> channel c2: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200216_35704_1_FULL
> tag=ORCL_FULL comment=NONE
> channel c2: backup set complete, elapsed time: 00:00:45
> channel c3: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200216_35700_1_FULL
> tag=ORCL_FULL comment=NONE
> channel c3: backup set complete, elapsed time: 09:34:04
> channel c4: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200216_35701_1_FULL
> tag=ORCL_FULL comment=NONE
> channel c4: backup set complete, elapsed time: 09:33:36
> channel c1: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200216_35702_1_FULL
> tag=ORCL_FULL comment=NONE
> channel c1: backup set complete, elapsed time: 02:54:09
> Finished backup at 16-FEB-20
>
> Starting backup at 16-FEB-20
> current log archived
> channel c1: starting archived log backup set
> channel c1: specifying archived log(s) in backup set
> input archived log thread=1 sequence=37974 RECID=18955 STAMP=1032496773
> channel c1: starting piece 1 at 16-FEB-20
> channel c2: starting archived log backup set
> channel c2: specifying archived log(s) in backup set
> input archived log thread=1 sequence=37975 RECID=18956 STAMP=1032532861
> channel c2: starting piece 1 at 16-FEB-20
> channel c3: starting archived log backup set
> channel c3: specifying archived log(s) in backup set
> input archived log thread=1 sequence=37976 RECID=18957 STAMP=1032548784
> channel c3: starting piece 1 at 16-FEB-20
> channel c1: finished piece 1 at 16-FEB-20
> piece
> handle=/oracle/XXX/oraflash/XXX/backupset/2020_02_16/o1_mf_annnn_TAG20200216T192139_h4m5l6cj_.bkp
> tag=TAG20200216T 192139
> comment=NONE
> channel c1: backup set complete, elapsed time: 00:00:03
> channel c2: finished piece 1 at 16-FEB-20
> piece
> handle=/oracle/XXX/oraflash/XXX/backupset/2020_02_16/o1_mf_annnn_TAG20200216T192139_h4m5l6f5_.bkp
> tag=TAG20200216T 192139
> comment=NONE
> channel c2: backup set complete, elapsed time: 00:00:03
> channel c3: finished piece 1 at 16-FEB-20
> piece
> handle=/oracle/XXX/oraflash/XXX/backupset/2020_02_16/o1_mf_annnn_TAG20200216T192139_h4m5l7sx_.bkp
> tag=TAG20200216T 192139
> comment=NONE
> channel c3: backup set complete, elapsed time: 00:00:03
> Finished backup at 16-FEB-20
>
> Starting backup at 16-FEB-20
> channel c1: starting full datafile backup set
> channel c1: specifying datafile(s) in backup set
> including current control file in backup set
> channel c1: starting piece 1 at 16-FEB-20
> channel c1: finished piece 1 at 16-FEB-20
> piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200216_35708_1_CONTROL
> tag=ORCL_CONTROL comment=NONE
> channel c1: backup set complete, elapsed time: 00:00:01
> Finished backup at 16-FEB-20
>
> RMAN retention policy will be applied to the command
> RMAN retention policy is set to recovery window of 4 days
> Deleting the following obsolete backups and copies:
> Type Key Completion Time Filename/Handle
> -------------------- ------ ------------------ --------------------
> Control File Copy 24619 22-FEB-18
> /oracle/XXX/YYYreorg/sexwtcxc/cntrlXXX.old
> Control File Copy 24620 22-FEB-18
> /oracle/XXX/YYYreorg/sexwtcxc/cntrlXXX.new
> Control File Copy 24621 22-FEB-18
> /oracle/XXX/YYYreorg/sexwtnsl/cntrlXXX.old
> Control File Copy 24622 22-FEB-18
> /oracle/XXX/YYYreorg/sexwtnsl/cntrlXXX.new
> Control File Copy 24623 22-FEB-18
> /oracle/XXX/YYYreorg/sexwtthh/cntrlXXX.old
> Control File Copy 24624 22-FEB-18
> /oracle/XXX/YYYreorg/sexwtthh/cntrlXXX.new
> Control File Copy 24625 22-FEB-18
> /oracle/XXX/YYYreorg/sexwttjx/cntrlXXX.old
> Control File Copy 24626 22-FEB-18
> /oracle/XXX/YYYreorg/sexwttjx/cntrlXXX.new
> Control File Copy 24627 22-FEB-18
> /oracle/XXX/YYYreorg/sexwuasu/cntrlXXX.old
> Control File Copy 24628 22-FEB-18
> /oracle/XXX/YYYreorg/sexwuasu/cntrlXXX.new
> Control File Copy 24629 23-FEB-18
> /oracle/XXX/YYYreorg/sexwuqtu/cntrlXXX.old
> Control File Copy 24630 23-FEB-18
> /oracle/XXX/YYYreorg/sexwuqtu/cntrlXXX.new
> Control File Copy 24631 08-MAR-18
> /oracle/XXX/YYYreorg/sexzjthw/cntrlXXX.old
> Control File Copy 24632 08-MAR-18
> /oracle/XXX/YYYreorg/sexzjthw/cntrlXXX.new
> Control File Copy 24633 11-MAY-18 /tmp/control01.ctl
> Control File Copy 24634 14-MAY-18
> /oracle/XXX/112_64/dbs/snapcf_XXX.f
> Control File Copy 24635 22-APR-19
> /oracle/XXX/YYYreorg/sfaywtzs/cntrlXXX.old
> Control File Copy 24636 22-APR-19
> /oracle/XXX/YYYreorg/sfaywtzs/cntrlXXX.new
> Control File Copy 24637 22-APR-19
> /oracle/XXX/YYYreorg/sfaywukz/cntrlXXX.old
> Control File Copy 24638 22-APR-19
> /oracle/XXX/YYYreorg/sfaywukz/cntrlXXX.new
> Control File Copy 24639 26-SEP-19
> /oracle/XXX/YYYbackup/cntrlXXX.dbf
> Backup Set 3276340 02-FEB-20
> Backup Piece 3276351 02-FEB-20
> /backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200202_35669_1_FULL
> deleted backup piece
> backup piece
> handle=/backup_new/YYY_Backups/xxxxxxxxxxxxx/XXX/rman/XXX_20200202_35669_1_FULL
> RECID=23483 STAMP=103132361 4
> Deleted 1 objects
>
>
> RMAN-06207: WARNING: 21 objects could not be deleted for DISK channel(s)
> due
> RMAN-06208: to mismatched status. Use CROSSCHECK command to fix
> status
> RMAN-06210: List of Mismatched objects
> RMAN-06211: ==========================
> RMAN-06212: Object Type Filename/Handle
> RMAN-06213: ---------------
> ---------------------------------------------------
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwtcxc/cntrlXXX.old
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwtcxc/cntrlXXX.new
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwtnsl/cntrlXXX.old
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwtnsl/cntrlXXX.new
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwtthh/cntrlXXX.old
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwtthh/cntrlXXX.new
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwttjx/cntrlXXX.old
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwttjx/cntrlXXX.new
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwuasu/cntrlXXX.old
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwuasu/cntrlXXX.new
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwuqtu/cntrlXXX.old
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexwuqtu/cntrlXXX.new
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexzjthw/cntrlXXX.old
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sexzjthw/cntrlXXX.new
> RMAN-06214: Datafile Copy /tmp/control01.ctl
> RMAN-06214: Datafile Copy /oracle/XXX/112_64/dbs/snapcf_XXX.f
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sfaywtzs/cntrlXXX.old
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sfaywtzs/cntrlXXX.new
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sfaywukz/cntrlXXX.old
> RMAN-06214: Datafile Copy /oracle/XXX/YYYreorg/sfaywukz/cntrlXXX.new
> RMAN-06214: Datafile Copy /oracle/XXX/YYYbackup/cntrlXXX.dbf
>
>
> released channel: c1
>
> released channel: c2
>
> released channel: c3
>
> released channel: c4
>
> Recovery Manager complete.
>
> On Sun, Feb 23, 2020 at 9:15 PM Mladen Gogala <gogala.mladen_at_gmail.com>
> wrote:
>
>> BR*Tools do leave a log file and have several methods. One of them is
>> UTL_FILE, the other one is RMAN. UTL_FILE is basially, version 7 style
>> backup of files with the database in the backup mode. Another brbackup
>> method is RMAN, with some twists. BR*Tools can't utilize catalog. I wander
>> what method is used by BR*Tools. BR*Tools, as opposed to RMAN, can also
>> utilize snapshots. The phrase "SAP backup" doesn't mean much without the
>> exact configuration of brbackup. BR*backup is also backing up the SAP
>> configuration files, which are ignored by usual RMAN backups. SAP only
>> certifies BR*Tools for SAP R3 backup. RMAN backup is not certified. There
>> are many nuances here, and discussing BR*Tools without knowing the details
>> is pointless.
>> On 2/23/20 9:23 PM, Jack van Zanen wrote:
>>
>> First question: Can they prove it is your backup causing the Performance
>> issue. You may be on a wild goose chase
>>
>> Even SAP backups most likely leave a log file behind somewhere that
>> should tell you what the SAP backup is doing (is it actually making a
>> backup?) . Don't they use RMAN under the hood anyway?
>>
>> Regards
>>
>> Jack van Zanen
>>
>>
>> -------------------------
>> This e-mail and any attachments may contain confidential material for the
>> sole use of the intended recipient. If you are not the intended recipient,
>> please be aware that any disclosure, copying, distribution or use of this
>> e-mail or any attachment is prohibited. If you have received this e-mail in
>> error, please contact the sender and delete all copies.
>> Thank you for your cooperation
>>
>>
>> On Sat, Feb 22, 2020 at 6:22 AM Sandra Becker <sbecker6925_at_gmail.com>
>> wrote:
>>
>>> Oracle EE v11.2
>>>
>>> The Basis admin from another team has asked if I can help him find out
>>> why RMAN backups of his SAP database cause severe performance issues in the
>>> database with only two channels. Yet the SAP backup method runs with 6
>>> parallel processes in about 4-5 hours. I know nothing about how the SAP
>>> backups are configured and don't have access to any of that information, so
>>> I'm not sure you'll be able to provide much help to us. I do know the
>>> following:
>>>
>>> - they don't use ASM
>>> - all files are on the same NFS mount, including the datafiles,
>>> binaries, logs, audit files, etc.
>>> - archivelogs are kept for 3 days and written to another NFS mounted
>>> drive
>>> - SAP backup method uses 6 channels, backup completes in 4-5 hours
>>> - RMAN backup was set for 2 channels, backup tool over 12 hours and
>>> caused significant performance degradation (so I was told, I can't prove it)
>>>
>>> Any suggestions on what they should look at to see what's going on or
>>> adjustments they should look into? I've looked at their RMAN configuration
>>> and it's actually pretty close to what I use in my production databases,
>>> just minor differences for path names and the like.
>>>
>>> --
>>> Sandy B.
>>>
>>> --
>> Mladen Gogala
>> Database Consultant
>> Tel: (347) 321-1217
>>
>>
>
> --
> Sandy B.
>
>

-- 
Sandy B.

--
http://www.freelists.org/webpage/oracle-l