on 06-05-2007 6:23 AM
Dear experts,
For the past one week suddenly my Offline backup from DB13 has stopped working. I havent change anything on my SAP server or Oracle but its not working.
First I checked DB13 logs. Last messages it is giving me is like as follows
=====================================================
BR148I DBVERIFY will be used for verification
BR134I Unattended mode with 'force' active - no operator confirmation allowed
BR370I Directory /oracle/CYP/sapbackup/bdvklqkj created
BR202I Saving init_ora
BR203I to /oracle/CYP/sapbackup/CYP ...
BR202I Saving /oracle/CYP/920_64/dbs/initCYP.sap
BR203I to /oracle/CYP/sapbackup/CYP ...
BR280I Time stamp 2007-06-05 03.00.07
BR198I Profiles saved successfully
BR280I Time stamp 2007-06-05 03.00.07
BR307I Shutting down database instance CYP ...
=============================================
when I checked my previous DB13 successful logs I saw that next message is
Shutdown of database instance CYP successful
Obviously it gave me idea that might be database was not closing out successfully. then I checked and compared my oracle alert logs but havent found very obvious changes their. Please check below messages of alert log. First set of messages are of successful backup and next set is of my recently failed backup
===================================================
ALTER DATABASE CLOSE NORMAL
Wed May 9 01:00:59 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed May 9 01:00:59 2007
Shutting down archive processes
Archiving is disabled
Wed May 9 01:00:59 2007
ARCH shutting down
Wed May 9 01:00:59 2007
ARCH shutting down
Wed May 9 01:00:59 2007
ARC0: Archival stopped
Wed May 9 01:00:59 2007
ARC1: Archival stopped
Wed May 9 01:01:00 2007
Thread 1 closed at log sequence 2209
Successful close of redo thread 1
Wed May 9 01:01:00 2007
Completed: ALTER DATABASE CLOSE NORMAL
Wed May 9 01:01:00 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
-
ALTER DATABASE CLOSE NORMAL
Tue Jun 5 03:00:42 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jun 5 03:00:43 2007
Shutting down archive processes
Archiving is disabled
Tue Jun 5 03:00:43 2007
ARCH shutting down
Tue Jun 5 03:00:43 2007
ARCH shutting down
ARC1: Archival stopped
Tue Jun 5 03:00:43 2007
ARC0: Archival stopped
Tue Jun 5 03:00:43 2007
Thread 1 closed at log sequence 2254
Successful close of redo thread 1
Tue Jun 5 03:00:43 2007
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jun 5 03:00:43 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
======================================================
I used to schedule backup at 3 AM but when I came to office next morning my oracle instacne was in idle mode. I checked ps -ef OS command and saw process of brbackup was still there and not a single byte had been taken as backup.
Please help me if you have any clue.
Best Regards
Waqas
if you use ECC6 and backup offline not work from DB13
please see note 988038 and 947331
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
do you have any <b>brbackup log</b> which might be of help...usually these can be found under /oracle/<SID>/sapbackup...
GreetZ, AH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
which log do you want
backCYP.log
or
bdvklqkj.afd log ( this is same is db13 logs)
backCYP.log is showing following
=======================================
bdvfimya afd 2007-05-09 01.00.48 2007-05-09 01.57.18 1 ............... 2
5 25 0 2209 2028063485 2209 2028063485 ALL
offline_force disk -
c 6.20 (113)
bdvjrtwh afd 2007-06-01 02.00.23 0000-00-00 00.00.00 6 ............... 2
5 0 0 2248 2104067221 0 0 ALL
offline_force disk -
c 6.20 (113)
bdvklqkj afd 2007-06-05 03.00.05 0000-00-00 00.00.00 6 ............... 2
5 0 0 2254 2114123006 0 0 ALL
offline_force disk -
dc 6.20 (113)
===================================
Regards
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.