重启oracle数据库的一次操作命令和alter日志。

今天重启oracle数据库的命令和alter日志:

oracle@NMSSERVER1:~> sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 27 18:49:13 2016

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 5.1310E+10 bytes
Fixed Size 2240344 bytes
Variable Size 3.1407E+10 bytes
Database Buffers 1.9864E+10 bytes
Redo Buffers 36098048 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

日志:

Wed Jan 27 18:52:07 2016

opidcl aborting process unknown ospid (31681) as a result of ORA-2396

Wed Jan 27 18:52:07 2016

opidcl aborting process unknown ospid (40274) as a result of ORA-2396

Wed Jan 27 18:52:07 2016

opidcl aborting process unknown ospid (40174) as a result of ORA-2396

Wed Jan 27 18:52:07 2016

opidcl aborting process unknown ospid (53767) as a result of ORA-2396

Wed Jan 27 18:52:08 2016

opidcl aborting process unknown ospid (31415) as a result of ORA-2396

Wed Jan 27 18:52:06 2016

opidcl aborting process unknown ospid (55276) as a result of ORA-2396

Wed Jan 27 18:52:08 2016

opidcl aborting process unknown ospid (27878) as a result of ORA-2396

Wed Jan 27 18:52:08 2016

opidcl aborting process unknown ospid (24925) as a result of ORA-2396

Wed Jan 27 18:52:08 2016

opidcl aborting process unknown ospid (42658) as a result of ORA-2396

Wed Jan 27 18:52:08 2016

opidcl aborting process unknown ospid (61016) as a result of ORA-2396

Shutting down instance: further logons disabled

Wed Jan 27 18:52:12 2016

kkjcre1p: unable to spawn jobq slave process, slot 1, error 1089

kkjcre1p: unable to spawn jobq slave process, slot 1, error 1089

kkjcre1p: unable to spawn jobq slave process, slot 1, error 1089

Stopping background process CJQ0

Wed Jan 27 18:52:21 2016

Stopping background process QMNC

Stopping background process MMNL

Stopping background process MMON

License high water mark = 1509

Stopping Job queue slave processes, flags = 7

Job queue slave processes stopped

Wed Jan 27 18:55:00 2016

***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.3.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

Time: 27-JAN-2016 18:55:00

Tracing not turned on.

Tns error struct:

ns main err code: 12535

TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505

TNS-00505: Operation timed out

nt secondary err code: 110

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.25.110.39)(PORT=59810))

Wed Jan 27 18:57:24 2016

Active call for process 16334 user 'oracle' program 'oracle@NMSSERVER1'

SHUTDOWN: waiting for active calls to complete.

Wed Jan 27 18:58:00 2016

ALTER DATABASE CLOSE NORMAL

Wed Jan 27 18:58:37 2016

SMON: disabling tx recovery

SMON: disabling cache recovery

Wed Jan 27 18:58:44 2016

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Thread 1 closed at log sequence 72469

Successful close of redo thread 1

Wed Jan 27 19:00:28 2016

Completed: ALTER DATABASE CLOSE NORMAL

ALTER DATABASE DISMOUNT

Shutting down archive processes

Archiving is disabled

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Wed Jan 27 19:00:30 2016

Stopping background process VKTM

Wed Jan 27 19:00:51 2016

Instance shutdown complete

Wed Jan 27 19:01:08 2016

Starting ORACLE instance (normal)

Wed Jan 27 19:01:22 2016

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =499

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

ORACLE_HOME = /opt/oracle/app/oracle/product/11gR2/db

System name:    Linux

Node name:      NMSSERVER1

Release:        3.0.76-0.11-default

Version:        #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990)

Machine:        x86_64

Using parameter settings in server-side spfile /opt/oracle/app/oracle/product/11gR2/db/dbs/spfilepm4h.ora

System parameters with non-default values:

processes                = 3000

sessions                 = 4544

resource_limit           = TRUE

sga_max_size             = 48G

shared_pool_size         = 2G

sga_target               = 0

memory_target            = 48G

memory_max_target        = 48G

