cancel
Showing results for 
Search instead for 
Did you mean: 

TSM Offline backup

Former Member
0 Kudos

Hi,

Using TSM we are taking online and offline backup for BI System.

For offline backup shutting down database it is taking so much of time. i could't find any log also. kindly help me resolve the issue.

kvl

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

look in alert_SID.log for starters.

Former Member
0 Kudos

Hi,

plz find alert log for that backup and kindly help me.

Tue Jan 5 13:00:03 2010

Beginning log switch checkpoint up to RBA [0x3c4d.2.10], SCN: 197966192

Thread 1 advanced to log sequence 15437

Current log# 1 seq# 15437 mem# 0: /oracle/KBP/origlogA/log_g11m1.dbf

Current log# 1 seq# 15437 mem# 1: /oracle/KBP/mirrlogA/log_g11m2.dbf

Tue Jan 5 13:05:07 2010

Completed checkpoint up to RBA [0x3c4d.2.10], SCN: 197966192

Tue Jan 5 13:11:47 2010

Shutting down instance: further logons disabled

Tue Jan 5 13:11:47 2010

Stopping background process CJQ0

Tue Jan 5 13:11:47 2010

Stopping background process QMNC

Tue Jan 5 13:11:51 2010

Stopping background process MMNL

Tue Jan 5 13:11:53 2010

Stopping background process MMON

Tue Jan 5 13:11:56 2010

Shutting down instance (immediate)

License high water mark = 61

Tue Jan 5 13:11:56 2010

Stopping Job queue slave processes

Tue Jan 5 13:11:56 2010

Job queue slave processes stopped

Tue Jan 5 13:12:01 2010

Process OS id : 671974 alive after kill

Errors in file

Tue Jan 5 13:13:26 2010

Process OS id : 1208496 alive after kill

Errors in file /oracle/KBP/saptrace/usertrace/kbp_ora_1192010.trc

Tue Jan 5 13:23:06 2010

Incremental checkpoint up to RBA [0x3c4d.908.0], current log tail at RBA [0x3c4d.908.0]

Tue Jan 5 13:31:56 2010

MMNL absent for 1224 secs; Foregrounds taking over

Tue Jan 5 13:53:08 2010

Incremental checkpoint up to RBA [0x3c4d.944.0], current log tail at RBA [0x3c4d.944.0]

Tue Jan 5 14:23:09 2010

Incremental checkpoint up to RBA [0x3c4d.9b2.0], current log tail at RBA [0x3c4d.9b2.0]

Tue Jan 5 14:53:11 2010

Incremental checkpoint up to RBA [0x3c4d.9fb.0], current log tail at RBA [0x3c4d.9fb.0]

Tue Jan 5 14:54:27 2010

Adjusting the default value of parameter parallel_max_servers

from 80 to 65 due to the value of parameter processes (80)

sculkget: failed to lock /oracle/KBP/102_64/dbs/lkinstKBP exclusive

sculkget: lock held by PID: 1192010

Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.

Failed to acquire instance startup/shutdown serialization primitive

Adjusting the default value of parameter parallel_max_servers

from 80 to 65 due to the value of parameter processes (80)

sculkget: failed to lock /oracle/KBP/102_64/dbs/lkinstKBP exclusive

sculkget: lock held by PID: 1192010

Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.

Failed to acquire instance startup/shutdown serialization primitive

Tue Jan 5 14:59:07 2010

ALTER DATABASE CLOSE NORMAL

Tue Jan 5 14:59:08 2010

SMON: disabling tx recovery

Tue Jan 5 14:59:29 2010

SMON: disabling cache recovery

Tue Jan 5 14:59:34 2010

Shutting down archive processes

Archiving is disabled

Tue Jan 5 14:59:39 2010

ARCH shutting down

ARC1: Archival stopped

Tue Jan 5 14:59:44 2010

ARCH shutting down

ARC0: Archival stopped

Tue Jan 5 14:59:49 2010

Thread 1 closed at log sequence 15437

Successful close of redo thread 1

Tue Jan 5 15:01:51 2010

Completed: ALTER DATABASE CLOSE NORMAL

Tue Jan 5 15:01:51 2010

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Tue Jan 5 15:02:46 2010

Adjusting the default value of parameter parallel_max_servers

from 80 to 65 due to the value of parameter processes (80)

sculkget: failed to lock /oracle/KBP/102_64/dbs/lkinstKBP exclusive

sculkget: lock held by PID: 1192010

Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.

Failed to acquire instance startup/shutdown serialization primitive

Tue Jan 5 15:03:32 2010

