Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date
RE: Creating a controlfile - language needed?

To: <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <Brandon.Allen@xxxxxxxxxxx>, <oracledba.williams@xxxxxxxxx>, <makbo@xxxxxxxxxxx>
Date: Tue, 4 Oct 2005 13:11:52 -0400
I beg your pardon.  The following is from my alert log and is was a
"shutdown immediate":

Thu Sep 29 12:01:00 2005
Completed: ALTER DATABASE CLOSE NORMAL
Thu Sep 29 12:01:00 2005
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
Thu Sep 29 12:15:41 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 1
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
  processes                = 800
  timed_statistics         = TRUE
  resource_limit           = TRUE
  event                    = 10499 trace name context forever, level 10
  shared_pool_size         = 335544320
  sga_max_size             = 1058305200
  large_pool_size          = 33554432
  java_pool_size           = 67108864
  nls_date_format          = DD-MON-RRRR
  dbwr_io_slaves           = 6
  control_files            = /ora1/92/dbs/ctrl12.ctl,
/ora1/system/ctrl22.ctl, /ora1/archive/ctrl32.ctl
  db_block_size            = 8192
  db_cache_size            = 419430400
  compatible               = 9.2.0.0
  log_archive_start        = TRUE
  log_archive_dest         = 
  log_archive_dest_1       = LOCATION=/ora1/archive/oldarch/arch
  log_archive_dest_state_1 = ENABLE
  log_archive_max_processes= 2
  log_archive_format       = log2_%s.arc
  log_buffer               = 327680
  db_files                 = 500
  db_file_multiblock_read_count= 32
  fast_start_mttr_target   = 300
  dml_locks                = 500
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS
  undo_retention           = 21600
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = world
  global_names             = FALSE
  instance_name            = 02
  service_names            = linus2.world
  dispatchers              = (protocol=tcp)(disptachers=2)
  shared_servers           = 5
  mts_servers              = 5
  local_listener           = linus2
  utl_file_dir             = /ora1/local, /ora1/local/users
  job_queue_processes      = 2
  cursor_sharing           = SIMILAR
  background_dump_dest     = /ora1/92/rdbms/log
  user_dump_dest           = /ora1/92/rdbms/users
  max_dump_file_size       = 10240
  core_dump_dest           = /ora1/92/rdbms/core
  db_name                  = 02
  open_cursors             = 500
  pga_aggregate_target     = 67108864
Deprecated system parameters with specified values:
  mts_servers              
End of deprecated system parameter listing
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
CJQ0 started with pid=8
Thu Sep 29 12:15:49 2005
starting up 5 shared server(s) ...
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=15
ARC0: Archival started
ARC1 started with pid=16
Thu Sep 29 12:15:53 2005
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu Sep 29 12:15:53 2005
ARC1: Archival started
ARC1: Thread not mounted
Thu Sep 29 12:15:53 2005
ARC0: Thread not mounted
Thu Sep 29 12:15:54 2005
ALTER DATABASE   MOUNT
Thu Sep 29 12:16:00 2005
Successful mount of redo thread 1, with mount id 5766140
Thu Sep 29 12:16:00 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Thu Sep 29 12:16:01 2005
ALTER DATABASE OPEN
Thu Sep 29 12:16:03 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 12582
  Current log# 6 seq# 12582 mem# 0: /ora1/redo/log602.dbf
Successful open of redo thread 1
Thu Sep 29 12:16:03 2005
SMON: enabling cache recovery
Thu Sep 29 12:16:04 2005
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.
Thu Sep 29 12:16:04 2005
SMON: enabling tx recovery
Thu Sep 29 12:16:04 2005
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster
replication found)
Completed: ALTER DATABASE OPEN 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
Sent: Tuesday, October 04, 2005 1:02 PM
To: Brandon.Allen@xxxxxxxxxxx; oracledba.williams@xxxxxxxxx;
makbo@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Creating a controlfile - language needed?

Brandon,

Shutdown immediate is a controlled crash.

Do a shutdown immediate.  Then a startup.  Review the alert.log file.
Your will see a recovery takes place.

Compare this with a shutdown and a shutdown abort.

Simple test to see how it works.

Tom

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
Sent: Tuesday, October 04, 2005 12:35 PM
To: oracledba.williams@xxxxxxxxx; makbo@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Creating a controlfile - language needed?

From the referenced web page: "Do not shutdown abort or immediate as
these will require instance recovery."

Am I missing something, or is that statement incorrect?  I've never
heard of shutdown immediate requiring instance recovery.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Dennis Williams
Sent: Tuesday, October 04, 2005 9:02 AM

There are several documents on the web that describe this process, for
example:
http://www.jlcomp.demon.co.uk/faq/db_move.html.



Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither
given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Follow-Ups:

Re: Creating a controlfile - language needed?
From: Dennis Williams
RE: Creating a controlfile - language needed?

Other related posts:
