Error while taking Offline backup through brbackup command

[former_member317957]

Hi

I m trying to take an offline backup , but unable to do so as facing error

Name                           Value

oracle_sid                     QAS

oracle_home                    /oracle/QAS/112_64

oracle_profile                 /oracle/QAS/112_64/dbs/initQAS.ora

sapdata_home                   /oracle/QAS

sap_profile                    /oracle/QAS/112_64/dbs/initQAS_offline.sap

backup_mode                    ALL

backup_type                    offline_force

backup_dev_type                util_file

util_par_file                  /oracle/QAS/112_64/dbs/initQAS_offline.utl

system_info                    oraqas/oraqas psapecqa AIX 1 6 00F6F90E4C00

oracle_info                    QAS 11.2.0.3.0 8192 4257 114069644 psapecqa UTF8 UTF8 2175825706

sap_info                       702 SAPQAS 0002LK0003QAS0011H10846256400015Maintenance_ORA

make_info                      rs6000_64 OCI_102 Mar  6 2010

command_line                   brbackup -p initQAS_offline.sap -u / -c -d util_file -t offline_force -m all

BR0116I ARCHIVE LOG LIST before backup for database instance QAS

Parameter                      Value

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /oracle/QAS/oraarch/QASarch

Archive format                 %t_%s_%r.dbf

Oldest online log sequence     4254

Next log sequence to archive   4257

Current log sequence           4257             SCN: 114069644

Database block size            8192             Thread: 1

Current system change number   114069660        ResetId: 788798876

.

BR0061I 115 files found for backup, total size 368448.908 MB

BR0143I Backup type: offline_force

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility at file level

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRBACKUP time stamp: 2012-10-10 19.59.16

BR0307I Shutting down database instance QAS ...

BR0278E Command output of '/oracle/QAS/112_64/bin/sqlplus /nolog < /oracle/QAS/sapbackup/.bejpykys.spi':

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 10 19:59:16 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> SQL> Connected.

SQL>

SQL> ORA-01013: user requested cancel of current operation

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

BR0280I BRBACKUP time stamp: 2012-10-10 20.59.18

BR0279E Return code from '/oracle/QAS/112_64/bin/sqlplus /nolog < /oracle/QAS/sapbackup/.bejpykys.spi': 0

BR0302E SQLPLUS call for database instance QAS failed

BR0309E Shutdown of database instance QAS failed

BR0056I End of database backup: bejpykys.aff 2012-10-10 20.59.18

BR0280I BRBACKUP time stamp: 2012-10-10 20.59.18

BR0054I BRBACKUP terminated with errors

pls help to solve the issue

regards

Rahul

[Former Member]

If an Oracle shutdown is taking that long, you should check which shutdown option is being used:

IMMEDIATE is recommended.

NORMAL will wait till all user processes are logged out. In case of a runnng SAP systen this may mean NEVER.

hope this helps

[Former Member]

As per log the database shutdown is taking more than 1 hr. See below -

BR0280I BRBACKUP time stamp: 2012-10-10 19.59.16

BR0280I BRBACKUP time stamp: 2012-10-10 20.59.18

Check note 618861

[former_member317957]

Hi Sunil

We are using oracle 11g version and taking backup through semantic software , which do nothing bt takes backup with respective BRTools only .

So I need to know is there is any problem with my SAP or Do i need to increase the log out time in my Semantic Offline backup Script , As per my script it logs out the session after 1 hour if System doest go Offline.

Kindly suggest

regards

Rahul

[Former Member]

Could you please paste the Semantic Offline backup Script contains?

There is no issue with your SAP or DB, but need to check why it is taking longer than expected to shutdown.

BTW - why you want to take offline backup and why can't you use the online backup with online_cons option?