Starting ORACLE instance (normal)

Tue Jan 5 15:03:32 2010

Specified value of sga_max_size is too small, bumping to 2097152000

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.2.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 2097152000

shared_pool_size = 1023410176

shared_pool_reserved_size= 101468602

filesystemio_options = setall

control_files = /oracle/KBP/origlogA/cntrl/cntrlKBP.dbf, /oracle/KBP/origlogB/cntrl/cntrlKBP.dbf, /oracle/KBP/sapdata1/cntrl/cntrlKBP.dbf

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 1023410176

compatible = 10.2.0

log_archive_dest = /oracle/KBP/oraarch/KBParch

log_buffer = 14258176

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

replication_dependency_tracking= FALSE

undo_management = AUTO

undo_tablespace = PSAPUNDO

inmemory_undo = FALSE

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

job_queue_processes = 1

parallel_execution_message_size= 16384

tablelookup_prefetch_size= 0

background_dump_dest = /oracle/KBP/saptrace/background

user_dump_dest = /oracle/KBP/saptrace/usertrace

core_dump_dest = /oracle/KBP/saptrace/background

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = KBP

open_cursors = 800

sortelimination_cost_ratio= 10

btree_bitmap_plans = FALSE

star_transformation_enabled= true

query_rewrite_enabled = false

indexjoin_enabled = FALSE

optimpeek_user_binds = FALSE

pga_aggregate_target = 1352914698

optimizermjc_enabled = FALSE

PMON started with pid=2, OS id=622700

PSP0 started with pid=3, OS id=1073204

MMAN started with pid=4, OS id=1175770

DBW0 started with pid=5, OS id=1081526

LGWR started with pid=6, OS id=1126480

CKPT started with pid=7, OS id=770218

SMON started with pid=8, OS id=663756

RECO started with pid=9, OS id=1065186

CJQ0 started with pid=10, OS id=1134808

MMON started with pid=11, OS id=1007722

MMNL started with pid=12, OS id=823492

Tue Jan 5 15:03:33 2010

ALTER DATABASE MOUNT

Tue Jan 5 15:03:37 2010

Setting recovery target incarnation to 1

Tue Jan 5 15:03:37 2010

Successful mount of redo thread 1, with mount id 1907652293

Tue Jan 5 15:03:37 2010

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Tue Jan 5 15:03:37 2010

ALTER DATABASE OPEN

Tue Jan 5 15:03:37 2010

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=14, OS id=946262

Tue Jan 5 15:03:37 2010

ARC0: Archival started

ARC1: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

ARC1 started with pid=15, OS id=1200152

Tue Jan 5 15:03:37 2010

Thread 1 opened at log sequence 15437

Current log# 1 seq# 15437 mem# 0: /oracle/KBP/origlogA/log_g11m1.dbf

Current log# 1 seq# 15437 mem# 1: /oracle/KBP/mirrlogA/log_g11m2.dbf

Successful open of redo thread 1

Tue Jan 5 15:03:37 2010

ARC1: STARTING ARCH PROCESSES

Tue Jan 5 15:03:37 2010

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

Tue Jan 5 15:03:37 2010

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Tue Jan 5 15:03:37 2010

SMON: enabling cache recovery

Tue Jan 5 15:03:37 2010

ARC2: Archival started

ARC1: STARTING ARCH PROCESSES COMPLETE

ARC1: Becoming the heartbeat ARCH

ARC2 started with pid=16, OS id=1032298

Tue Jan 5 15:03:38 2010

Successfully onlined Undo Tablespace 1.

Tue Jan 5 15:03:38 2010

SMON: enabling tx recovery

Tue Jan 5 15:03:38 2010

Database Characterset is UTF8

Tue Jan 5 15:03:38 2010

Incremental checkpoint up to RBA [0x3c4d.a31.0], current log tail at RBA [0x3c4d.a53.0]

Tue Jan 5 15:03:39 2010

Starting background process QMNC

QMNC started with pid=18, OS id=1016006

Tue Jan 5 15:03:41 2010

Completed: ALTER DATABASE OPEN

Shutting down instance: further logons disabled

Tue Jan 5 15:03:49 2010

Stopping background process QMNC

Tue Jan 5 15:03:49 2010

Stopping background process CJQ0

Tue Jan 5 15:03:50 2010

Stopping background process MMNL

Tue Jan 5 15:03:51 2010

Stopping background process MMON

Tue Jan 5 15:03:52 2010

Shutting down instance (immediate)

License high water mark = 2

Tue Jan 5 15:03:52 2010

Stopping Job queue slave processes

Tue Jan 5 15:03:52 2010

Job queue slave processes stopped

Tue Jan 5 15:03:52 2010

ALTER DATABASE CLOSE NORMAL

Tue Jan 5 15:03:52 2010

SMON: disabling tx recovery

SMON: disabling cache recovery

Tue Jan 5 15:03:52 2010

Shutting down archive processes

Archiving is disabled

Tue Jan 5 15:03:57 2010

ARCH shutting down

ARC2: Archival stopped

Tue Jan 5 15:04:02 2010

ARCH shutting down

ARC1: Archival stopped

Tue Jan 5 15:04:07 2010

ARCH shutting down

ARC0: Archival stopped

Tue Jan 5 15:04:09 2010

Thread 1 closed at log sequence 15437

Successful close of redo thread 1

Tue Jan 5 15:04:09 2010

Completed: ALTER DATABASE CLOSE NORMAL

Tue Jan 5 15:04:09 2010

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Tue Jan 5 15:27:36 2010

Starting ORACLE instance (normal)

Tue Jan 5 15:27:36 2010

Specified value of sga_max_size is too small, bumping to 2097152000

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.2.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 2097152000

shared_pool_size = 1023410176

shared_pool_reserved_size= 101468602

filesystemio_options = setall

control_files = /oracle/KBP/origlogA/cntrl/cntrlKBP.dbf, /oracle/KBP/origlogB/cntrl/cntrlKBP.dbf, /oracle/KBP/sapdata1/cntrl/cntrlKBP.dbf

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 1023410176

compatible = 10.2.0

log_archive_dest = /oracle/KBP/oraarch/KBParch

log_buffer = 14258176

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

replication_dependency_tracking= FALSE

undo_management = AUTO

undo_tablespace = PSAPUNDO

inmemory_undo = FALSE

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

job_queue_processes = 1

parallel_execution_message_size= 16384

tablelookup_prefetch_size= 0

background_dump_dest = /oracle/KBP/saptrace/background

user_dump_dest = /oracle/KBP/saptrace/usertrace

core_dump_dest = /oracle/KBP/saptrace/background

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = KBP

open_cursors = 800

sortelimination_cost_ratio= 10

btree_bitmap_plans = FALSE

star_transformation_enabled= true

query_rewrite_enabled = false

indexjoin_enabled = FALSE

optimpeek_user_binds = FALSE

pga_aggregate_target = 1352914698

optimizermjc_enabled = FALSE

PSP0 started with pid=3, OS id=1122522

MMAN started with pid=4, OS id=1073338

PMON started with pid=2, OS id=1081416

DBW0 started with pid=5, OS id=1065000

LGWR started with pid=6, OS id=1024080

CKPT started with pid=7, OS id=1204372

SMON started with pid=8, OS id=1134808

RECO started with pid=9, OS id=1015982

CJQ0 started with pid=10, OS id=946386

MMON started with pid=11, OS id=1179826

MMNL started with pid=12, OS id=1192146

Tue Jan 5 15:27:41 2010

ALTER DATABASE MOUNT

Tue Jan 5 15:27:45 2010

Setting recovery target incarnation to 1

Tue Jan 5 15:27:46 2010

Successful mount of redo thread 1, with mount id 1907697773

Tue Jan 5 15:27:46 2010

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Tue Jan 5 15:27:46 2010

ALTER DATABASE OPEN

Tue Jan 5 15:27:46 2010

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=14, OS id=729190

ARC1 started with pid=15, OS id=725042

Tue Jan 5 15:27:46 2010

ARC0: Archival started

ARC1: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

Thread 1 opened at log sequence 15437

Current log# 1 seq# 15437 mem# 0: /oracle/KBP/origlogA/log_g11m1.dbf

Current log# 1 seq# 15437 mem# 1: /oracle/KBP/mirrlogA/log_g11m2.dbf

Successful open of redo thread 1

Tue Jan 5 15:27:46 2010

ARC0: STARTING ARCH PROCESSES

Tue Jan 5 15:27:46 2010

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Tue Jan 5 15:27:46 2010

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no SRL' ARCH

Tue Jan 5 15:27:46 2010

SMON: enabling cache recovery

Tue Jan 5 15:27:46 2010

ARC2: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

ARC0: Becoming the heartbeat ARCH

ARC2 started with pid=16, OS id=708842

Tue Jan 5 15:27:48 2010

Incremental checkpoint up to RBA [0x3c4d.e52.0], current log tail at RBA [0x3c4d.e52.0]

Tue Jan 5 15:27:49 2010

