Oracle-L: RE: Please look at this imp command

From: Wolfe Stephen S GS-11 6 MDSS/SGSI <Stephen.Wolfe_at_macdill.af.mil>
Date: Tue, 29 Jul 2003 09:34:30 -0800
Message-ID: <F001.005C7ACC.20030729093430@fatcity.com>

<INLINE>
<snip>
> Two things to check immediately:
>
> (1) Is the Oracle service defined as started automatically in
> the services?

Yes

> (2) If yes, is there any error reported in alert log of the database?

Compared line-by-line the last three starts and they seem identical, nothing unusual
in the last start. Anyway here is today's entries:

Tue Jul 29 03:44:39 2003
Thread 1 advanced to log sequence 73
  Current log# 1 seq# 73 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Tue Jul 29 03:45:00 2003
Thread 1 advanced to log sequence 74
  Current log# 2 seq# 74 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Tue Jul 29 03:45:31 2003
Thread 1 advanced to log sequence 75
  Current log# 3 seq# 75 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Dump file D:\oracle\admin\tpocs\bdump\tpocsALRT.LOG Tue Jul 29 05:31:23 2003
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586 Starting up ORACLE RDBMS Version: 9.0.1.1.1. System parameters with non-default values:

  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 50331648
  java_pool_size           = 33554432
  control_files            = D:\oracle\oradata\tpocs\control01.ctl,

D:\oracle\oradata\tpocs\control02.ctl,
D:\oracle\oradata\tpocs\control03.ctl

  db_block_size            = 4096
  db_cache_size            = 33554432
  compatible               = 9.0.0
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  instance_name            = tpocs
  background_dump_dest     = D:\oracle\admin\tpocs\bdump
  user_dump_dest           = D:\oracle\admin\tpocs\udump
  core_dump_dest           = D:\oracle\admin\tpocs\cdump
  sort_area_size           = 524288
  db_name                  = tpocs
  open_cursors             = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5

SMON started with pid=6
RECO started with pid=7
Tue Jul 29 05:31:26 2003
/* OracleOEM */ ALTER DATABASE MOUNT
Tue Jul 29 05:31:31 2003
Successful mount of redo thread 1, with mount id 1877649006. Tue Jul 29 05:31:31 2003
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT Tue Jul 29 05:31:31 2003
/* OracleOEM */ ALTER DATABASE OPEN
Tue Jul 29 05:31:32 2003
Beginning crash recovery of 1 threads
Tue Jul 29 05:31:33 2003
Started first pass scan
Tue Jul 29 05:31:33 2003
Completed first pass scan
Tue Jul 29 05:31:38 2003
Started recovery at
Thread 1: logseq 74, block 202409, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 2 Seq 74 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Recovery of Online Redo Log: Thread 1 Group 3 Seq 75 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Tue Jul 29 05:31:39 2003
Ended recovery at
Thread 1: logseq 75, block 18467, scn 0.2938502 3305 data blocks read, 3305 data blocks written, 20858 redo blocks read Crash recovery completed successfully
Tue Jul 29 05:31:40 2003
Thread 1 advanced to log sequence 76
Thread 1 opened at log sequence 76
Current log# 1 seq# 76 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Successful open of redo thread 1.
Tue Jul 29 05:31:40 2003
SMON: enabling cache recovery
Tue Jul 29 05:31:41 2003
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Jul 29 05:31:41 2003
SMON: enabling tx recovery
Tue Jul 29 05:31:43 2003
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN

> Import does not shut the database down.

I didn't think so.

I'm just wondering why when I rebooted the server the TPOCS instance did start, it is like
It didn't grab the InitTpocs.ora ...perplexed (but understandable when you are in the constant learn mode.

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe_at_macdill.af.mil
(813) 827-9974 DSN 651-9974

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: Stephen.Wolfe_at_macdill.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jul 29 2003 - 12:34:30 CDT