Control file backup is hung.

[Former Member]

Hi,

When I initiate control file backup it is struck. Pls. see my Rman configuration.

RMAN> show all;

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/rmanbkup/cf%F';

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/rmanbkup/%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/S01/102_64/dbs/snapcf_S01.f'; # default

RMAN> backup current controlfile;

Starting backup at 28-JUN-09

using channel ORA_DISK_1

It is in this situation since 4 Hrs.

I had set all the permissions as mentioned in the SAP Note : 113747. Backup was happening as normal till 25th June thru DB13.

My observation is, I had alter the oracle parameter as per the quiry results. ( i.e added the events .. I had executed the script attached in the S.Note : 1171650. ST04 --> Performance --> Additional Function --> SQL Command Editor )

O/S : AIX 5.3,

DB : Oracle 10.2.0.2.0

ECC 6.0

Backup in all other servers are happening without any problem..

I appreciate your expert suggestions.

Thanks!

Sundaresh Suryanarayan

[Former Member · Accepted solution]

Hi

Use below command

RMAN>BACKUP CURRENT CONTROLFILE FORMAT '%Path%';

RMAN> backup current controlfile ;nothing wrong in this but many times stuck why don't know

Regards

SurendraJain

[Former Member · Accepted solution]

Hi Surendra

RMAN> backup current controlfile format '%/oracle/rmanbkup/%';

Starting backup at 29-JUN-09

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

channel ORA_DISK_1: starting piece 1 at 29-JUN-09

--- it hangs here..

I terminated this with CTRL+ C after waiting for 20 min.

It is creating the file in the specified path..

-rw-r----- 1 oras01 dba 14417920 Jun 28 13:32 eqkindbq_1_1

-rw-r----- 1 oras01 dba 14417920 Jun 28 14:18 esking1l_1_1

-rw-r----- 1 oras01 dba 14417920 Jun 29 10:25 eukipmp9_1_1

Any more clues..

Thanks !

Sundaresh Suryanarayan

[Former Member · Accepted solution]

Hi

give without '% %' i used for placeholder only. give file name also

RMAN> backup current controlfile format '/oracle/rmanbkup/control.bak';

SurendraJain

Edited by: Surendrajain2003 on Jun 29, 2009 2:39 PM

[Former Member · Accepted solution]

Hi Surendara Jain,

Still this problem persisting.. I have tried all.. I checked all the relevent S-Notes. I updated the brtools version also..

Even if I execute BRBACKUP it starts.. It creates the folder. But, the folder will be empty.. Pls. see the *.and file below..

MBES01:oras01 10> more beayrvav.and

BR0051I BRBACKUP 7.00 (41)

BR0055I Start of database backup: beayrvav.and 2009-07-07 08.12.17

BR0484I BRBACKUP log file: /oracle/S01/sapbackup/beayrvav.and

BR0477I Oracle pfile /oracle/S01/102_64/dbs/initS01.ora created from spfile /oracle/S01/102_64/dbs/spfileS01.ora

BR0101I Parameters

Name Value

oracle_sid S01

oracle_home /oracle/S01/102_64

oracle_profile /oracle/S01/102_64/dbs/initS01.ora

sapdata_home /oracle/S01

sap_profile /oracle/S01/102_64/dbs/initS01.sap

backup_mode ALL

backup_type online

backup_dev_type disk

backup_root_dir /oracle/S01/sapbackup

compress no

disk_copy_cmd rman

cpio_disk_flags -pdcu

exec_parallel 0

rman_compress no

system_info oras01/oras01 MBES01 AIX 3 5 00CD16724C00

oracle_info S01 10.2.0.2.0 8192 2959 21202296 MBES01 UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003S010011E21297128880015Maintenance_ORA

make_info rs6000_64 OCI_102 Apr 8 2009

command_line /usr/sap/S01/SYS/exe/run/brbackup -p initS01.sap -d disk -t online -m all -k no -e 0 -o dist,time -l E -U

BR0116I ARCHIVE LOG LIST before backup for database instance S01

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/S01/oraarch/S01arch

Archive format %t_%s_%r.dbf

Oldest online log sequence 2956

Next log sequence to archive 2959

Current log sequence 2959 SCN: 21202296

Database block size 8192 Thread: 1

Current system change number 21209894 ResetId: 674792151

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type

MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_1/sr3.data1 2579505152 4 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_10/sr3.data10 1069555712 13 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_2/sr3.data2 2558533632 5 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_3/sr3.data3 3334479872 6 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_4/sr3.data4 3984596992 7 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_5/sr3.data5 3166707712 8 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_6/sr3.data6 2998935552 9 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_7/sr3.data7 2977964032 10 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_8/sr3.data8 2852134912 11 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_9/sr3.data9 2810191872 12 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/S01/sapdata3/sr3700_1/sr3700.data1 3523223552 14 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/S01/sapdata3/sr3700_2/sr3700.data2 4299169792 15 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/S01/sapdata3/sr3700_3/sr3700.data3 3607109632 16 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ /oracle/S01/sapdata3/sr3700_4/sr3700.data4 3428851712 17 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ /oracle/S01/sapdata4/sr3db_1/sr3db.data1 2097160192 19 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ /oracle/S01/sapdata4/sr3db_2/sr3db.data2 2097160192 20 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ /oracle/S01/sapdata4/sr3db_3/sr3db.data3 1048584192 21 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ /oracle/S01/sapdata4/sr3usr_1/sr3usr.data1 20979712 18 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ /oracle/S01/sapdata1/temp_1/temp.data1 1017126912 -1 3276802 NOLINK FILE 104

85760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ /oracle/S01/sapdata1/undo_1/undo.data1 2705334272 2 3276802 NOLINK FILE 104

85760000 20971520 8192

SYSAUX ONLINE* ONLINE+ /oracle/S01/sapdata1/sysaux_1/sysaux.data1 230694912 3 3276802 NOLINK FILE 104

85760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ /oracle/S01/sapdata1/system_1/system.data1 513810432 1 3276802 NOLINK FILE 104

85760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

/oracle/S01/origlogA/log_g11m1.dbf 52429312 1 3276802 INUSE NOLINK FILE

/oracle/S01/mirrlogA/log_g11m2.dbf 52429312 1 3276802 INUSE NOLINK FILE

/oracle/S01/origlogB/log_g12m1.dbf 52429312 2 3276802 INUSE NOLINK FILE

/oracle/S01/mirrlogB/log_g12m2.dbf 52429312 2 3276802 INUSE NOLINK FILE

/oracle/S01/origlogA/log_g13m1.dbf 52429312 3 3276802 INUSE NOLINK FILE

/oracle/S01/mirrlogA/log_g13m2.dbf 52429312 3 3276802 INUSE NOLINK FILE

/oracle/S01/origlogB/log_g14m1.dbf 52429312 4 3276802 INUSE NOLINK FILE

/oracle/S01/mirrlogB/log_g14m2.dbf 52429312 4 3276802 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

/oracle/S01/origlogA/cntrl/cntrlS01.dbf 14368768 0 3276802 NOLINK FILE

/oracle/S01/origlogB/cntrl/cntrlS01.dbf 14368768 0 3276802 NOLINK FILE

/oracle/S01/sapdata1/cntrl/cntrlS01.dbf 14368768 0 3276802 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0379I Distribution of files on volume #1:

Position Size Rate Compressed Duration Speed Name

[m:s] [MB/h]

1 2579505152* 2:19 63712 /oracle/S01/sapdata2/sr3_1/sr3.data1

2 1069555712* 0:59 62238 /oracle/S01/sapdata2/sr3_10/sr3.data10

3 2558533632* 2:19 63194 /oracle/S01/sapdata2/sr3_2/sr3.data2

4 3334479872* 2:48 68143 /oracle/S01/sapdata2/sr3_3/sr3.data3

5 3984596992* 3:19 68744 /oracle/S01/sapdata2/sr3_4/sr3.data4

6 3166707712* 2:49 64332 /oracle/S01/sapdata2/sr3_5/sr3.data5

7 2998935552* 2:38 65165 /oracle/S01/sapdata2/sr3_6/sr3.data6

8 2977964032* 2:39 64302 /oracle/S01/sapdata2/sr3_7/sr3.data7

9 2852134912* 2:28 66162 /oracle/S01/sapdata2/sr3_8/sr3.data8

10 2810191872* 2:29 64752 /oracle/S01/sapdata2/sr3_9/sr3.data9

11 3523223552* 2:49 71574 /oracle/S01/sapdata3/sr3700_1/sr3700.data1

