| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Creating a controlfile - language needed?
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
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
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
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Tuesday, October 04, 2005 1:02 PM
To: Brandon.Allen_at_OneNeck.com; oracledba.williams_at_gmail.com;
makbo_at_pacbell.net
Cc: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon
Sent: Tuesday, October 04, 2005 12:35 PM
To: oracledba.williams_at_gmail.com; makbo_at_pacbell.net
Cc: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]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-lReceived on Tue Oct 04 2005 - 12:14:56 CDT
 |
 |