on 12-12-2008 10:47 AM
Dear Experts
Kindly go through the log and help me in resolving the issue.
I am getting getting some problems while doing homogeneous System copy through offline backup.
-
Fri Dec 12 16:13:21 IST 2008
LOGFILE FOR STARTING ORACLE
Trying to start XD3 database ...
-
Fri Dec 12 16:13:21 IST 2008
checking required environment variables
ORACLE_HOME is >/oracle/XD3/102_64<
ORACLE_SID is >XD3<
-
Fri Dec 12 16:13:21 IST 2008
check initora
-
Fri Dec 12 16:13:21 IST 2008
check initora
-
Fri Dec 12 16:13:21 IST 2008
checking V2 connect
TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 12-DEC-2008 16:13:21
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/usr/sap/XD3/SYS/profile/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = xidev3) (PORT = 1527))) (CONNECT_DATA = (SID
= XD3) (GLOBAL_NAME = XD3.WORLD)))
TNS-12541: TNS:no listener
V2 connect is not available. Terminating
/usr/sap/XD3/SYS/exe/run/startdb: Terminating with error code 14
~
~
~
~
~
~
~
"/home/xd3adm/startdb.log" 37 lines, 1116 characters
Hai,
Check whether your listener is running or not.
Try executing tnsping <SID> to check whether the connection is intact, also check file listener.log. Also see sqlnet.log for any possible errors.
Regards,
Yoganand.V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Yoganand.V,
TNS ping is happening.I can even able connect to database through third party tool.But when i am trying to start sap its giving error.
I am Posting the logs here kindly go through it.
Alert Log
Thu Dec 11 16:08:14 2008
Starting ORACLE instance (normal)
Thu Dec 11 16:08:15 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PSP0 started with pid=3, OS id=258250
PMON started with pid=2, OS id=286752
MMAN started with pid=4, OS id=299230
DBW0 started with pid=5, OS id=307350
LGWR started with pid=6, OS id=311448
CKPT started with pid=7, OS id=221376
SMON started with pid=8, OS id=315546
RECO started with pid=9, OS id=319644
CJQ0 started with pid=10, OS id=323742
MMON started with pid=11, OS id=327840
MMNL started with pid=12, OS id=331938
Thu Dec 11 16:08:48 2008
Shutting down instance: further logons disabled
Thu Dec 11 16:08:48 2008
Stopping background process CJQ0
Thu Dec 11 16:08:48 2008
Stopping background process MMNL
Thu Dec 11 16:08:50 2008
Stopping background process MMON
Thu Dec 11 16:08:51 2008
Shutting down instance (immediate)
License high water mark = 1
Thu Dec 11 16:08:51 2008
Stopping Job queue slave processes
Thu Dec 11 16:08:51 2008
Job queue slave processes stopped
Thu Dec 11 16:08:51 2008
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Thu Dec 11 16:09:08 2008
Starting ORACLE instance (normal)
Thu Dec 11 16:09:08 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=311450
PSP0 started with pid=3, OS id=307352
MMAN started with pid=4, OS id=299232
DBW0 started with pid=5, OS id=258252
LGWR started with pid=6, OS id=221378
CKPT started with pid=7, OS id=286754
SMON started with pid=8, OS id=327842
RECO started with pid=9, OS id=331940
CJQ0 started with pid=10, OS id=323744
MMON started with pid=11, OS id=204950
MMNL started with pid=12, OS id=303308
Thu Dec 11 16:09:08 2008
CREATE CONTROLFILE REUSE SET DATABASE "XD3" RESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 1022
MAXINSTANCES 50
MAXLOGHISTORY 11680
LOGFILE
GROUP 1 (
'/oracle/XD3/origlogA/log_g11m1.dbf',
'/oracle/XD3/mirrlogA/log_g11m2.dbf'
) SIZE 50M,
GROUP 2 (
'/oracle/XD3/origlogB/log_g12m1.dbf',
'/oracle/XD3/mirrlogB/log_g12m2.dbf'
) SIZE 50M,
GROUP 3 (
'/oracle/XD3/origlogA/log_g13m1.dbf',
'/oracle/XD3/mirrlogA/log_g13m2.dbf'
) SIZE 50M,
GROUP 4 (
'/oracle/XD3/origlogB/log_g14m1.dbf',
'/oracle/XD3/mirrlogB/log_g14m2.dbf'
) SIZE 50M
DATAFILE
'/oracle/XD3/sapdata1/system_1/system.data1',
'/oracle/XD3/sapdata3/undo_1/undo.data1',
'/oracle/XD3/sapdata1/sysaux_1/sysaux.data1',
'/oracle/XD3/sapdata1/sr3_1/sr3.data1',
'/oracle/XD3/sapdata1/sr3_2/sr3.data2',
'/oracle/XD3/sapdata1/sr3_3/sr3.data3',
'/oracle/XD3/sapdata1/sr3_4/sr3.data4',
'/oracle/XD3/sapdata1/sr3_5/sr3.data5',
'/oracle/XD3/sapdata2/sr3_6/sr3.data6',
'/oracle/XD3/sapdata2/sr3_7/sr3.data7',
'/oracle/XD3/sapdata2/sr3_8/sr3.data8',
'/oracle/XD3/sapdata2/sr3_9/sr3.data9',
'/oracle/XD3/sapdata2/sr3_10/sr3.data10',
'/oracle/XD3/sapdata3/sr3_11/sr3.data11',
'/oracle/XD3/sapdata3/sr3_12/sr3.data12',
'/oracle/XD3/sapdata3/sr3_13/sr3.data13',
'/oracle/XD3/sapdata3/sr3_14/sr3.data14',
'/oracle/XD3/sapdata3/sr3_15/sr3.data15',
'/oracle/XD3/sapdata4/sr3_16/sr3.data16',
'/oracle/XD3/sapdata4/sr3_17/sr3.data17',
'/oracle/XD3/sapdata4/sr3_18/sr3.data18',
'/oracle/XD3/sapdata4/sr3_19/sr3.data19',
'/oracle/XD3/sapdata4/sr3_20/sr3.data20',
'/oracle/XD3/sapdata1/sr3700_1/sr3700.data1',
'/oracle/XD3/sapdata1/sr3700_2/sr3700.data2',
'/oracle/XD3/sapdata1/sr3700_3/sr3700.data3',
'/oracle/XD3/sapdata1/sr3700_4/sr3700.data4',
'/oracle/XD3/sapdata2/sr3700_5/sr3700.data5',
'/oracle/XD3/sapdata2/sr3700_6/sr3700.data6',
'/oracle/XD3/sapdata2/sr3700_7/sr3700.data7',
'/oracle/XD3/sapdata2/sr3700_8/sr3700.data8',
'/oracle/XD3/sapdata3/sr3700_9/sr3700.data9',
'/oracle/XD3/sapdata3/sr3700_10/sr3700.data10',
'/oracle/XD3/sapdata3/sr3700_11/sr3700.data11',
'/oracle/XD3/sapdata3/sr3700_12/sr3700.data12',
'/oracle/XD3/sapdata4/sr3700_13/sr3700.data13',
'/oracle/XD3/sapdata4/sr3700_14/sr3700.data14',
'/oracle/XD3/sapdata4/sr3700_15/sr3700.data15',
'/oracle/XD3/sapdata4/sr3700_16/sr3700.data16',
'/oracle/XD3/sapdata1/sr3usr_1/sr3usr.data1',
'/oracle/XD3/sapdata1/system_2/system.data2'
Thu Dec 11 16:09:08 2008
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Thu Dec 11 16:09:14 2008
Successful mount of redo thread 1, with mount id 1063270116
Thu Dec 11 16:09:14 2008
Completed: CREATE CONTROLFILE REUSE SET DATABASE "XD3" RESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 1022
MAXINSTANCES 50
MAXLOGHISTORY 11680
LOGFILE
GROUP 1 (
'/oracle/XD3/origlogA/log_g11m1.dbf',
'/oracle/XD3/mirrlogA/log_g11m2.dbf'
) SIZE 50M,
GROUP 2 (
'/oracle/XD3/origlogB/log_g12m1.dbf',
'/oracle/XD3/mirrlogB/log_g12m2.dbf'
) SIZE 50M,
GROUP 3 (
'/oracle/XD3/origlogA/log_g13m1.dbf',
'/oracle/XD3/mirrlogA/log_g13m2.dbf'
) SIZE 50M,
GROUP 4 (
'/oracle/XD3/origlogB/log_g14m1.dbf',
'/oracle/XD3/mirrlogB/log_g14m2.dbf'
) SIZE 50M
DATAFILE
'/oracle/XD3/sapdata1/system_1/system.data1',
'/oracle/XD3/sapdata3/undo_1/undo.data1',
'/oracle/XD3/sapdata1/sysaux_1/sysaux.data1',
'/oracle/XD3/sapdata1/sr3_1/sr3.data1',
'/oracle/XD3/sapdata1/sr3_2/sr3.data2',
'/oracle/XD3/sapdata1/sr3_3/sr3.data3',
'/oracle/XD3/sapdata1/sr3_4/sr3.data4',
'/oracle/XD3/sapdata1/sr3_5/sr3.data5',
'/oracle/XD3/sapdata2/sr3_6/sr3.data6',
'/oracle/XD3/sapdata2/sr3_7/sr3.data7',
'/oracle/XD3/sapdata2/sr3_8/sr3.data8',
'/oracle/XD3/sapdata2/sr3_9/sr3.data9',
'/oracle/XD3/sapdata2/sr3_10/sr3.data10',
'/oracle/XD3/sapdata3/sr3_11/sr3.data11',
'/oracle/XD3/sapdata3/sr3_12/sr3.data12',
'/oracle/XD3/sapdata3/sr3_13/sr3.data13',
'/oracle/XD3/sapdata3/sr3_14/sr3.data14',
'/oracle/XD3/sapdata3/sr3_15/sr3.data15',
'/oracle/XD3/sapdata4/sr3_16/sr3.data16',
'/oracle/XD3/sapdata4/sr3_17/sr3.data17',
'/oracle/XD3/sapdata4/sr3_18/sr3.data18',
'/oracle/XD3/sapdata4/sr3_19/sr3.data19',
'/oracle/XD3/sapdata4/sr3_20/sr3.data20',
'/oracle/XD3/sapdata1/sr3700_1/sr3700.data1',
'/oracle/XD3/sapdata1/sr3700_2/sr3700.data2',
'/oracle/XD3/sapdata1/sr3700_3/sr3700.data3',
'/oracle/XD3/sapdata1/sr3700_4/sr3700.data4',
'/oracle/XD3/sapdata2/sr3700_5/sr3700.data5',
'/oracle/XD3/sapdata2/sr3700_6/sr3700.data6',
'/oracle/XD3/sapdata2/sr3700_7/sr3700.data7',
'/oracle/XD3/sapdata2/sr3700_8/sr3700.data8',
'/oracle/XD3/sapdata3/sr3700_9/sr3700.data9',
'/oracle/XD3/sapdata3/sr3700_10/sr3700.data10',
'/oracle/XD3/sapdata3/sr3700_11/sr3700.data11',
'/oracle/XD3/sapdata3/sr3700_12/sr3700.data12',
'/oracle/XD3/sapdata4/sr3700_13/sr3700.data13',
'/oracle/XD3/sapdata4/sr3700_14/sr3700.data14',
'/oracle/XD3/sapdata4/sr3700_15/sr3700.data15',
'/oracle/XD3/sapdata4/sr3700_16/sr3700.data16',
'/oracle/XD3/sapdata1/sr3usr_1/sr3usr.data1',
'/oracle/XD3/sapdata1/system_2/system.data2'
Thu Dec 11 16:10:25 2008
ALTER DATABASE RECOVER database using backup controlfile
Thu Dec 11 16:10:25 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile ...
Thu Dec 11 16:14:48 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Thu Dec 11 16:14:48 2008
Media Recovery Log /oracle/XD3/mirrlogB/log_g14m2.dbf
Errors with log /oracle/XD3/mirrlogB/log_g14m2.dbf
ORA-310 signalled during: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf' ...
Thu Dec 11 16:14:48 2008
ALTER DATABASE RECOVER CANCEL
Thu Dec 11 16:14:50 2008
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Thu Dec 11 16:34:44 2008
alter database recover continue default
Thu Dec 11 16:34:44 2008
Media Recovery failed with error 1112
ORA-283 signalled during: alter database recover continue default...
Thu Dec 11 16:35:10 2008
alter database recover until cancel using backup controlfile
Thu Dec 11 16:35:10 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: alter database recover until cancel using backup controlfile...
Thu Dec 11 16:35:20 2008
alter database recover continue default
Thu Dec 11 16:35:20 2008
Media Recovery Log /oracle/XD3/oraarch/XD3arch1_2591_1050596391.dbf
Errors with log /oracle/XD3/oraarch/XD3arch1_2591_1050596391.dbf
ORA-308 signalled during: alter database recover continue default...
Thu Dec 11 16:35:52 2008
alter database recover cancel
Thu Dec 11 16:35:53 2008
Media Recovery Canceled
Completed: alter database recover cancel
Thu Dec 11 16:36:06 2008
alter database open resetlogs
Thu Dec 11 16:36:06 2008
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
RESETLOGS after incomplete recovery UNTIL CHANGE 21473926
Thu Dec 11 16:36:20 2008
Setting recovery target incarnation to 2
Thu Dec 11 16:36:20 2008
Assigning activation ID 1063270116 (0x3f6036e4)
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=544778
Thu Dec 11 16:36:20 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=20, OS id=548876
Thu Dec 11 16:36:21 2008
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /oracle/XD3/origlogA/log_g13m1.dbf
Current log# 3 seq# 1 mem# 1: /oracle/XD3/mirrlogA/log_g13m2.dbf
Successful open of redo thread 1
Thu Dec 11 16:36:21 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Dec 11 16:36:21 2008
ARC1: STARTING ARCH PROCESSES
Thu Dec 11 16:36:21 2008
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Thu Dec 11 16:36:21 2008
ARC2: Archival started
ARC1: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the heartbeat ARCH
ARC2 started with pid=21, OS id=552974
Thu Dec 11 16:36:21 2008
SMON: enabling cache recovery
Thu Dec 11 16:36:23 2008
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'PSAPTEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Thu Dec 11 16:36:23 2008
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.28.0]
Thu Dec 11 16:36:26 2008
Dictionary check complete
Thu Dec 11 16:36:26 2008
SMON: enabling tx recovery
Thu Dec 11 16:36:26 2008
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: PSAPTEMP
*********************************************************************
Updating character set in controlfile to WE8DEC
Threshold validation cannot be done before catproc is loaded.
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=23, OS id=561170
Thu Dec 11 16:36:31 2008
LOGSTDBY: Validating controlfile with logical metadata
Thu Dec 11 16:36:31 2008
LOGSTDBY: Validation complete
Global Name changed to XD3
Completed: alter database open resetlogs
Thu Dec 11 16:37:34 2008
Shutting down instance: further logons disabled
Thu Dec 11 16:37:35 2008
Stopping background process QMNC
Thu Dec 11 16:37:35 2008
Stopping background process CJQ0
Thu Dec 11 16:37:37 2008
Stopping background process MMNL
Thu Dec 11 16:37:38 2008
Stopping background process MMON
Thu Dec 11 16:37:39 2008
Shutting down instance (normal)
License high water mark = 6
Thu Dec 11 16:37:39 2008
Stopping Job queue slave processes
Thu Dec 11 16:37:39 2008
Job queue slave processes stopped
Thu Dec 11 16:41:48 2008
ALTER DATABASE CLOSE NORMAL
Thu Dec 11 16:41:49 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Dec 11 16:41:49 2008
Shutting down archive processes
Archiving is disabled
Thu Dec 11 16:41:54 2008
ARCH shutting down
ARC2: Archival stopped
Thu Dec 11 16:41:59 2008
ARCH shutting down
ARC1: Archival stopped
Thu Dec 11 16:42:04 2008
ARCH shutting down
ARC0: Archival stopped
Thu Dec 11 16:42:06 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Thu Dec 11 16:42:06 2008
Completed: ALTER DATABASE CLOSE NORMAL
Thu Dec 11 16:42:06 2008
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu Dec 11 16:43:04 2008
Starting ORACLE instance (normal)
Thu Dec 11 16:43:04 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=307256
PSP0 started with pid=3, OS id=290982
MMAN started with pid=4, OS id=475372
DBW0 started with pid=5, OS id=233492
LGWR started with pid=6, OS id=471272
CKPT started with pid=7, OS id=467176
SMON started with pid=8, OS id=340136
RECO started with pid=9, OS id=245978
CJQ0 started with pid=10, OS id=295108
MMON started with pid=11, OS id=426210
MMNL started with pid=12, OS id=418010
Thu Dec 11 16:43:04 2008
ALTER DATABASE MOUNT
Thu Dec 11 16:43:09 2008
Setting recovery target incarnation to 2
Thu Dec 11 16:43:09 2008
Successful mount of redo thread 1, with mount id 1063255768
Thu Dec 11 16:43:09 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Thu Dec 11 16:43:09 2008
ALTER DATABASE OPEN
Thu Dec 11 16:43:09 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=237722
Thu Dec 11 16:43:09 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=15, OS id=311460
Thu Dec 11 16:43:09 2008
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /oracle/XD3/origlogA/log_g13m1.dbf
Current log# 3 seq# 1 mem# 1: /oracle/XD3/mirrlogA/log_g13m2.dbf
Successful open of redo thread 1
Thu Dec 11 16:43:09 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Dec 11 16:43:09 2008
ARC0: STARTING ARCH PROCESSES
Thu Dec 11 16:43:09 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Thu Dec 11 16:43:09 2008
SMON: enabling cache recovery
Thu Dec 11 16:43:09 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=16, OS id=422110
Thu Dec 11 16:43:10 2008
Incremental checkpoint up to RBA [0x1.124.0], current log tail at RBA [0x1.124.0]
Thu Dec 11 16:43:10 2008
Successfully onlined Undo Tablespace 1.
Thu Dec 11 16:43:10 2008
SMON: enabling tx recovery
Thu Dec 11 16:43:10 2008
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: PSAPTEMP
*********************************************************************
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=221394
Thu Dec 11 16:43:13 2008
Completed: ALTER DATABASE OPEN
Thu Dec 11 16:49:09 2008
Shutting down archive processes
Thu Dec 11 16:49:14 2008
ARCH shutting down
ARC2: Archival stopped
Thu Dec 11 16:52:37 2008
Starting ORACLE instance (normal)
Thu Dec 11 16:52:48 2008
Starting ORACLE instance (normal)
Shutting down instance: further logons disabled
Thu Dec 11 16:52:56 2008
Stopping background process QMNC
Thu Dec 11 16:52:56 2008
Stopping background process CJQ0
Thu Dec 11 16:52:58 2008
Stopping background process MMNL
Thu Dec 11 16:52:59 2008
Stopping background process MMON
Thu Dec 11 16:53:00 2008
Shutting down instance (immediate)
License high water mark = 1
Thu Dec 11 16:53:00 2008
Stopping Job queue slave processes
Thu Dec 11 16:53:00 2008
Job queue slave processes stopped
Thu Dec 11 16:53:00 2008
ALTER DATABASE CLOSE NORMAL
Thu Dec 11 16:53:01 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Dec 11 16:53:02 2008
Shutting down archive processes
Archiving is disabled
Thu Dec 11 16:53:07 2008
ARCH shutting down
ARC1: Archival stopped
Thu Dec 11 16:53:12 2008
ARCH shutting down
ARC0: Archival stopped
Thu Dec 11 16:53:14 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Thu Dec 11 16:53:14 2008
Completed: ALTER DATABASE CLOSE NORMAL
Thu Dec 11 16:53:14 2008
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
Thu Dec 11 16:58:11 2008
Starting ORACLE instance (normal)
Thu Dec 11 16:58:11 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=340138
PSP0 started with pid=3, OS id=290984
MMAN started with pid=4, OS id=467198
DBW0 started with pid=5, OS id=245980
LGWR started with pid=6, OS id=233494
CKPT started with pid=7, OS id=307258
SMON started with pid=8, OS id=311462
RECO started with pid=9, OS id=237724
CJQ0 started with pid=10, OS id=548892
MMON started with pid=11, OS id=426212
MMNL started with pid=12, OS id=418012
Thu Dec 11 16:58:12 2008
ALTER DATABASE MOUNT
Thu Dec 11 16:58:16 2008
Setting recovery target incarnation to 2
Thu Dec 11 16:58:16 2008
Successful mount of redo thread 1, with mount id 1063290724
Thu Dec 11 16:58:16 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 10:33:29 2008
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 331966
Fri Dec 12 10:48:42 2008
Starting ORACLE instance (normal)
Fri Dec 12 10:48:42 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=311502
PSP0 started with pid=3, OS id=340150
MMAN started with pid=4, OS id=290986
DBW0 started with pid=5, OS id=245982
LGWR started with pid=6, OS id=237726
CKPT started with pid=7, OS id=233496
SMON started with pid=8, OS id=258078
RECO started with pid=9, OS id=327860
CJQ0 started with pid=10, OS id=434262
MMON started with pid=11, OS id=417826
MMNL started with pid=12, OS id=581696
Fri Dec 12 10:48:43 2008
ALTER DATABASE MOUNT
Fri Dec 12 10:48:47 2008
Setting recovery target incarnation to 2
Fri Dec 12 10:48:48 2008
Successful mount of redo thread 1, with mount id 1063346507
Fri Dec 12 10:48:48 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 12:12:36 2008
Shutting down instance (abort)
License high water mark = 2
Instance terminated by USER, pid = 262318
Fri Dec 12 12:17:34 2008
Starting ORACLE instance (normal)
Fri Dec 12 12:17:34 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=340152
PSP0 started with pid=3, OS id=327862
MMAN started with pid=4, OS id=311504
DBW0 started with pid=5, OS id=290988
LGWR started with pid=6, OS id=262320
CKPT started with pid=7, OS id=258080
SMON started with pid=8, OS id=581722
RECO started with pid=9, OS id=245984
CJQ0 started with pid=10, OS id=237728
MMON started with pid=11, OS id=233498
MMNL started with pid=12, OS id=565372
Fri Dec 12 12:17:34 2008
ALTER DATABASE MOUNT
Fri Dec 12 12:17:34 2008
ORA-00202: control file: '/oracle/XD3/origlogA/cntrl/cntlrXD3.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:17:37 2008
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Dec 12 12:18:19 2008
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 434294
Fri Dec 12 12:31:44 2008
Starting ORACLE instance (normal)
Fri Dec 12 12:31:44 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=291046
PSP0 started with pid=3, OS id=262186
MMAN started with pid=4, OS id=245996
DBW0 started with pid=5, OS id=237740
LGWR started with pid=6, OS id=421928
CKPT started with pid=7, OS id=233510
SMON started with pid=8, OS id=340146
RECO started with pid=9, OS id=405628
CJQ0 started with pid=10, OS id=258236
MMON started with pid=11, OS id=311468
MMNL started with pid=12, OS id=299182
Fri Dec 12 12:31:45 2008
CREATE CONTROLFILE REUSE SET DATABASE "XD3" RESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 1022
MAXINSTANCES 50
MAXLOGHISTORY 11680
LOGFILE
GROUP 1 (
'/oracle/XD3/origlogA/log_g11m1.dbf',
'/oracle/XD3/mirrlogA/log_g11m2.dbf'
) SIZE 50M,
GROUP 2 (
'/oracle/XD3/origlogB/log_g12m1.dbf',
'/oracle/XD3/mirrlogB/log_g12m2.dbf'
) SIZE 50M,
GROUP 3 (
'/oracle/XD3/origlogA/log_g13m1.dbf',
'/oracle/XD3/mirrlogA/log_g13m2.dbf'
) SIZE 50M,
GROUP 4 (
'/oracle/XD3/origlogB/log_g14m1.dbf',
'/oracle/XD3/mirrlogB/log_g14m2.dbf'
) SIZE 50M
DATAFILE
'/oracle/XD3/sapdata1/system_1/system.data1',
'/oracle/XD3/sapdata3/undo_1/undo.data1',
'/oracle/XD3/sapdata1/sysaux_1/sysaux.data1',
'/oracle/XD3/sapdata1/sr3_1/sr3.data1',
'/oracle/XD3/sapdata1/sr3_2/sr3.data2',
'/oracle/XD3/sapdata1/sr3_3/sr3.data3',
'/oracle/XD3/sapdata1/sr3_4/sr3.data4',
'/oracle/XD3/sapdata1/sr3_5/sr3.data5',
'/oracle/XD3/sapdata2/sr3_6/sr3.data6',
'/oracle/XD3/sapdata2/sr3_7/sr3.data7',
'/oracle/XD3/sapdata2/sr3_8/sr3.data8',
'/oracle/XD3/sapdata2/sr3_9/sr3.data9',
'/oracle/XD3/sapdata2/sr3_10/sr3.data10',
'/oracle/XD3/sapdata3/sr3_11/sr3.data11',
'/oracle/XD3/sapdata3/sr3_12/sr3.data12',
'/oracle/XD3/sapdata3/sr3_13/sr3.data13',
'/oracle/XD3/sapdata3/sr3_14/sr3.data14',
'/oracle/XD3/sapdata3/sr3_15/sr3.data15',
'/oracle/XD3/sapdata4/sr3_16/sr3.data16',
'/oracle/XD3/sapdata4/sr3_17/sr3.data17',
'/oracle/XD3/sapdata4/sr3_18/sr3.data18',
'/oracle/XD3/sapdata4/sr3_19/sr3.data19',
'/oracle/XD3/sapdata4/sr3_20/sr3.data20',
'/oracle/XD3/sapdata1/sr3700_1/sr3700.data1',
'/oracle/XD3/sapdata1/sr3700_2/sr3700.data2',
'/oracle/XD3/sapdata1/sr3700_3/sr3700.data3',
'/oracle/XD3/sapdata1/sr3700_4/sr3700.data4',
'/oracle/XD3/sapdata2/sr3700_5/sr3700.data5',
'/oracle/XD3/sapdata2/sr3700_6/sr3700.data6',
'/oracle/XD3/sapdata2/sr3700_7/sr3700.data7',
'/oracle/XD3/sapdata2/sr3700_8/sr3700.data8',
'/oracle/XD3/sapdata3/sr3700_9/sr3700.data9',
'/oracle/XD3/sapdata3/sr3700_10/sr3700.data10',
'/oracle/XD3/sapdata3/sr3700_11/sr3700.data11',
'/oracle/XD3/sapdata3/sr3700_12/sr3700.data12',
'/oracle/XD3/sapdata4/sr3700_13/sr3700.data13',
'/oracle/XD3/sapdata4/sr3700_14/sr3700.data14',
'/oracle/XD3/sapdata4/sr3700_15/sr3700.data15',
'/oracle/XD3/sapdata4/sr3700_16/sr3700.data16',
'/oracle/XD3/sapdata1/sr3usr_1/sr3usr.data1',
'/oracle/XD3/sapdata1/system_2/system.data2'
Fri Dec 12 12:31:45 2008
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Fri Dec 12 12:31:51 2008
Successful mount of redo thread 1, with mount id 1063357809
Fri Dec 12 12:31:51 2008
Completed: CREATE CONTROLFILE REUSE SET DATABASE "XD3" RESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 1022
MAXINSTANCES 50
MAXLOGHISTORY 11680
LOGFILE
GROUP 1 (
'/oracle/XD3/origlogA/log_g11m1.dbf',
'/oracle/XD3/mirrlogA/log_g11m2.dbf'
) SIZE 50M,
GROUP 2 (
'/oracle/XD3/origlogB/log_g12m1.dbf',
'/oracle/XD3/mirrlogB/log_g12m2.dbf'
) SIZE 50M,
GROUP 3 (
'/oracle/XD3/origlogA/log_g13m1.dbf',
'/oracle/XD3/mirrlogA/log_g13m2.dbf'
) SIZE 50M,
GROUP 4 (
'/oracle/XD3/origlogB/log_g14m1.dbf',
'/oracle/XD3/mirrlogB/log_g14m2.dbf'
) SIZE 50M
DATAFILE
'/oracle/XD3/sapdata1/system_1/system.data1',
'/oracle/XD3/sapdata3/undo_1/undo.data1',
'/oracle/XD3/sapdata1/sysaux_1/sysaux.data1',
'/oracle/XD3/sapdata1/sr3_1/sr3.data1',
'/oracle/XD3/sapdata1/sr3_2/sr3.data2',
'/oracle/XD3/sapdata1/sr3_3/sr3.data3',
'/oracle/XD3/sapdata1/sr3_4/sr3.data4',
'/oracle/XD3/sapdata1/sr3_5/sr3.data5',
'/oracle/XD3/sapdata2/sr3_6/sr3.data6',
'/oracle/XD3/sapdata2/sr3_7/sr3.data7',
'/oracle/XD3/sapdata2/sr3_8/sr3.data8',
'/oracle/XD3/sapdata2/sr3_9/sr3.data9',
'/oracle/XD3/sapdata2/sr3_10/sr3.data10',
'/oracle/XD3/sapdata3/sr3_11/sr3.data11',
'/oracle/XD3/sapdata3/sr3_12/sr3.data12',
'/oracle/XD3/sapdata3/sr3_13/sr3.data13',
'/oracle/XD3/sapdata3/sr3_14/sr3.data14',
'/oracle/XD3/sapdata3/sr3_15/sr3.data15',
'/oracle/XD3/sapdata4/sr3_16/sr3.data16',
'/oracle/XD3/sapdata4/sr3_17/sr3.data17',
'/oracle/XD3/sapdata4/sr3_18/sr3.data18',
'/oracle/XD3/sapdata4/sr3_19/sr3.data19',
'/oracle/XD3/sapdata4/sr3_20/sr3.data20',
'/oracle/XD3/sapdata1/sr3700_1/sr3700.data1',
'/oracle/XD3/sapdata1/sr3700_2/sr3700.data2',
'/oracle/XD3/sapdata1/sr3700_3/sr3700.data3',
'/oracle/XD3/sapdata1/sr3700_4/sr3700.data4',
'/oracle/XD3/sapdata2/sr3700_5/sr3700.data5',
'/oracle/XD3/sapdata2/sr3700_6/sr3700.data6',
'/oracle/XD3/sapdata2/sr3700_7/sr3700.data7',
'/oracle/XD3/sapdata2/sr3700_8/sr3700.data8',
'/oracle/XD3/sapdata3/sr3700_9/sr3700.data9',
'/oracle/XD3/sapdata3/sr3700_10/sr3700.data10',
'/oracle/XD3/sapdata3/sr3700_11/sr3700.data11',
'/oracle/XD3/sapdata3/sr3700_12/sr3700.data12',
'/oracle/XD3/sapdata4/sr3700_13/sr3700.data13',
'/oracle/XD3/sapdata4/sr3700_14/sr3700.data14',
'/oracle/XD3/sapdata4/sr3700_15/sr3700.data15',
'/oracle/XD3/sapdata4/sr3700_16/sr3700.data16',
'/oracle/XD3/sapdata1/sr3usr_1/sr3usr.data1',
'/oracle/XD3/sapdata1/system_2/system.data2'
Fri Dec 12 12:31:51 2008
ALTER DATABASE OPEN RESETLOGS
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
Fri Dec 12 12:31:51 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/XD3/mirrlogA/log_g11m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/oracle/XD3/origlogA/log_g11m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:51 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/XD3/mirrlogA/log_g11m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/oracle/XD3/origlogA/log_g11m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:51 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle/XD3/mirrlogB/log_g12m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/oracle/XD3/origlogB/log_g12m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:51 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle/XD3/mirrlogB/log_g12m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/oracle/XD3/origlogB/log_g12m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:51 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/XD3/mirrlogA/log_g13m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/oracle/XD3/origlogA/log_g13m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:51 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/XD3/mirrlogA/log_g13m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/oracle/XD3/origlogA/log_g13m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:51 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '/oracle/XD3/mirrlogB/log_g14m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 1: '/oracle/XD3/origlogB/log_g14m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:51 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '/oracle/XD3/mirrlogB/log_g14m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 1: '/oracle/XD3/origlogB/log_g14m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
RESETLOGS after incomplete recovery UNTIL CHANGE 21473926
Fri Dec 12 12:31:51 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/XD3/mirrlogA/log_g11m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/oracle/XD3/origlogA/log_g11m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:53 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle/XD3/mirrlogB/log_g12m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/oracle/XD3/origlogB/log_g12m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:55 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/XD3/mirrlogA/log_g13m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/oracle/XD3/origlogA/log_g13m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:31:57 2008
Errors in file /oracle/XD3/saptrace/usertrace/xd3_ora_286848.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '/oracle/XD3/mirrlogB/log_g14m2.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 1: '/oracle/XD3/origlogB/log_g14m1.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Fri Dec 12 12:32:00 2008
Setting recovery target incarnation to 2
Fri Dec 12 12:32:00 2008
Assigning activation ID 1063357809 (0x3f618d71)
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=417854
Fri Dec 12 12:32:00 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=15, OS id=434310
Fri Dec 12 12:32:00 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 12:32:00 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 12:32:00 2008
ARC0: STARTING ARCH PROCESSES
Fri Dec 12 12:32:00 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Dec 12 12:32:00 2008
SMON: enabling cache recovery
Fri Dec 12 12:32:00 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=16, OS id=544794
Fri Dec 12 12:32:01 2008
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'PSAPTEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Fri Dec 12 12:32:02 2008
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.29.0]
Fri Dec 12 12:32:04 2008
Dictionary check complete
Fri Dec 12 12:32:04 2008
SMON: enabling tx recovery
Fri Dec 12 12:32:04 2008
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: PSAPTEMP
*********************************************************************
Updating character set in controlfile to WE8DEC
Threshold validation cannot be done before catproc is loaded.
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=569380
Fri Dec 12 12:32:06 2008
LOGSTDBY: Validating controlfile with logical metadata
Fri Dec 12 12:32:07 2008
LOGSTDBY: Validation complete
Global Name changed to XD3
Completed: ALTER DATABASE OPEN RESETLOGS
Fri Dec 12 12:32:07 2008
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/XD3/sapdata2/temp_1/temp.data1'
SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Completed: ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/XD3/sapdata2/temp_1/temp.data1'
SIZE 2000M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Fri Dec 12 12:35:29 2008
Shutting down instance: further logons disabled
Fri Dec 12 12:35:29 2008
Stopping background process QMNC
Fri Dec 12 12:35:29 2008
Stopping background process CJQ0
Fri Dec 12 12:35:32 2008
Stopping background process MMNL
Fri Dec 12 12:35:33 2008
Stopping background process MMON
Fri Dec 12 12:35:34 2008
Shutting down instance (immediate)
License high water mark = 1
Fri Dec 12 12:35:34 2008
Stopping Job queue slave processes
Fri Dec 12 12:35:34 2008
Job queue slave processes stopped
Fri Dec 12 12:35:34 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 12:35:35 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 12 12:35:35 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 12:35:40 2008
ARCH shutting down
ARC2: Archival stopped
Fri Dec 12 12:35:45 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 12:35:50 2008
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 12:35:52 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 12:35:52 2008
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 12 12:35:52 2008
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
Fri Dec 12 12:36:37 2008
Starting ORACLE instance (normal)
Fri Dec 12 12:36:37 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=422140
PSP0 started with pid=3, OS id=311480
MMAN started with pid=4, OS id=569382
DBW0 started with pid=5, OS id=262236
LGWR started with pid=6, OS id=561178
CKPT started with pid=7, OS id=291062
SMON started with pid=8, OS id=299196
RECO started with pid=9, OS id=258238
CJQ0 started with pid=10, OS id=434314
MMON started with pid=11, OS id=557086
MMNL started with pid=12, OS id=204978
Fri Dec 12 12:36:38 2008
ALTER DATABASE MOUNT
Fri Dec 12 12:36:42 2008
Setting recovery target incarnation to 2
Fri Dec 12 12:36:42 2008
Successful mount of redo thread 1, with mount id 1063323030
Fri Dec 12 12:36:42 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 12:36:42 2008
ALTER DATABASE OPEN
Fri Dec 12 12:36:43 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=548980
Fri Dec 12 12:36:43 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=15, OS id=323746
Fri Dec 12 12:36:43 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 12:36:43 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 12:36:43 2008
ARC0: STARTING ARCH PROCESSES
Fri Dec 12 12:36:43 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Dec 12 12:36:43 2008
SMON: enabling cache recovery
Fri Dec 12 12:36:43 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=16, OS id=573602
Fri Dec 12 12:36:43 2008
Incremental checkpoint up to RBA [0x1.131.0], current log tail at RBA [0x1.131.0]
Fri Dec 12 12:36:44 2008
Successfully onlined Undo Tablespace 1.
Fri Dec 12 12:36:44 2008
SMON: enabling tx recovery
Fri Dec 12 12:36:44 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=17, OS id=577584
Fri Dec 12 12:36:47 2008
Completed: ALTER DATABASE OPEN
Fri Dec 12 12:38:24 2008
Shutting down instance: further logons disabled
Fri Dec 12 12:38:24 2008
Stopping background process QMNC
Fri Dec 12 12:38:24 2008
Stopping background process CJQ0
Fri Dec 12 12:38:27 2008
Stopping background process MMNL
Fri Dec 12 12:38:28 2008
Stopping background process MMON
Fri Dec 12 12:38:29 2008
Shutting down instance (immediate)
License high water mark = 1
Fri Dec 12 12:38:29 2008
Stopping Job queue slave processes
Fri Dec 12 12:38:29 2008
Job queue slave processes stopped
Fri Dec 12 12:38:29 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 12:38:30 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 12 12:38:31 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 12:38:36 2008
ARCH shutting down
ARC2: Archival stopped
Fri Dec 12 12:38:41 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 12:38:46 2008
ARC0: Becoming the heartbeat ARCH
ARC0: Archiving disabled
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 12:38:48 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 12:38:48 2008
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 12 12:38:48 2008
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
Fri Dec 12 12:38:56 2008
Starting ORACLE instance (normal)
Fri Dec 12 12:38:56 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=299198
PSP0 started with pid=3, OS id=291064
MMAN started with pid=4, OS id=262238
DBW0 started with pid=5, OS id=561188
LGWR started with pid=6, OS id=422142
CKPT started with pid=7, OS id=573604
SMON started with pid=8, OS id=548982
RECO started with pid=9, OS id=323748
CJQ0 started with pid=10, OS id=557088
MMON started with pid=11, OS id=204980
MMNL started with pid=12, OS id=258254
Fri Dec 12 12:38:57 2008
ALTER DATABASE MOUNT
Fri Dec 12 12:39:01 2008
Setting recovery target incarnation to 2
Fri Dec 12 12:39:02 2008
Successful mount of redo thread 1, with mount id 1063379489
Fri Dec 12 12:39:02 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 12:39:15 2008
ALTER DATABASE RECOVER
Fri Dec 12 12:39:15 2008
Media Recovery Start
Fri Dec 12 12:39:15 2008
Media Recovery failed with error 264
ORA-283 signalled during: ALTER DATABASE RECOVER...
Fri Dec 12 12:39:43 2008
ALTER DATABASE RECOVER database using backup controlfile
Fri Dec 12 12:39:43 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile ...
Fri Dec 12 12:40:25 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 12:40:25 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 12:40:25 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 12:42:33 2008
ALTER DATABASE RECOVER
Fri Dec 12 12:42:33 2008
Media Recovery Start
Fri Dec 12 12:42:33 2008
Media Recovery failed with error 1610
ORA-283 signalled during: ALTER DATABASE RECOVER...
Fri Dec 12 12:43:03 2008
ALTER DATABASE RECOVER database using backup controlfile
Fri Dec 12 12:43:03 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile ...
Fri Dec 12 12:43:20 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 12:43:20 2008
Media Recovery Log /oracle/XD3/mirrlogB/log_g14m2.dbf
Fri Dec 12 12:43:20 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 12:43:35 2008
ALTER DATABASE RECOVER database using backup controlfile
Fri Dec 12 12:43:35 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile ...
Fri Dec 12 12:43:42 2008
ALTER DATABASE RECOVER CANCEL
Fri Dec 12 12:43:45 2008
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Fri Dec 12 12:43:58 2008
ALTER DATABASE OPEN RESETLOGS
Fri Dec 12 12:43:58 2008
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
RESETLOGS after incomplete recovery UNTIL CHANGE 21484153
Resetting resetlogs activation ID 1063357809 (0x3f618d71)
Online log /oracle/XD3/origlogA/log_g11m1.dbf: Thread 1 Group 1 was previously cleared
Online log /oracle/XD3/mirrlogA/log_g11m2.dbf: Thread 1 Group 1 was previously cleared
Online log /oracle/XD3/origlogB/log_g12m1.dbf: Thread 1 Group 2 was previously cleared
Online log /oracle/XD3/mirrlogB/log_g12m2.dbf: Thread 1 Group 2 was previously cleared
Online log /oracle/XD3/origlogA/log_g13m1.dbf: Thread 1 Group 3 was previously cleared
Online log /oracle/XD3/mirrlogA/log_g13m2.dbf: Thread 1 Group 3 was previously cleared
Fri Dec 12 12:44:02 2008
Setting recovery target incarnation to 3
Fri Dec 12 12:44:03 2008
Assigning activation ID 1063379489 (0x3f61e221)
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=17, OS id=577604
Fri Dec 12 12:44:03 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=18, OS id=303352
Fri Dec 12 12:44:03 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 12:44:03 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 12:44:03 2008
ARC0: STARTING ARCH PROCESSES
Fri Dec 12 12:44:03 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Dec 12 12:44:03 2008
SMON: enabling cache recovery
ARC2 started with pid=19, OS id=286850
Fri Dec 12 12:44:03 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Fri Dec 12 12:44:04 2008
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Fri Dec 12 12:44:05 2008
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.27.0]
Fri Dec 12 12:44:07 2008
Dictionary check complete
Fri Dec 12 12:44:07 2008
SMON: enabling tx recovery
Fri Dec 12 12:44:07 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=20, OS id=245778
Fri Dec 12 12:44:09 2008
LOGSTDBY: Validating controlfile with logical metadata
Fri Dec 12 12:44:09 2008
LOGSTDBY: Validation complete
Completed: ALTER DATABASE OPEN RESETLOGS
Fri Dec 12 12:44:22 2008
Shutting down instance: further logons disabled
Fri Dec 12 12:44:22 2008
Stopping background process QMNC
Fri Dec 12 12:44:22 2008
Stopping background process CJQ0
Fri Dec 12 12:44:25 2008
Stopping background process MMNL
Fri Dec 12 12:44:26 2008
Stopping background process MMON
Fri Dec 12 12:44:27 2008
Shutting down instance (normal)
License high water mark = 4
Fri Dec 12 12:44:27 2008
Stopping Job queue slave processes
Fri Dec 12 12:44:27 2008
Job queue slave processes stopped
Fri Dec 12 12:44:27 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 12:44:28 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 12 12:44:28 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 12:44:33 2008
ARCH shutting down
ARC2: Archival stopped
Fri Dec 12 12:44:38 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 12:44:43 2008
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 12:44:45 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 12:44:46 2008
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 12 12:44:46 2008
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Dec 12 12:45:34 2008
Starting ORACLE instance (normal)
Fri Dec 12 12:45:34 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=286854
PSP0 started with pid=3, OS id=434326
MMAN started with pid=4, OS id=311488
DBW0 started with pid=5, OS id=237606
LGWR started with pid=6, OS id=204982
CKPT started with pid=7, OS id=258256
SMON started with pid=8, OS id=545020
RECO started with pid=9, OS id=589910
CJQ0 started with pid=10, OS id=557090
MMON started with pid=11, OS id=340032
MMNL started with pid=12, OS id=233572
Fri Dec 12 12:45:35 2008
ALTER DATABASE MOUNT
Fri Dec 12 12:45:39 2008
Setting recovery target incarnation to 3
Fri Dec 12 12:45:39 2008
Successful mount of redo thread 1, with mount id 1063349679
Fri Dec 12 12:45:39 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 12:45:40 2008
ALTER DATABASE OPEN
Fri Dec 12 12:45:40 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=303106
Fri Dec 12 12:45:40 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=15, OS id=245790
Fri Dec 12 12:45:40 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 12:45:40 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 12:45:40 2008
ARC0: STARTING ARCH PROCESSES
Fri Dec 12 12:45:40 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Dec 12 12:45:40 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=16, OS id=417910
Fri Dec 12 12:45:40 2008
SMON: enabling cache recovery
Fri Dec 12 12:45:41 2008
Incremental checkpoint up to RBA [0x1.129.0], current log tail at RBA [0x1.12b.0]
Fri Dec 12 12:45:41 2008
Successfully onlined Undo Tablespace 1.
Fri Dec 12 12:45:41 2008
SMON: enabling tx recovery
Fri Dec 12 12:45:41 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=405522
Fri Dec 12 12:45:44 2008
Completed: ALTER DATABASE OPEN
Fri Dec 12 12:51:40 2008
Shutting down archive processes
Fri Dec 12 12:51:45 2008
ARCH shutting down
ARC2: Archival stopped
Shutting down instance: further logons disabled
Fri Dec 12 13:00:47 2008
Stopping background process QMNC
Fri Dec 12 13:00:47 2008
Stopping background process CJQ0
Fri Dec 12 13:00:49 2008
Stopping background process MMNL
Fri Dec 12 13:00:50 2008
Stopping background process MMON
Fri Dec 12 13:00:51 2008
Shutting down instance (immediate)
License high water mark = 1
Fri Dec 12 13:00:51 2008
Stopping Job queue slave processes
Fri Dec 12 13:00:51 2008
Job queue slave processes stopped
Fri Dec 12 13:00:51 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 13:00:52 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 12 13:00:52 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 13:00:57 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 13:01:02 2008
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 13:01:04 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 13:01:04 2008
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 12 13:01:04 2008
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
Fri Dec 12 13:15:12 2008
Starting ORACLE instance (normal)
Fri Dec 12 13:15:13 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PSP0 started with pid=3, OS id=290916
MMAN started with pid=4, OS id=360654
PMON started with pid=2, OS id=356390
DBW0 started with pid=5, OS id=381046
LGWR started with pid=6, OS id=270408
CKPT started with pid=7, OS id=335938
SMON started with pid=8, OS id=258218
RECO started with pid=9, OS id=286940
CJQ0 started with pid=10, OS id=340154
MMON started with pid=11, OS id=319648
MMNL started with pid=12, OS id=401604
Fri Dec 12 13:15:18 2008
ALTER DATABASE MOUNT
Fri Dec 12 13:15:23 2008
Setting recovery target incarnation to 3
Fri Dec 12 13:15:23 2008
Successful mount of redo thread 1, with mount id 1063375014
Fri Dec 12 13:15:23 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 13:15:23 2008
ALTER DATABASE OPEN
Fri Dec 12 13:15:23 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=471270
ARC1 started with pid=15, OS id=475368
Fri Dec 12 13:15:24 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 13:15:24 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 13:15:24 2008
ARC0: STARTING ARCH PROCESSES
Fri Dec 12 13:15:24 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Dec 12 13:15:24 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=16, OS id=508152
Fri Dec 12 13:15:24 2008
SMON: enabling cache recovery
Fri Dec 12 13:15:24 2008
Incremental checkpoint up to RBA [0x1.2a8.0], current log tail at RBA [0x1.2a8.0]
Fri Dec 12 13:15:27 2008
Successfully onlined Undo Tablespace 1.
Fri Dec 12 13:15:27 2008
SMON: enabling tx recovery
Fri Dec 12 13:15:27 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=516348
Fri Dec 12 13:15:33 2008
Completed: ALTER DATABASE OPEN
Fri Dec 12 13:16:43 2008
Shutting down instance: further logons disabled
Fri Dec 12 13:16:43 2008
Stopping background process CJQ0
Fri Dec 12 13:16:43 2008
Stopping background process QMNC
Fri Dec 12 13:16:45 2008
Stopping background process MMNL
Fri Dec 12 13:16:46 2008
Stopping background process MMON
Fri Dec 12 13:16:47 2008
Shutting down instance (immediate)
License high water mark = 1
Fri Dec 12 13:16:47 2008
Stopping Job queue slave processes
Fri Dec 12 13:16:47 2008
Job queue slave processes stopped
Fri Dec 12 13:16:47 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 13:16:48 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 12 13:16:49 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 13:16:54 2008
ARCH shutting down
ARC2: Archival stopped
Fri Dec 12 13:16:59 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 13:17:04 2008
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 13:17:06 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 13:17:06 2008
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 12 13:17:06 2008
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
Fri Dec 12 13:17:09 2008
Starting ORACLE instance (normal)
Fri Dec 12 13:17:09 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=335940
PSP0 started with pid=3, OS id=290918
MMAN started with pid=4, OS id=286942
DBW0 started with pid=5, OS id=270410
LGWR started with pid=6, OS id=258220
CKPT started with pid=7, OS id=356392
SMON started with pid=8, OS id=508154
RECO started with pid=9, OS id=475370
CJQ0 started with pid=10, OS id=471272
MMON started with pid=11, OS id=401606
MMNL started with pid=12, OS id=536596
Fri Dec 12 13:17:10 2008
ALTER DATABASE MOUNT
Fri Dec 12 13:17:14 2008
Setting recovery target incarnation to 3
Fri Dec 12 13:17:14 2008
Successful mount of redo thread 1, with mount id 1063334934
Fri Dec 12 13:17:14 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 13:17:14 2008
ALTER DATABASE OPEN
Fri Dec 12 13:17:15 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=516350
Fri Dec 12 13:17:15 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=15, OS id=532490
Fri Dec 12 13:17:15 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 13:17:15 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 13:17:15 2008
ARC0: STARTING ARCH PROCESSES
Fri Dec 12 13:17:15 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Dec 12 13:17:15 2008
SMON: enabling cache recovery
Fri Dec 12 13:17:15 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=16, OS id=426198
Fri Dec 12 13:17:16 2008
Incremental checkpoint up to RBA [0x1.3d5.0], current log tail at RBA [0x1.3dc.0]
Fri Dec 12 13:17:16 2008
Successfully onlined Undo Tablespace 1.
Fri Dec 12 13:17:16 2008
SMON: enabling tx recovery
Fri Dec 12 13:17:16 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=348212
Fri Dec 12 13:17:18 2008
Completed: ALTER DATABASE OPEN
Fri Dec 12 13:23:15 2008
Shutting down archive processes
Fri Dec 12 13:23:20 2008
ARCH shutting down
ARC2: Archival stopped
Shutting down instance: further logons disabled
Fri Dec 12 13:39:40 2008
Stopping background process QMNC
Fri Dec 12 13:39:40 2008
Stopping background process CJQ0
Fri Dec 12 13:39:42 2008
Stopping background process MMNL
Fri Dec 12 13:39:43 2008
Stopping background process MMON
Fri Dec 12 13:39:44 2008
Shutting down instance (immediate)
License high water mark = 1
Fri Dec 12 13:39:44 2008
Stopping Job queue slave processes
Fri Dec 12 13:39:44 2008
Job queue slave processes stopped
Fri Dec 12 13:39:44 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 13:39:45 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 12 13:39:45 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 13:39:50 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 13:39:55 2008
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 13:39:57 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 13:39:58 2008
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 12 13:39:58 2008
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
Fri Dec 12 13:40:01 2008
Starting ORACLE instance (normal)
Fri Dec 12 13:40:01 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=356394
PSP0 started with pid=3, OS id=290920
MMAN started with pid=4, OS id=286944
DBW0 started with pid=5, OS id=270412
LGWR started with pid=6, OS id=258222
CKPT started with pid=7, OS id=335942
SMON started with pid=8, OS id=507916
RECO started with pid=9, OS id=516096
CJQ0 started with pid=10, OS id=606252
MMON started with pid=11, OS id=532498
MMNL started with pid=12, OS id=536598
Fri Dec 12 13:40:01 2008
ALTER DATABASE MOUNT
Fri Dec 12 13:40:06 2008
Setting recovery target incarnation to 3
Fri Dec 12 13:40:06 2008
Successful mount of redo thread 1, with mount id 1063339377
Fri Dec 12 13:40:06 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 13:40:06 2008
ALTER DATABASE OPEN
Fri Dec 12 13:40:06 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=401612
Fri Dec 12 13:40:06 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=15, OS id=602184
Fri Dec 12 13:40:07 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 13:40:07 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 13:40:07 2008
ARC1: STARTING ARCH PROCESSES
Fri Dec 12 13:40:07 2008
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Dec 12 13:40:07 2008
SMON: enabling cache recovery
Fri Dec 12 13:40:07 2008
ARC2: Archival started
ARC1: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the heartbeat ARCH
ARC2 started with pid=16, OS id=348216
Fri Dec 12 13:40:07 2008
Incremental checkpoint up to RBA [0x1.59a.0], current log tail at RBA [0x1.5a3.0]
Fri Dec 12 13:40:07 2008
Successfully onlined Undo Tablespace 1.
Fri Dec 12 13:40:07 2008
SMON: enabling tx recovery
Fri Dec 12 13:40:07 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=471274
Fri Dec 12 13:40:10 2008
Completed: ALTER DATABASE OPEN
Fri Dec 12 13:46:06 2008
Shutting down archive processes
Fri Dec 12 13:46:11 2008
ARCH shutting down
ARC2: Archival stopped
Fri Dec 12 14:10:20 2008
Incremental checkpoint up to RBA [0x1.6aa.0], current log tail at RBA [0x1.6aa.0]
Fri Dec 12 14:30:36 2008
Shutting down instance: further logons disabled
Fri Dec 12 14:30:36 2008
Stopping background process QMNC
Fri Dec 12 14:30:36 2008
Stopping background process CJQ0
Fri Dec 12 14:30:38 2008
Stopping background process MMNL
Fri Dec 12 14:30:39 2008
Stopping background process MMON
Fri Dec 12 14:30:40 2008
Shutting down instance (immediate)
License high water mark = 1
Fri Dec 12 14:30:40 2008
Stopping Job queue slave processes
Fri Dec 12 14:30:40 2008
Job queue slave processes stopped
Fri Dec 12 14:30:40 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 14:30:40 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 12 14:30:41 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 14:30:46 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 14:30:51 2008
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 14:30:53 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 14:30:53 2008
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 12 14:30:53 2008
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
Fri Dec 12 14:34:59 2008
Starting ORACLE instance (normal)
Fri Dec 12 14:34:59 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=536600
PSP0 started with pid=3, OS id=471276
MMAN started with pid=4, OS id=524534
DBW0 started with pid=5, OS id=532502
LGWR started with pid=6, OS id=270444
CKPT started with pid=7, OS id=397554
SMON started with pid=8, OS id=389176
RECO started with pid=9, OS id=475388
CJQ0 started with pid=10, OS id=372884
MMON started with pid=11, OS id=614444
MMNL started with pid=12, OS id=618542
Fri Dec 12 14:34:59 2008
ALTER DATABASE MOUNT
Fri Dec 12 14:35:04 2008
Setting recovery target incarnation to 3
Fri Dec 12 14:35:04 2008
Successful mount of redo thread 1, with mount id 1063331411
Fri Dec 12 14:35:04 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 14:35:04 2008
ALTER DATABASE OPEN
Fri Dec 12 14:35:04 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=516208
Fri Dec 12 14:35:04 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=15, OS id=507940
Fri Dec 12 14:35:05 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 14:35:05 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 14:35:05 2008
ARC1: STARTING ARCH PROCESSES
Fri Dec 12 14:35:05 2008
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Dec 12 14:35:05 2008
SMON: enabling cache recovery
Fri Dec 12 14:35:05 2008
ARC2: Archival started
ARC1: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the heartbeat ARCH
ARC2 started with pid=16, OS id=258246
Fri Dec 12 14:35:05 2008
Incremental checkpoint up to RBA [0x1.6d3.0], current log tail at RBA [0x1.6d8.0]
Fri Dec 12 14:35:05 2008
Successfully onlined Undo Tablespace 1.
Fri Dec 12 14:35:05 2008
SMON: enabling tx recovery
Fri Dec 12 14:35:05 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=356412
Fri Dec 12 14:35:08 2008
Completed: ALTER DATABASE OPEN
Fri Dec 12 14:35:09 2008
Starting ORACLE instance (normal)
Fri Dec 12 14:35:56 2008
Starting ORACLE instance (normal)
Fri Dec 12 14:36:05 2008
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 249976
Fri Dec 12 14:36:13 2008
Starting ORACLE instance (normal)
Fri Dec 12 14:36:13 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=606262
PSP0 started with pid=3, OS id=536602
MMAN started with pid=4, OS id=532504
DBW0 started with pid=5, OS id=249986
LGWR started with pid=6, OS id=516210
CKPT started with pid=7, OS id=507942
SMON started with pid=8, OS id=475390
RECO started with pid=9, OS id=471278
CJQ0 started with pid=10, OS id=401624
MMON started with pid=11, OS id=397556
MMNL started with pid=12, OS id=389178
Fri Dec 12 14:36:14 2008
ALTER DATABASE MOUNT
Fri Dec 12 14:36:18 2008
Setting recovery target incarnation to 3
Fri Dec 12 14:36:18 2008
Successful mount of redo thread 1, with mount id 1063323294
Fri Dec 12 14:36:18 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 14:40:16 2008
ALTER DATABASE RECOVER database using backup controlfile
Fri Dec 12 14:40:16 2008
Media Recovery Start
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 5 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 6 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 7 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 8 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 9 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 10 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 11 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 12 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 13 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 14 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 15 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 16 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 17 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 18 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 19 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 20 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 21 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 22 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 23 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 24 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 25 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 26 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 27 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 28 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 29 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 30 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 31 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 32 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 33 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 34 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 35 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 36 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 37 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 38 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 39 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 40 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 41 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile ...
Fri Dec 12 14:40:23 2008
ALTER DATABASE RECOVER CONTINUE DEFAULT
Fri Dec 12 14:40:23 2008
Media Recovery Log /oracle/XD3/oraarch/XD3arch1_1_673274638.dbf
Errors with log /oracle/XD3/oraarch/XD3arch1_1_673274638.dbf
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Fri Dec 12 14:40:23 2008
ALTER DATABASE RECOVER CONTINUE DEFAULT
Fri Dec 12 14:40:23 2008
Media Recovery Log /oracle/XD3/oraarch/XD3arch1_1_673274638.dbf
Errors with log /oracle/XD3/oraarch/XD3arch1_1_673274638.dbf
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Fri Dec 12 14:40:23 2008
ALTER DATABASE RECOVER CANCEL
Fri Dec 12 14:40:26 2008
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Shutting down instance: further logons disabled
Fri Dec 12 14:50:16 2008
Stopping background process CJQ0
Fri Dec 12 14:50:16 2008
Stopping background process MMNL
Fri Dec 12 14:50:17 2008
Stopping background process MMON
Fri Dec 12 14:50:18 2008
Shutting down instance (immediate)
License high water mark = 4
Fri Dec 12 14:50:18 2008
Stopping Job queue slave processes
Fri Dec 12 14:50:18 2008
Job queue slave processes stopped
Fri Dec 12 14:50:18 2008
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Dec 12 14:50:18 2008
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
Fri Dec 12 14:50:34 2008
Starting ORACLE instance (normal)
Fri Dec 12 14:50:34 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=606268
PSP0 started with pid=3, OS id=507944
MMAN started with pid=4, OS id=475136
DBW0 started with pid=5, OS id=471280
LGWR started with pid=6, OS id=249988
CKPT started with pid=7, OS id=401626
SMON started with pid=8, OS id=397558
RECO started with pid=9, OS id=389180
CJQ0 started with pid=10, OS id=192678
MMON started with pid=11, OS id=524322
MMNL started with pid=12, OS id=344312
Fri Dec 12 14:50:34 2008
ALTER DATABASE MOUNT
Fri Dec 12 14:50:39 2008
Setting recovery target incarnation to 3
Fri Dec 12 14:50:39 2008
Successful mount of redo thread 1, with mount id 1063378170
Fri Dec 12 14:50:39 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 14:50:43 2008
ALTER DATABASE RECOVER
Media Recovery Start
Fri Dec 12 14:50:43 2008
Media Recovery failed with error 1610
ORA-283 signalled during: ALTER DATABASE RECOVER ...
Fri Dec 12 14:51:36 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Fri Dec 12 14:51:36 2008
Media Recovery Start
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 5 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 6 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 7 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 8 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 9 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 10 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 11 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 12 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 13 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 14 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 15 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 16 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 17 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 18 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 19 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 20 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 21 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 22 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 23 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 24 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 25 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 26 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 27 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 28 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 29 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 30 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 31 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 32 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 33 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 34 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 35 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 36 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 37 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 38 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 39 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 40 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 41 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:52:25 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:52:25 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:52:26 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513926
Fri Dec 12 14:52:26 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:52:52 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Fri Dec 12 14:52:52 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:53:01 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:53:01 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:53:01 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:53:01 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:53:11 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
Fri Dec 12 14:53:12 2008
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:53:17 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:53:17 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:53:17 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:53:17 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:53:24 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:53:30 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:53:30 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:53:30 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:53:30 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:53:36 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:53:53 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:53:53 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:53:53 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:53:53 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:54:00 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:54:10 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:54:10 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:54:10 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:54:10 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:54:22 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Fri Dec 12 14:54:22 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:54:28 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:54:28 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:54:28 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:54:28 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:54:36 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:54:43 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:54:43 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:54:43 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:54:43 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:54:50 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:54:58 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:54:58 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:54:58 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:54:58 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:55:03 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:55:18 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:55:18 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:55:19 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:55:19 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:55:42 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Fri Dec 12 14:55:42 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:55:48 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:55:48 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:55:48 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21513927
Fri Dec 12 14:55:48 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:56:33 2008
ALTER DATABASE OPEN RESETLOGS
Fri Dec 12 14:56:33 2008
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
RESETLOGS after incomplete recovery UNTIL CHANGE 21513927
Resetting resetlogs activation ID 1063379489 (0x3f61e221)
Online log /oracle/XD3/origlogA/log_g11m1.dbf: Thread 1 Group 1 was previously cleared
Online log /oracle/XD3/mirrlogA/log_g11m2.dbf: Thread 1 Group 1 was previously cleared
Online log /oracle/XD3/origlogB/log_g12m1.dbf: Thread 1 Group 2 was previously cleared
Online log /oracle/XD3/mirrlogB/log_g12m2.dbf: Thread 1 Group 2 was previously cleared
Online log /oracle/XD3/origlogA/log_g13m1.dbf: Thread 1 Group 3 was previously cleared
Online log /oracle/XD3/mirrlogA/log_g13m2.dbf: Thread 1 Group 3 was previously cleared
Fri Dec 12 14:56:37 2008
Setting recovery target incarnation to 4
Fri Dec 12 14:56:37 2008
Assigning activation ID 1063378170 (0x3f61dcfa)
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=17, OS id=548978
Fri Dec 12 14:56:38 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=18, OS id=291066
Fri Dec 12 14:56:38 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 14:56:38 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 14:56:38 2008
ARC1: STARTING ARCH PROCESSES
Fri Dec 12 14:56:38 2008
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Dec 12 14:56:38 2008
SMON: enabling cache recovery
Fri Dec 12 14:56:38 2008
ARC2: Archival started
ARC1: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the heartbeat ARCH
ARC2 started with pid=19, OS id=282824
Fri Dec 12 14:56:39 2008
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Fri Dec 12 14:56:39 2008
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.3b.0]
Fri Dec 12 14:56:42 2008
Dictionary check complete
Fri Dec 12 14:56:42 2008
SMON: enabling tx recovery
Fri Dec 12 14:56:42 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=21, OS id=270462
Fri Dec 12 14:56:44 2008
LOGSTDBY: Validating controlfile with logical metadata
Fri Dec 12 14:56:44 2008
LOGSTDBY: Validation complete
Completed: ALTER DATABASE OPEN RESETLOGS
Fri Dec 12 14:57:15 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Fri Dec 12 14:57:15 2008
Media Recovery Start
Fri Dec 12 14:57:15 2008
Media Recovery failed with error 1124
ORA-283 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:57:34 2008
ALTER DATABASE CLOSE
Fri Dec 12 14:57:35 2008
Stopping background process CJQ0
Fri Dec 12 14:57:35 2008
SMON: disabling tx recovery
Fri Dec 12 14:57:35 2008
Stopping background process QMNC
Fri Dec 12 14:57:37 2008
Stopping Job queue slave processes
Fri Dec 12 14:57:37 2008
Job queue slave processes stopped
Fri Dec 12 14:57:37 2008
SMON: disabling cache recovery
Fri Dec 12 14:57:37 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 14:57:42 2008
ARCH shutting down
ARC2: Archival stopped
Fri Dec 12 14:57:52 2008
ARCH shutting down
Fri Dec 12 14:57:52 2008
ARC1: Becoming the heartbeat ARCH
Fri Dec 12 14:57:52 2008
ARC0: Archival stopped
Fri Dec 12 14:57:52 2008
ARC1: Archiving disabled
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 14:57:54 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 14:57:54 2008
Completed: ALTER DATABASE CLOSE
Fri Dec 12 14:57:57 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 14:58:33 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:58:33 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 14:58:33 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21518580
Fri Dec 12 14:58:33 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 14:58:53 2008
alter database open resetlogs
Fri Dec 12 14:58:53 2008
ORA-16196 signalled during: alter database open resetlogs...
Fri Dec 12 14:59:24 2008
Shutting down instance: further logons disabled
Fri Dec 12 14:59:24 2008
Stopping background process MMNL
Fri Dec 12 14:59:25 2008
Stopping background process MMON
Fri Dec 12 14:59:26 2008
Shutting down instance (immediate)
License high water mark = 4
Fri Dec 12 14:59:30 2008
PMON failed to acquire latch, see PMON dump
Fri Dec 12 14:59:30 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 14:59:30 2008
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Dec 12 14:59:30 2008
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
Fri Dec 12 15:15:09 2008
Starting ORACLE instance (normal)
Fri Dec 12 15:15:09 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=475178
PSP0 started with pid=3, OS id=389192
MMAN started with pid=4, OS id=471052
DBW0 started with pid=5, OS id=249992
LGWR started with pid=6, OS id=401636
CKPT started with pid=7, OS id=606270
SMON started with pid=8, OS id=614470
RECO started with pid=9, OS id=532514
CJQ0 started with pid=10, OS id=516240
MMON started with pid=11, OS id=524324
MMNL started with pid=12, OS id=344314
Fri Dec 12 15:15:09 2008
ALTER DATABASE MOUNT
Fri Dec 12 15:15:14 2008
Setting recovery target incarnation to 4
Fri Dec 12 15:15:14 2008
Successful mount of redo thread 1, with mount id 1063369149
Fri Dec 12 15:15:14 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 15:15:25 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Fri Dec 12 15:15:25 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 15:15:58 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 15:15:58 2008
Media Recovery Log /oracle/XD3/mirrlogB/log_g14m2.dbf
Fri Dec 12 15:15:58 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21518581
Fri Dec 12 15:15:59 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 15:16:08 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 15:16:15 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 15:16:15 2008
Media Recovery Log /oracle/XD3/mirrlogB/log_g14m2.dbf
Fri Dec 12 15:16:15 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21518581
Fri Dec 12 15:16:15 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 15:16:19 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 15:16:27 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 15:16:27 2008
Media Recovery Log /oracle/XD3/mirrlogB/log_g14m2.dbf
Fri Dec 12 15:16:27 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21518581
Fri Dec 12 15:16:27 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 15:16:37 2008
ALTER DATABASE RECOVER database using backup controlfile until cancel
Media Recovery Start
parallel recovery started with 3 processes
Fri Dec 12 15:16:38 2008
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Dec 12 15:17:32 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 15:17:32 2008
Media Recovery Log /oracle/XD3/mirrlogB/log_g14m2.dbf
Fri Dec 12 15:17:32 2008
Incomplete recovery applied all redo ever generated.
Recovery completed through change 21518581
Fri Dec 12 15:17:33 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/mirrlogB/log_g14m2.dbf'
Fri Dec 12 15:17:46 2008
alter database open noresetlogs
Fri Dec 12 15:17:46 2008
ORA-1588 signalled during: alter database open noresetlogs...
Fri Dec 12 15:17:58 2008
ALTER DATABASE OPEN RESETLOGS
Fri Dec 12 15:17:58 2008
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
RESETLOGS after incomplete recovery UNTIL CHANGE 21518581
Resetting resetlogs activation ID 1063378170 (0x3f61dcfa)
Online log /oracle/XD3/origlogA/log_g11m1.dbf: Thread 1 Group 1 was previously cleared
Online log /oracle/XD3/mirrlogA/log_g11m2.dbf: Thread 1 Group 1 was previously cleared
Online log /oracle/XD3/origlogB/log_g12m1.dbf: Thread 1 Group 2 was previously cleared
Online log /oracle/XD3/mirrlogB/log_g12m2.dbf: Thread 1 Group 2 was previously cleared
Online log /oracle/XD3/origlogA/log_g13m1.dbf: Thread 1 Group 3 was previously cleared
Online log /oracle/XD3/mirrlogA/log_g13m2.dbf: Thread 1 Group 3 was previously cleared
Fri Dec 12 15:18:02 2008
Setting recovery target incarnation to 5
Fri Dec 12 15:18:02 2008
Assigning activation ID 1063369149 (0x3f61b9bd)
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=17, OS id=377062
Fri Dec 12 15:18:03 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=18, OS id=282836
Fri Dec 12 15:18:03 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 15:18:03 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 15:18:03 2008
ARC0: STARTING ARCH PROCESSES
Fri Dec 12 15:18:03 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Dec 12 15:18:03 2008
ARC2: Archival started
Fri Dec 12 15:18:03 2008
SMON: enabling cache recovery
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=19, OS id=548994
Fri Dec 12 15:18:04 2008
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Fri Dec 12 15:18:04 2008
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.28.0]
Fri Dec 12 15:18:07 2008
Dictionary check complete
Fri Dec 12 15:18:07 2008
SMON: enabling tx recovery
Fri Dec 12 15:18:07 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=21, OS id=270470
Fri Dec 12 15:18:09 2008
LOGSTDBY: Validating controlfile with logical metadata
Fri Dec 12 15:18:09 2008
LOGSTDBY: Validation complete
Completed: ALTER DATABASE OPEN RESETLOGS
Fri Dec 12 15:19:02 2008
alter database close
Fri Dec 12 15:19:03 2008
SMON: disabling tx recovery
Fri Dec 12 15:19:03 2008
Stopping background process CJQ0
Fri Dec 12 15:19:03 2008
Stopping background process QMNC
Fri Dec 12 15:19:05 2008
Stopping Job queue slave processes
Fri Dec 12 15:19:05 2008
Job queue slave processes stopped
Fri Dec 12 15:19:06 2008
SMON: disabling cache recovery
Fri Dec 12 15:19:06 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 15:19:11 2008
ARCH shutting down
ARC2: Archival stopped
Fri Dec 12 15:19:16 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 15:19:21 2008
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 15:19:23 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 15:19:23 2008
Completed: alter database close
Shutting down instance: further logons disabled
Fri Dec 12 15:19:29 2008
Stopping background process MMNL
Fri Dec 12 15:19:30 2008
Stopping background process MMON
Fri Dec 12 15:19:31 2008
Shutting down instance (immediate)
License high water mark = 4
Fri Dec 12 15:19:35 2008
PMON failed to acquire latch, see PMON dump
Fri Dec 12 15:19:35 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 15:19:35 2008
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Dec 12 15:19:35 2008
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
Fri Dec 12 15:19:51 2008
Starting ORACLE instance (normal)
Fri Dec 12 15:19:51 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=401654
PSP0 started with pid=3, OS id=397396
MMAN started with pid=4, OS id=290824
DBW0 started with pid=5, OS id=524326
LGWR started with pid=6, OS id=344316
CKPT started with pid=7, OS id=548996
SMON started with pid=8, OS id=536618
RECO started with pid=9, OS id=282840
CJQ0 started with pid=10, OS id=389202
MMON started with pid=11, OS id=377066
MMNL started with pid=12, OS id=249998
Fri Dec 12 15:19:52 2008
ALTER DATABASE MOUNT
Fri Dec 12 15:19:56 2008
Setting recovery target incarnation to 5
Fri Dec 12 15:19:57 2008
Successful mount of redo thread 1, with mount id 1063339224
Fri Dec 12 15:19:57 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 15:19:57 2008
ALTER DATABASE OPEN
Fri Dec 12 15:19:57 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=475198
Fri Dec 12 15:19:57 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=15, OS id=270472
Fri Dec 12 15:19:57 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 15:19:57 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 15:19:57 2008
ARC1: STARTING ARCH PROCESSES
Fri Dec 12 15:19:57 2008
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Dec 12 15:19:57 2008
SMON: enabling cache recovery
Fri Dec 12 15:19:57 2008
ARC2: Archival started
ARC1: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the heartbeat ARCH
ARC2 started with pid=16, OS id=508000
Fri Dec 12 15:19:58 2008
Incremental checkpoint up to RBA [0x1.117.0], current log tail at RBA [0x1.131.0]
Fri Dec 12 15:19:58 2008
Successfully onlined Undo Tablespace 1.
Fri Dec 12 15:19:58 2008
SMON: enabling tx recovery
Fri Dec 12 15:19:58 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=258282
Fri Dec 12 15:20:01 2008
Completed: ALTER DATABASE OPEN
Fri Dec 12 15:25:57 2008
Shutting down archive processes
Fri Dec 12 15:26:02 2008
ARCH shutting down
ARC2: Archival stopped
Shutting down instance: further logons disabled
Fri Dec 12 15:36:35 2008
Stopping background process QMNC
Fri Dec 12 15:36:35 2008
Stopping background process CJQ0
Fri Dec 12 15:36:37 2008
Stopping background process MMNL
Fri Dec 12 15:36:38 2008
Stopping background process MMON
Fri Dec 12 15:36:39 2008
Shutting down instance (immediate)
License high water mark = 1
Fri Dec 12 15:36:39 2008
Stopping Job queue slave processes
Fri Dec 12 15:36:39 2008
Job queue slave processes stopped
Fri Dec 12 15:36:39 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 15:36:40 2008
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 12 15:36:41 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 15:36:46 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 15:36:51 2008
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 15:36:53 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 15:36:53 2008
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 12 15:36:53 2008
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
Fri Dec 12 15:37:08 2008
Starting ORACLE instance (normal)
Fri Dec 12 15:37:08 2008
Specified value of sga_max_size is too small, bumping to 2298478592
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =24
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.1.0.
System parameters with non-default values:
processes = 200
sessions = 225
event = 10191 trace name context forever, level 1
sga_max_size = 2298478592
shared_pool_size = 1124073472
shared_pool_reserved_size= 112340238
filesystemio_options = setall
control_files = /oracle/XD3/origlogA/cntrl/cntlrXD3.dbf, /oracle/XD3/origlogB/cntrl/cntrlXD3.dbf, /oracle/XD3/sapdata1/cntrl/cntrlXD3.dbf
control_file_record_keep_time= 30
db_block_size = 8192
db_cache_size = 1124073472
compatible = 10.2.0
log_archive_dest = /oracle/XD3/oraarch/XD3arch
log_buffer = 14306304
log_checkpoint_interval = 0
db_files = 254
allowresetlogs_corruption= TRUE
log_checkpoints_to_alert = TRUE
dml_locks = 4000
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
recyclebin = off
remote_os_authent = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes = 1
background_dump_dest = /oracle/XD3/saptrace/background
user_dump_dest = /oracle/XD3/saptrace/usertrace
core_dump_dest = /oracle/XD3/saptrace/background
optimizer_features_enable= 10.2.0.1
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = XD3
open_cursors = 800
optimpeek_user_binds = FALSE
pga_aggregate_target = 1497869844
workarea_size_policy = AUTO
statistics_level = typical
PMON started with pid=2, OS id=524328
PSP0 started with pid=3, OS id=397398
MMAN started with pid=4, OS id=344318
DBW0 started with pid=5, OS id=290826
LGWR started with pid=6, OS id=282842
CKPT started with pid=7, OS id=401656
SMON started with pid=8, OS id=475200
RECO started with pid=9, OS id=270474
CJQ0 started with pid=10, OS id=389204
MMON started with pid=11, OS id=377068
MMNL started with pid=12, OS id=250000
Fri Dec 12 15:37:09 2008
ALTER DATABASE MOUNT
Fri Dec 12 15:37:13 2008
Setting recovery target incarnation to 5
Fri Dec 12 15:37:13 2008
Successful mount of redo thread 1, with mount id 1063359973
Fri Dec 12 15:37:13 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Dec 12 15:37:26 2008
ALTER DATABASE RECOVER database using backup controlfile
Fri Dec 12 15:37:26 2008
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile ...
Fri Dec 12 15:38:03 2008
ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 15:38:03 2008
Media Recovery Log /oracle/XD3/origlogB/log_g14m1.dbf
Fri Dec 12 15:38:03 2008
Media Recovery Complete (XD3)
Completed: ALTER DATABASE RECOVER LOGFILE '/oracle/XD3/origlogB/log_g14m1.dbf'
Fri Dec 12 15:38:26 2008
ALTER DATABASE OPEN RESETLOGS
Fri Dec 12 15:38:26 2008
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
RESETLOGS after incomplete recovery UNTIL CHANGE 21528171
Resetting resetlogs activation ID 1063369149 (0x3f61b9bd)
Online log /oracle/XD3/origlogA/log_g11m1.dbf: Thread 1 Group 1 was previously cleared
Online log /oracle/XD3/mirrlogA/log_g11m2.dbf: Thread 1 Group 1 was previously cleared
Online log /oracle/XD3/origlogB/log_g12m1.dbf: Thread 1 Group 2 was previously cleared
Online log /oracle/XD3/mirrlogB/log_g12m2.dbf: Thread 1 Group 2 was previously cleared
Online log /oracle/XD3/origlogA/log_g13m1.dbf: Thread 1 Group 3 was previously cleared
Online log /oracle/XD3/mirrlogA/log_g13m2.dbf: Thread 1 Group 3 was previously cleared
Fri Dec 12 15:38:31 2008
Setting recovery target incarnation to 6
Fri Dec 12 15:38:31 2008
Assigning activation ID 1063359973 (0x3f6195e5)
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=17, OS id=335984
Fri Dec 12 15:38:31 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=18, OS id=192698
Fri Dec 12 15:38:31 2008
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: /oracle/XD3/origlogB/log_g14m1.dbf
Current log# 4 seq# 1 mem# 1: /oracle/XD3/mirrlogB/log_g14m2.dbf
Successful open of redo thread 1
Fri Dec 12 15:38:31 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Dec 12 15:38:31 2008
ARC0: STARTING ARCH PROCESSES
Fri Dec 12 15:38:31 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Dec 12 15:38:31 2008
SMON: enabling cache recovery
Fri Dec 12 15:38:31 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=19, OS id=508084
Fri Dec 12 15:38:32 2008
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Fri Dec 12 15:38:33 2008
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.29.0]
Fri Dec 12 15:38:35 2008
Dictionary check complete
Fri Dec 12 15:38:35 2008
SMON: enabling tx recovery
Fri Dec 12 15:38:35 2008
Database Characterset is WE8DEC
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=20, OS id=340096
Fri Dec 12 15:38:37 2008
LOGSTDBY: Validating controlfile with logical metadata
Fri Dec 12 15:38:37 2008
LOGSTDBY: Validation complete
Completed: ALTER DATABASE OPEN RESETLOGS
Fri Dec 12 15:39:58 2008
alter database recover
Fri Dec 12 15:39:58 2008
Media Recovery Start
Fri Dec 12 15:39:58 2008
Media Recovery failed with error 1124
ORA-283 signalled during: alter database recover...
Fri Dec 12 15:40:18 2008
alter database close
Fri Dec 12 15:40:19 2008
SMON: disabling tx recovery
Fri Dec 12 15:40:19 2008
Stopping background process CJQ0
Fri Dec 12 15:40:19 2008
Stopping background process QMNC
Fri Dec 12 15:40:21 2008
Stopping Job queue slave processes
Fri Dec 12 15:40:21 2008
Job queue slave processes stopped
Fri Dec 12 15:40:21 2008
SMON: disabling cache recovery
Fri Dec 12 15:40:22 2008
Shutting down archive processes
Archiving is disabled
Fri Dec 12 15:40:27 2008
ARCH shutting down
ARC2: Archival stopped
Fri Dec 12 15:40:32 2008
ARCH shutting down
ARC1: Archival stopped
Fri Dec 12 15:40:37 2008
ARC0: Becoming the heartbeat ARCH
ARC0: Archiving disabled
ARCH shutting down
ARC0: Archival stopped
Fri Dec 12 15:40:39 2008
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Fri Dec 12 15:40:39 2008
Completed: alter database close
Fri Dec 12 15:42:13 2008
Shutting down instance: further logons disabled
Fri Dec 12 15:42:13 2008
Stopping background process MMNL
Fri Dec 12 15:42:14 2008
Stopping background process MMON
Fri Dec 12 15:42:15 2008
Shutting down instance (immediate)
License high water mark = 4
Fri Dec 12 15:42:20 2008
PMON failed to acquire latch, see PMON dump
Fri Dec 12 15:42:20 2008
ALTER DATABASE CLOSE NORMAL
Fri Dec 12 15:42:20 2008
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Dec 12 15:42:20 2008
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
*******************************************************************************************
Start DB Log
-
Fri Dec 12 15:43:08 IST 2008
LOGFILE FOR STARTING ORACLE
Trying to start XD3 database ...
-
Fri Dec 12 15:43:08 IST 2008
checking required environment variables
ORACLE_HOME is >/oracle/XD3/102_64<
ORACLE_SID is >XD3<
-
Fri Dec 12 15:43:08 IST 2008
check initora
-
Fri Dec 12 15:43:08 IST 2008
check initora
-
Fri Dec 12 15:43:08 IST 2008
checking V2 connect
TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 12-DEC-2008 15:43:08
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/usr/sap/XD3/SYS/profile/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = xidev3) (PORT = 1527))) (CONNECT_DATA = (SID = XD3) (GLOBAL_NAME = XD3.WORLD)))
TNS-12541: TNS:no listener
V2 connect is not available. Terminating
/usr/sap/XD3/SYS/exe/run/startdb: Terminating with error code 14
************************************************************************************************************
Trans Log
4 ETW000 R3trans version 6.14 (release 700 - 24.04.08 - 14:09:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 12.12.2008 - 16:08:14
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Fri Dec 12 16:08:14 2008 50 0.000050
4 ETW000 [dev trc ,00000] db_con_init called 9 0.000059
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 24 0.000083
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/XD3/SYS/exe/run/dboraslib.o' ...
4 ETW000 30 0.000113
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/XD3/SYS/exe/run/dboraslib.o), hdl 0
4 ETW000 4498 0.004611
4 ETW000 [dev trc ,00000] Library '/usr/sap/XD3/SYS/exe/run/dboraslib.o' loaded
4 ETW000 13 0.004624
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/XD3/SYS/exe/run/dboraslib.o
4 ETW000 16 0.004640
4 ETW000 [dev trc ,00000] Version of '/usr/sap/XD3/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.73)
4 ETW000 122 0.004762
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/XD3/SYS/exe/run/dboraslib.o
4 ETW000 15 0.004777
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/XD3/SYS/exe/run/dboraslib.o
4 ETW000 33 0.004810
4 ETW000 [dev trc ,00000] New connection 0 created 13 0.004823
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 19 0.004842
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 20 0.004862
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 15 0.004877
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 16 0.004893
4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/XD3/SYS/exe/run:/oracle/client/10x_64/instantclient from environment
4 ETW000 210 0.005103
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 41 0.005144
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 9 0.005153
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 1383 0.006536
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 17 0.006553
4 ETW000 [dev trc ,00000] Connecting as /@XD3 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
4 ETW000 15 0.006568
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 15 0.006583
4 ETW000 [dev trc ,00000] 0 WE8DEC 1 1109b6e00 1109c2498 1109c1d48
4 ETW000 24 0.006607
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 10 0.006617
4 ETW000 [dev trc ,00000] Allocating server context handle 10 0.006627
4 ETW000 [dev trc ,00000] Attaching to DB Server XD3 (con_hdl=0,svchp=1109bf7d8,svrhp=1109c47b8)
4 ETW000 42 0.006669
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
4 ETW000 2816 0.009485
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 16 0.009501
4 ETW000 [dev trc ,00000] Try to connect with default password 10 0.009511
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@XD3 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
4 ETW000 15 0.009526
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 15 0.009541
4 ETW000 [dev trc ,00000] 0 WE8DEC 1 1109b6e00 1109c2498 1109c1d48
4 ETW000 15 0.009556
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=1109c47b8)
4 ETW000 14 0.009570
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1109bf7d8,srvhp=1109c47b8)
4 ETW000 14 0.009584
4 ETW000 [dev trc ,00000] Deallocating server context handle 1109c47b8 11 0.009595
4 ETW000 [dev trc ,00000] Allocating server context handle 12 0.009607
4 ETW000 [dev trc ,00000] Attaching to DB Server XD3 (con_hdl=0,svchp=1109bf7d8,svrhp=1109c47b8)
4 ETW000 19 0.009626
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
4 ETW000 1115 0.010741
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 15 0.010756
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12541 performing CON [dblink#5 @ 431]
4 ETW000 35 0.010791
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#5 @ 431]
4 ETW000 14 0.010805
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'XD3'"
*************************************************************************************************************************************
Kindly suggest the solution to resolve the issues.
Regards
Santosh
Here is trans log
4 ETW000 R3trans version 6.14 (release 700 - 24.04.08 - 14:09:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 12.12.2008 - 16:08:14
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Fri Dec 12 16:08:14 2008 50 0.000050
4 ETW000 [dev trc ,00000] db_con_init called 9 0.000059
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 24 0.000083
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/XD3/SYS/exe/run/dboraslib.o' ...
4 ETW000 30 0.000113
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/XD3/SYS/exe/run/dboraslib.o), hdl 0
4 ETW000 4498 0.004611
4 ETW000 [dev trc ,00000] Library '/usr/sap/XD3/SYS/exe/run/dboraslib.o' loaded
4 ETW000 13 0.004624
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/XD3/SYS/exe/run/dboraslib.o
4 ETW000 16 0.004640
4 ETW000 [dev trc ,00000] Version of '/usr/sap/XD3/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.73)
4 ETW000 122 0.004762
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/XD3/SYS/exe/run/dboraslib.o
4 ETW000 15 0.004777
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/XD3/SYS/exe/run/dboraslib.o
4 ETW000 33 0.004810
4 ETW000 [dev trc ,00000] New connection 0 created 13 0.004823
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 19 0.004842
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 20 0.004862
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 15 0.004877
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 16 0.004893
4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/XD3/SYS/exe/run:/oracle/client/10x_64/instantclient from environment
4 ETW000 210 0.005103
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 41 0.005144
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 9 0.005153
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 1383 0.006536
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 17 0.006553
4 ETW000 [dev trc ,00000] Connecting as /@XD3 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
4 ETW000 15 0.006568
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 15 0.006583
4 ETW000 [dev trc ,00000] 0 WE8DEC 1 1109b6e00 1109c2498 1109c1d48
4 ETW000 24 0.006607
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 10 0.006617
4 ETW000 [dev trc ,00000] Allocating server context handle 10 0.006627
4 ETW000 [dev trc ,00000] Attaching to DB Server XD3 (con_hdl=0,svchp=1109bf7d8,svrhp=1109c47b8)
4 ETW000 42 0.006669
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
4 ETW000 2816 0.009485
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 16 0.009501
4 ETW000 [dev trc ,00000] Try to connect with default password 10 0.009511
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@XD3 on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
4 ETW000 15 0.009526
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 15 0.009541
4 ETW000 [dev trc ,00000] 0 WE8DEC 1 1109b6e00 1109c2498 1109c1d48
4 ETW000 15 0.009556
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=1109c47b8)
4 ETW000 14 0.009570
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=1109bf7d8,srvhp=1109c47b8)
4 ETW000 14 0.009584
4 ETW000 [dev trc ,00000] Deallocating server context handle 1109c47b8 11 0.009595
4 ETW000 [dev trc ,00000] Allocating server context handle 12 0.009607
4 ETW000 [dev trc ,00000] Attaching to DB Server XD3 (con_hdl=0,svchp=1109bf7d8,svrhp=1109c47b8)
4 ETW000 19 0.009626
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541
4 ETW000 1115 0.010741
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'
4 ETW000 15 0.010756
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12541 performing CON [dblink#5 @ 431]
4 ETW000 35 0.010791
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#5 @ 431]
4 ETW000 14 0.010805
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'XD3'"
*********************************************************************************************************************************
startDB log
-
Fri Dec 12 15:43:08 IST 2008
LOGFILE FOR STARTING ORACLE
Trying to start XD3 database ...
-
Fri Dec 12 15:43:08 IST 2008
checking required environment variables
ORACLE_HOME is >/oracle/XD3/102_64<
ORACLE_SID is >XD3<
-
Fri Dec 12 15:43:08 IST 2008
check initora
-
Fri Dec 12 15:43:08 IST 2008
check initora
-
Fri Dec 12 15:43:08 IST 2008
checking V2 connect
TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 12-DEC-2008 15:43:08
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/usr/sap/XD3/SYS/profile/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = xidev3) (PORT = 1527))) (CONNECT_DATA = (SID = XD3) (GLOBAL_NAME = XD3.WORLD)))
TNS-12541: TNS:no listener
V2 connect is not available. Terminating
/usr/sap/XD3/SYS/exe/run/startdb: Terminating with error code 14
Hi Santosh,
I am asking about youe target system, the system where you did the system copy, did you check that the contorl files are created successfully and you have deleted the old controlfile.
Let me know the steps you have followed so that it will be easy to trace out the thing if some thing missed.
Please confirm few things:
1, Are you able to start the database without any error with the user orasid?
2. Listner also started by the user oraSID ?.
3. Check R3trans -d from the userid SIDadm? let me know the return code and R3trans log ?
3. After you tried to start SAP and when it fails , Please check your listener status,whether it is running or terminating ?
Thanks & Regards,
Satyabrat
Edited by: Satyabrat Mohanty on Dec 17, 2008 12:42 PM
HI satyabrat,
Yes i can able to work in database through toad and also through sqlplus.
but when i try to start sap through sidadm user its throughing out with return code 12.
Yes i can able to start listener through orasid user n its getting started successfully.
I searched a lot on forums and some of my seniors everybody is saying sap should start your procedure is correct.
I just wanted to know that wheather we have to do some changes in oracle databse????
i believe something is missing that i havent done.
Also i wwanted to ask you as i am dng syscopy betwwen two diff systems and also their sid's are different wheather this happening because of this???
One more thing i checked is dat when i logged in to database through toad (third party software) i saw that there are users are of source sid in the database schema .
Regards
Santosh.
Hi,
Ok,
1. Can you lete me know which procedure you are following to resotre the database ?
2. Have you executed the ops$ Script?
3. Are you able to start the oracle from os level directly by the following command
e.g. su - oraSID
sqlplus /nolog
SQL> connect /as sysdba
SQL> Startup
4. How created the control files ?
Thanks,
Satyabrat
Hi Santosh,
Please let me know
1.Whether you successfully restore your database ?
2.Confirm your oracle file system are there, as in your document it suggested to remove the file system.
3.Are you successfully created the control file ?
4. Just try to start the database by the command I suggested before and let me know whether you can start it or not.
Thanks,
Satyabrat
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.