Successfully onlined Undo Tablespace 1.

Tue Jan 5 15:27:49 2010

SMON: enabling tx recovery

Tue Jan 5 15:27:49 2010

Database Characterset is UTF8

Starting background process QMNC

QMNC started with pid=18, OS id=663738

Tue Jan 5 15:27:54 2010

Completed: ALTER DATABASE OPEN

Tue Jan 5 15:28:46 2010

Shutting down archive processes

Tue Jan 5 15:28:51 2010

ARCH shutting down

ARC2: Archival stopped

Tue Jan 5 15:57:54 2010

Incremental checkpoint up to RBA [0x3c4d.db54.0], current log tail at RBA [0x3c4d.dc97.0]

Tue Jan 5 16:27:55 2010

kvl

Former Member
0 Kudos

Hi,

i am attaching usertrace log file plz kindly help me and can kill the belo mentioned process.

orakbp 651276 733324 0 13:11:51 - 0:01 oracleKBP (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

user trace

/oracle/KBP/saptrace/usertrace/kbp_ora_651276.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

ORACLE_HOME = /oracle/KBP/102_64

System name: AIX

Node name: sapbwpdb

Release: 3

Version: 5

Machine: 00CF4CAC4C00

Instance name: KBP

Redo thread mounted by this instance: 1

Oracle process number: 46

Unix process pid: 651276, image: oracle@sapbwpdb (TNS V1-V3)

      • 2010-01-12 13:12:04.114

      • SERVICE NAME:(SYS$USERS) 2010-01-12 13:12:04.100

      • SESSION ID:(44.12142) 2010-01-12 13:12:04.100

-


SO: 70000008c312808, type: 2, owner: 0, flag: -/-/-/0x00

(process) Oracle pid=16, calls cur/top: 0/0, flag: (0) -

int error: 1089, call error: 0, sess error: 0, txn error 0

(post info) last post received: 1089 8 12

last post received-location: ksusig

last process to post me: 70000008c321448 233 0

last post sent: 0 0 112

last post sent-location: kcbzww

last process posted by me: 70000008c314788 1 0

(latch info) wait_event=0 bits=0

O/S info: user: orakbp, term: UNKNOWN, ospid: 1097900

OSD pid info: Unix process pid: 1097900, image: oracleKBP@sapbwpdb

Short stack dump: unable to dump stack due to error 72

Dump of memory from 0x070000008C302808 to 0x070000008C302A10

70000008C302800 0000000F 00000000 [........]

70000008C302810 07000000 8C901118 00000010 0003139D [................]

70000008C302820 07000000 8C3C8898 00000003 0003139D [.....<..........]

70000008C302830 07000000 8C58A708 0000000B 0003139D [.....X..........]

70000008C302840 07000000 8C393318 00000004 00031291 [.....93.........]

Repeat 1 times

70000008C302860 07000000 8B750E08 00000007 0003139D [.....u..........]

70000008C302870 07000000 8B750EE8 00000007 0003139D [.....u..........]

70000008C302880 07000000 8B750FC8 00000007 0003139D [.....u..........]

70000008C302890 07000000 8B7535B0 00000007 0003139D [.....u5.........]

70000008C3028A0 07000000 8B7544A8 00000007 0003139D [.....uD.........]

70000008C3028B0 07000000 8B7561B8 00000007 0003139D [.....ua.........]

70000008C3028C0 07000000 8B756378 00000007 0003139D [.....ucx........]

70000008C3028D0 07000000 8B7567D8 00000007 0003139D [.....ug.........]

70000008C3028E0 07000000 8B7568B8 00000007 0003139D [.....uh.........]

70000008C3028F0 07000000 8B757190 00000007 0003139D [.....uq.........]

70000008C302900 00000000 00000000 00000000 00000000 [................]

Repeat 16 times

      • 2010-01-12 13:16:43.508

      • 2010-01-12 13:16:43.508 60639 kcrr.c

ARCH: Archival disabled due to shutdown: 1089

      • 2010-01-12 13:16:44.547 60639 kcrr.c

ARCH: Archival disabled due to shutdown: 1089

      • 2010-01-12 13:21:44.901

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 13:26:45.287

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 13:27:54.388

skgvtime: process 1134808 unix pid wrap detected 1262685459 1263283074

      • 2010-01-12 13:31:45.669

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 13:33:23.774

skgvtime: process 1179826 unix pid wrap detected 1262685459 1263283403

      • 2010-01-12 13:36:46.025

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 13:41:46.412

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 13:44:07.579

skgvtime: process 1015982 unix pid wrap detected 1262685459 1263284047

      • 2010-01-12 13:46:46.786

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 13:51:47.135

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 13:56:47.472

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:01:47.801

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:06:22.176

skgvtime: process 729190 unix pid wrap detected 1262685466 1263285382

      • 2010-01-12 14:06:48.218

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:08:54.397

skgvtime: process 1179826 unix pid wrap detected 1262685459 1263285534

      • 2010-01-12 14:11:48.619

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:16:48.970

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:19:59.222

skgvtime: process 725042 unix pid wrap detected 1262685466 1263286199

      • 2010-01-12 14:21:49.333

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:26:49.729

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:31:03.032

skgvtime: process 1122522 unix pid wrap detected 1262685458 1263286863

      • 2010-01-12 14:31:50.096

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:35:00.307

skgvtime: process 1065000 unix pid wrap detected 1262685459 1263287100

      • 2010-01-12 14:35:43.353

skgvtime: process 1134808 unix pid wrap detected 1262685459 1263287143

      • 2010-01-12 14:36:50.445

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:37:45.522

skgvtime: process 946386 unix pid wrap detected 1262685459 1263287265

      • 2010-01-12 14:41:50.816

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:46:51.150

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:50:52.410

skgvtime: process 1179826 unix pid wrap detected 1262685459 1263288052

      • 2010-01-12 14:51:51.462

SHUTDOWN: waiting for detached processes to terminate.

      • 2010-01-12 14:53:10.530

skgvtime: process 1134808 unix pid wrap detected 1262685459 1263288190

kvl

former_member204746
Active Contributor
0 Kudos

a process is till using Oracle. Find the culprit and you'll find your solution.

Former Member
0 Kudos

Hi,

The below process is running and it is not allowing to shutdown the database can i kill the process or not?

orakbp 651276 733324 0 13:11:51 - 0:01 oracleKBP (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) user

kvl

Former Member
0 Kudos

Hi,

Please tell me the timestamp of starttime of offline backup. Also, login into sql and hit a query and check if your database is up ot now.

Also, check the offline backup log( .aff) in sapbackup directory and check the timestamp of last entry in this log.

Can you calculate for how long there is no entry in this log ?

Regards,

Ankit

Former Member
0 Kudos

Hi,

Last entry in the .aff file was 13:11:50 Shutting down databse. and i have attched alert log and .trc file in the therad. kindly help me.

kvl

Former Member
0 Kudos

Hi,

Check the following steps :

1) check processess with PID : 671974 & 1208496 (ps -aef | grep 671974). What are these processess doing ?

2) check the running oracle processess (ps -aef | grep ora_). If ora_pmon process is running, we can kill it to close the oracle but after that you need to start the database and shutdown it manually for clean shutdown.

But I don't think it will start the backup then automatically. For the time, check the above processess as these might be using the oracle at the time of database shutdown.

Regards,

Ankit

Former Member
0 Kudos

Hi,

if i run ps -ef|gre ora_ it showing all the process like below

  1. ps -ef|grep ora_

orakbp 676092 1 0 Mar 15 - 0:00 ora_reco_KBP

orakbp 782546 1 0 Mar 15 - 0:05 ora_arc0_KBP

orakbp 835668 1 0 Mar 15 - 0:10 ora_arc1_KBP

orakbp 880788 1 0 Mar 15 - 0:54 ora_pmon_KBP

orakbp 1085454 1 0 Mar 15 - 0:05 ora_psp0_KBP

orakbp 1089672 1 0 Mar 15 - 0:28 ora_smon_KBP

orakbp 1114210 1 0 Mar 15 - 0:46 ora_ckpt_KBP

orakbp 1134692 1 0 Mar 15 - 0:21 ora_lgwr_KBP

root 1163494 1138938 0 14:07:06 pts/0 0:00 grep ora_

orakbp 1183884 1 0 Mar 15 - 0:19 ora_dbw0_KBP

orakbp 1192160 1 0 Mar 15 - 0:06 ora_mman_KBP

and if i check R3trans -d i am getting below message

sapbwpdb:kbpadm 1> R3trans -d

This is R3trans version 6.14 (release 700 - 05.03.09 - 08:28:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'KBP'"

R3trans finished (0012).

kindly help me

kvl

former_member204746
Active Contributor
0 Kudos

check if oracle listener is up.

also look in file tarns.log for more clues.

Former Member
0 Kudos

Thanx

oracle listener is running.

kvl

former_member204746
Active Contributor
0 Kudos

also look in file trans.log for more clues.