12 4299169792* 3:38 67707 /oracle/S01/sapdata3/sr3700_2/sr3700.data2

13 3607109632* 3:09 65524 /oracle/S01/sapdata3/sr3700_3/sr3700.data3

14 3428851712* 2:48 70072 /oracle/S01/sapdata3/sr3700_4/sr3700.data4

15 2097160192* 1:59 60504 /oracle/S01/sapdata4/sr3db_1/sr3db.data1

16 2097160192* 1:58 61017 /oracle/S01/sapdata4/sr3db_2/sr3db.data2

17 1048584192* 0:59 61017 /oracle/S01/sapdata4/sr3db_3/sr3db.data3

18 20979712* 0:06 12005 /oracle/S01/sapdata4/sr3usr_1/sr3usr.data1

19 2705334272* 2:19 66820 /oracle/S01/sapdata1/undo_1/undo.data1

20 230694912* 0:19 41686 /oracle/S01/sapdata1/sysaux_1/sysaux.data1

21 513810432* 0:38 46422 /oracle/S01/sapdata1/system_1/system.data1

22 14368768 0:00 0* /oracle/S01/sapbackup/cntrlS01.dbf

Total: 51919052800* 45:29 65317

BR0284I BRBACKUP time stamp: 2009-07-07 08.12.19, elapsed time: 0:00

BR0057I Backup of database: S01

BR0058I BRBACKUP action ID: beayrvav

BR0059I BRBACKUP function ID: and

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/S01/sapbackup/cntrlS01.dbf

BR0061I 22 files found for backup, total size 49513.867 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: /oracle/S01/sapbackup/beayrvav

BR0284I BRBACKUP time stamp: 2009-07-07 08.12.19, elapsed time: 0:00

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

BR0284I BRBACKUP time stamp: 2009-07-07 08.12.54, elapsed time: 0:35

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0370I Directory /oracle/S01/sapbackup/beayrvav created

• end **************************************************

it won't move furthe after this.. I checked and compared SPFILE & init<SID>.sap with other servers (DEV,QA & PRD) all are same.. But, backup is happening on those server without any problem.

Can anybody help me on this..

Thanks!

Sundaresh Suryanarayan

[stefan_koehler]

Hello Sundaresh,

i had a similiar issue on a non sap oracle database (10.2.0.3).

Unfortunately you don't tell us on which event the RMAN session hangs. In my case some time ago the RMAN session hangs forever with the wait event "control file sequential read".

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/waitevents003.htm#sthref3001

Please verify the wait event with the view v$session, when you are executing the coontrolfile backup.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2088.htm#i1414383

Refering to metalinknote #820856.1 this could also occur on an oracle 10.2.0.2 database.

Btw. as a workaround (until a bugfix was available) i have set the "rule based" optimizer for rman backups.

Regards

Stefan

[sunny_pahuja2]

Hi,

check below link:

http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmtroub.htm#i1007239

Also, please check SAP note 830576 so that all parameters are set as per this note.

Hope it helps..

Thanks

Sunny

[Former Member]

Thanks Sunny,

I checked the parameter and even compared with our othe servers also. It looks ok. Regarding the Backup Job hanging situation, quiry did not gave any results, may be because I am backup up to harddisk not to tape.

I re-started the server.. it made little progress.. but, again it struck . pls. see the below output

RMAN> backup current controlfile;

Starting backup at 28-JUN-09

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=52 devtype=DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

channel ORA_DISK_1: starting piece 1 at 28-JUN-09

channel ORA_DISK_1: finished piece 1 at 28-JUN-09

piece handle=/oracle/rmanbkup/eqkindbq_1_1 tag=TAG20090628T133242 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

Finished backup at 28-JUN-09

Starting Control File and SPFILE Autobackup at 28-JUN-09

Any more hints.. Please..

Thanks!

Sundaresh Suryanarayan

[sunny_pahuja2]

Hi,

Please check SAP Note 1011731 - Long runtimes for RMAN backups with Oracle 10g...

For me it looks like problem with some wait events...

Thanks

Sunny

[Former Member]

Hi Sunny,

I changed the profile as per the S.Note : 1011731, and tried...still the problem persist..

Thanks!

Sundaresh Suryanarayan

[Former Member]

Hi Sunny,

Yes, you are right... Bull's eye.. problem was that.. I changed as per the S-Note : 1011731

Thanks!

Sundaresh Suryanarayan