control_files            = "/oradata/db/pm/pm4h/control01.ctl"

control_files            = "/opt/oracle/app/oracle/fast_recovery_area/pm4h/control02.ctl"

db_block_size            = 8192

compatible               = "11.2.0.0.0"

db_files                 = 3000

db_recovery_file_dest    = "/opt/oracle/app/oracle/fast_recovery_area"

db_recovery_file_dest_size= 4G

undo_tablespace          = "UNDOTBS1"

recyclebin               = "OFF"

remote_login_passwordfile= "EXCLUSIVE"

db_domain                = ""

audit_file_dest          = "/opt/oracle/app/oracle/admin/pm4h/adump"

audit_trail              = "NONE"

db_name                  = "pm4h"

open_cursors             = 300

pga_aggregate_target     = 12G

diagnostic_dest          = "/opt/oracle/app/oracle"

Wed Jan 27 19:01:24 2016

PMON started with pid=2, OS id=55659

Wed Jan 27 19:01:24 2016

PSP0 started with pid=3, OS id=55661

Wed Jan 27 19:01:26 2016

VKTM started with pid=4, OS id=55670 at elevated priority

VKTM running at (1)millisec precision with DBRM quantum (100)ms

Wed Jan 27 19:01:26 2016

GEN0 started with pid=5, OS id=55674

Wed Jan 27 19:01:26 2016

DIAG started with pid=6, OS id=55676

Wed Jan 27 19:01:26 2016

DBRM started with pid=7, OS id=55678

Wed Jan 27 19:01:26 2016

DIA0 started with pid=8, OS id=55680

Wed Jan 27 19:01:26 2016

MMAN started with pid=9, OS id=55682

Wed Jan 27 19:01:26 2016

DBW0 started with pid=10, OS id=55684

Wed Jan 27 19:01:26 2016

DBW1 started with pid=11, OS id=55686

Wed Jan 27 19:01:26 2016

DBW2 started with pid=12, OS id=55688

Wed Jan 27 19:01:26 2016

DBW3 started with pid=13, OS id=55690

Wed Jan 27 19:01:26 2016

DBW4 started with pid=14, OS id=55692

Wed Jan 27 19:01:26 2016

DBW5 started with pid=15, OS id=55695

Wed Jan 27 19:01:26 2016

DBW6 started with pid=16, OS id=55697

Wed Jan 27 19:01:26 2016

DBW7 started with pid=17, OS id=55699

Wed Jan 27 19:01:26 2016

LGWR started with pid=18, OS id=55701

Wed Jan 27 19:01:26 2016

CKPT started with pid=19, OS id=55703

Wed Jan 27 19:01:26 2016

SMON started with pid=20, OS id=55705

Wed Jan 27 19:01:26 2016

RECO started with pid=21, OS id=55707

Wed Jan 27 19:01:26 2016

MMON started with pid=22, OS id=55709

Wed Jan 27 19:01:26 2016

MMNL started with pid=23, OS id=55711

ORACLE_BASE from environment = /opt/oracle/app/oracle

Wed Jan 27 19:01:26 2016

ALTER DATABASE   MOUNT

Successful mount of redo thread 1, with mount id 3936072072

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE   MOUNT

Wed Jan 27 19:01:32 2016

ALTER DATABASE OPEN

Thread 1 opened at log sequence 72469

Current log# 8 seq# 72469 mem# 0: /oradata/db/pm/pm4h/redo08.log

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

SMON: enabling cache recovery

[55762] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:2889332676 end:2889332876 diff:200 (2 seconds)

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is AL32UTF8

No Resource Manager plan active

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Wed Jan 27 19:01:37 2016

QMNC started with pid=25, OS id=55807

Completed: ALTER DATABASE OPEN

Wed Jan 27 19:01:39 2016

db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Wed Jan 27 19:01:39 2016

Starting background process CJQ0

Wed Jan 27 19:01:39 2016

CJQ0 started with pid=26, OS id=55838

上一篇:codeforces Codeforces 650A Watchmen


下一篇:P1361 小M的作物