折腾了好多天,费了好大劲,终于在linux el4 系统上安装oracle了,cool~ 庆祝一下运行dbca出错问题已解决,应该是软件包不全的缘
折腾了好多天,,费了好大劲,终于在linux el4 系统上安装oracle了,cool~ 庆祝一下
运行dbca出错问题已解决,应该是软件包不全的缘故,安装了需要的软件包,卸载了以前的安装,重新安装过程中虽然出了一些错误,最终还是安装成功了
总结:需要的rpm包大多在安装盘里有,应该首先查找安装盘,(哎网上找安装包够辛苦的....),安装盘没有的可以到网上下载,最好是官方的网站。
不要轻易放弃你坚持的事,多总结经验教训,成功只是早晚的事
附一下alertlog日志:
fri sep 17 10:35:24 2010
starting oracle instance (normal)
license_max_session = 0
license_sessions_warning = 0
shared memory segment for instance monitoring created
picked latch-free scn scheme 2
using log_archive_dest_10 parameter default value as use_db_recovery_file_dest
autotune of undo retention is turned on.
imode=br
ilat =18
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 = 150
sga_target = 167772160
control_files = /u01/oracle/oradata/myoracle/control01.ctl, /u01/oracle/oradata/myoracle/control02.ctl, /u01/oracle/oradata/myoracle/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = auto
undo_tablespace = undotbs1
remote_login_passwordfile= exclusive
db_domain =
dispatchers = (protocol=tcp) (service=myoraclexdb)
job_queue_processes = 10
background_dump_dest = /u01/oracle/admin/myoracle/bdump
user_dump_dest = /u01/oracle/admin/myoracle/udump
core_dump_dest = /u01/oracle/admin/myoracle/cdump
audit_file_dest = /u01/oracle/admin/myoracle/adump
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 16777216
psp0 started with pid=3, os id=27857
mman started with pid=4, os id=27859
dbw0 started with pid=5, os id=27861
pmon started with pid=2, os id=27855
lgwr started with pid=6, os id=27863
ckpt started with pid=7, os id=27865
reco started with pid=9, os id=27869
cjq0 started with pid=10, os id=27871
mmon started with pid=11, os id=27873
fri sep 17 10:35:26 2010
starting up 1 dispatcher(s) for network address '(address=(partial=yes)(protocol=tcp))'...
mmnl started with pid=12, os id=27875
smon started with pid=8, os id=27867
fri sep 17 10:35:26 2010
starting up 1 shared server(s) ...
fri sep 17 10:35:28 2010
the input backup piece /u01/oracle/product/10.2.0/db_1/assistants/dbca/templates/seed_database.dfb is in compressed format.
full restore complete of datafile 4 to datafile copy /u01/oracle/oradata/myoracle/users01.dbf. elapsed time: 0:00:00
checkpoint is 446074
full restore complete of datafile 2 to datafile copy /u01/oracle/oradata/myoracle/undotbs01.dbf. elapsed time: 0:00:01
checkpoint is 446074
fri sep 17 10:36:00 2010
full restore complete of datafile 3 to datafile copy /u01/oracle/oradata/myoracle/sysaux01.dbf. elapsed time: 0:00:31
checkpoint is 446074
fri sep 17 10:36:23 2010
full restore complete of datafile 1 to datafile copy /u01/oracle/oradata/myoracle/system01.dbf. elapsed time: 0:00:53
checkpoint is 446074
fri sep 17 10:36:27 2010
create controlfile reuse set database myoracle
maxinstances 8
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
datafile
'/u01/oracle/oradata/myoracle/system01.dbf',
'/u01/oracle/oradata/myoracle/undotbs01.dbf',
'/u01/oracle/oradata/myoracle/sysaux01.dbf',
'/u01/oracle/oradata/myoracle/users01.dbf'
logfile group 1 ('/u01/oracle/oradata/myoracle/redo01.log') size 51200k,
group 2 ('/u01/oracle/oradata/myoracle/redo02.log') size 51200k,
group 3 ('/u01/oracle/oradata/myoracle/redo03.log') size 51200k resetlogs
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 sep 17 10:36:29 2010
successful mount of redo thread 1, with mount id 1828633323
fri sep 17 10:36:29 2010
completed: create controlfile reuse set database myoracle
maxinstances 8
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
datafile
'/u01/oracle/oradata/myoracle/system01.dbf',
'/u01/oracle/oradata/myoracle/undotbs01.dbf',
'/u01/oracle/oradata/myoracle/sysaux01.dbf',
'/u01/oracle/oradata/myoracle/users01.dbf'
logfile group 1 ('/u01/oracle/oradata/myoracle/redo01.log') size 51200k,
group 2 ('/u01/oracle/oradata/myoracle/redo02.log') size 51200k,
group 3 ('/u01/oracle/oradata/myoracle/redo03.log') size 51200k resetlogs
shutting down instance: further logons disabled
fri sep 17 10:36:29 2010
stopping background process cjq0
fri sep 17 10:36:29 2010
stopping background process mmnl
fri sep 17 10:36:30 2010
stopping background process mmon
fri sep 17 10:36:31 2010
shutting down instance (immediate)
license high water mark = 1
fri sep 17 10:36:31 2010
stopping job queue slave processes
fri sep 17 10:36:31 2010
job queue slave processes stopped
all dispatchers and shared servers shutdown
fri sep 17 10:36:31 2010
alter database close normal
ora-1109 signalled during: alter database close normal...
fri sep 17 10:36:31 2010
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 sep 17 10:36:35 2010
starting oracle instance (normal)
license_max_session = 0
license_sessions_warning = 0
picked latch-free scn scheme 2
using log_archive_dest_10 parameter default value as use_db_recovery_file_dest
autotune of undo retention is turned on.
imode=br
ilat =18
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 = 150
sga_target = 167772160
control_files = /u01/oracle/oradata/myoracle/control01.ctl, /u01/oracle/oradata/myoracle/control02.ctl, /u01/oracle/oradata/myoracle/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_no_recovery_through_resetlogs= true
undo_management = auto
undo_tablespace = undotbs1
remote_login_passwordfile= exclusive
db_domain =
dispatchers = (protocol=tcp) (service=myoraclexdb)
background_dump_dest = /u01/oracle/admin/myoracle/bdump
user_dump_dest = /u01/oracle/admin/myoracle/udump
core_dump_dest = /u01/oracle/admin/myoracle/cdump
audit_file_dest = /u01/oracle/admin/myoracle/adump
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 16777216
pmon started with pid=2, os id=27913
psp0 started with pid=3, os id=27915
mman started with pid=4, os id=27917
dbw0 started with pid=5, os id=27919
lgwr started with pid=6, os id=27921
ckpt started with pid=7, os id=27923
smon started with pid=8, os id=27925
reco started with pid=9, os id=27927
mmon started with pid=10, os id=27929
fri sep 17 10:36:37 2010
starting up 1 dispatcher(s) for network address '(address=(partial=yes)(protocol=tcp))'...
mmnl started with pid=11, os id=27931
fri sep 17 10:36:37 2010
starting up 1 shared server(s) ...
fri sep 17 10:36:37 2010
create controlfile reuse set database myoracle
maxinstances 8
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
datafile
'/u01/oracle/oradata/myoracle/system01.dbf',
'/u01/oracle/oradata/myoracle/undotbs01.dbf',
'/u01/oracle/oradata/myoracle/sysaux01.dbf',
'/u01/oracle/oradata/myoracle/users01.dbf'
logfile group 1 ('/u01/oracle/oradata/myoracle/redo01.log') size 51200k,
group 2 ('/u01/oracle/oradata/myoracle/redo02.log') size 51200k,
group 3 ('/u01/oracle/oradata/myoracle/redo03.log') size 51200k resetlogs
fri sep 17 10:36:37 2010
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 sep 17 10:36:38 2010
successful mount of redo thread 1, with mount id 1828636405
fri sep 17 10:36:38 2010
completed: create controlfile reuse set database myoracle
maxinstances 8
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
datafile
'/u01/oracle/oradata/myoracle/system01.dbf',
'/u01/oracle/oradata/myoracle/undotbs01.dbf',
'/u01/oracle/oradata/myoracle/sysaux01.dbf',
'/u01/oracle/oradata/myoracle/users01.dbf'
logfile group 1 ('/u01/oracle/oradata/myoracle/redo01.log') size 51200k,
group 2 ('/u01/oracle/oradata/myoracle/redo02.log') size 51200k,
group 3 ('/u01/oracle/oradata/myoracle/redo03.log') size 51200k resetlogs
fri sep 17 10:36:38 2010
stopping background process mmnl
fri sep 17 10:36:38 2010
stopping background process mmon
starting background process mmon
starting background process mmnl
mmon started with pid=10, os id=27938
fri sep 17 10:36:38 2010
alter system enable restricted session;
fri sep 17 10:36:38 2010
alter database myoracle open resetlogs
mmnl started with pid=11, os id=27940
fri sep 17 10:36:38 2010
resetlogs after incomplete recovery until change 446074
fri sep 17 10:36:38 2010
errors in file /u01/oracle/admin/myoracle/udump/myoracle_ora_27936.trc:
ora-00313: open failed for members of log group 1 of thread 1
ora-00312: online log 1 thread 1: '/u01/oracle/oradata/myoracle/redo01.log'
ora-27037: unable to obtain file status
linux error: 2: no such file or directory
additional information: 3
fri sep 17 10:36:40 2010
errors in file /u01/oracle/admin/myoracle/udump/myoracle_ora_27936.trc:
ora-00313: open failed for members of log group 2 of thread 1
ora-00312: online log 2 thread 1: '/u01/oracle/oradata/myoracle/redo02.log'
ora-27037: unable to obtain file status
linux error: 2: no such file or directory
additional information: 3
fri sep 17 10:36:41 2010
errors in file /u01/oracle/admin/myoracle/udump/myoracle_ora_27936.trc:
ora-00313: open failed for members of log group 3 of thread 1
ora-00312: online log 3 thread 1: '/u01/oracle/oradata/myoracle/redo03.log'
ora-27037: unable to obtain file status
linux error: 2: no such file or directory
additional information: 3
fri sep 17 10:36:44 2010
setting recovery target incarnation to 2
fri sep 17 10:36:44 2010
assigning activation id 1828636405 (0x6cfec6f5)
thread 1 opened at log sequence 1
current log# 3 seq# 1 mem# 0: /u01/oracle/oradata/myoracle/redo03.log
successful open of redo thread 1
fri sep 17 10:36:44 2010
mttr advisory is disabled because fast_start_mttr_target is not set
fri sep 17 10:36:44 2010
smon: enabling cache recovery
fri sep 17 10:36:47 2010
successfully onlined undo tablespace 1.
dictionary check beginning
tablespace 'temp' #3 found in data dictionary,
but not in the controlfile. adding to controlfile.
dictionary check complete
fri sep 17 10:36:47 2010
smon: enabling tx recovery
fri sep 17 10:36:47 2010
*********************************************************************
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 add tempfile
alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
empty temporary tablespace: temp
*********************************************************************
database characterset is us7ascii
threshold validation cannot be done before catproc is loaded.
threshold validation cannot be done before catproc is loaded.
**********************************************************
warning: files may exists in db_recovery_file_dest
that are not known to the database. use the rman command
catalog recovery area to re-catalog any such files.
one of the following events caused this:
1. a backup controlfile was restored.
2. a standby controlfile was restored.
3. the controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
starting background process qmnc
qmnc started with pid=15, os id=27942
fri sep 17 10:36:55 2010
logstdby: validating controlfile with logical metadata
fri sep 17 10:36:55 2010
logstdby: validation complete
global name changed to myoracle
completed: alter database myoracle open resetlogs
fri sep 17 10:36:59 2010
alter database rename global_name to myoracle
completed: alter database rename global_name to myoracle
fri sep 17 10:36:59 2010
alter tablespace temp add tempfile '/u01/oracle/oradata/myoracle/temp01.dbf' size 20480k reuse autoextend on next 640k maxsize unlimited
completed: alter tablespace temp add tempfile '/u01/oracle/oradata/myoracle/temp01.dbf' size 20480k reuse autoextend on next 640k maxsize unlimited
fri sep 17 10:36:59 2010
alter database default tablespace users
completed: alter database default tablespace users
fri sep 17 10:37:03 2010
alter system disable restricted session;
fri sep 17 10:37:03 2010
db_recovery_file_dest_size of 2048 mb is 0.00% used. this is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or asm diskgroup.
fri sep 17 10:37:08 2010
starting background process cjq0
cjq0 started with pid=19, os id=27967
fri sep 17 10:37:09 2010
the input backup piece /u01/oracle/product/10.2.0/db_1/assistants/dbca/templates/example01.dfb is in compressed format.
full restore complete of datafile 5 to datafile copy /u01/oracle/oradata/myoracle/example01.dbf. elapsed time: 0:00:07
checkpoint is 460200
fri sep 17 10:37:18 2010
alter tablespace example read write
ora-959 signalled during: alter tablespace example read write...
fri sep 17 10:37:28 2010
memory notification: library cache object loaded into sga
heap size 2213k exceeds notification threshold (2048k)
kgl object name :xdb.xdbd/plz01tchgnagaiiegtw==
fri sep 17 10:38:53 2010
starting background process emn0
emn0 started with pid=18, os id=28077
fri sep 17 10:38:53 2010
shutting down instance: further logons disabled
fri sep 17 10:38:55 2010
stopping background process cjq0
fri sep 17 10:38:55 2010
stopping background process qmnc
fri sep 17 10:38:56 2010
stopping background process mmnl
fri sep 17 10:38:56 2010
stopping background process mmon
fri sep 17 10:38:57 2010
shutting down instance (immediate)
license high water mark = 4
all dispatchers and shared servers shutdown
fri sep 17 10:39:04 2010
alter database close normal
fri sep 17 10:39:05 2010
smon: disabling tx recovery
smon: disabling cache recovery
fri sep 17 10:39:05 2010
shutting down archive processes
archiving is disabled
archive process shutdown avoided: 0 active
thread 1 closed at log sequence 1
successful close of redo thread 1
fri sep 17 10:39:05 2010
completed: alter database close normal
fri sep 17 10:39:05 2010
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 sep 17 10:39:08 2010
starting oracle instance (normal)
license_max_session = 0
license_sessions_warning = 0
picked latch-free scn scheme 2
using log_archive_dest_10 parameter default value as use_db_recovery_file_dest
autotune of undo retention is turned on.
imode=br
ilat =18
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 = 150
sga_target = 167772160
control_files = /u01/oracle/oradata/myoracle/control01.ctl, /u01/oracle/oradata/myoracle/control02.ctl, /u01/oracle/oradata/myoracle/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_no_recovery_through_resetlogs= true
undo_management = auto
undo_tablespace = undotbs1
remote_login_passwordfile= exclusive
db_domain =
dispatchers = (protocol=tcp) (service=myoraclexdb)
background_dump_dest = /u01/oracle/admin/myoracle/bdump
user_dump_dest = /u01/oracle/admin/myoracle/udump
core_dump_dest = /u01/oracle/admin/myoracle/cdump
audit_file_dest = /u01/oracle/admin/myoracle/adump
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 16777216
pmon started with pid=2, os id=28080
psp0 started with pid=3, os id=28082
mman started with pid=4, os id=28084
dbw0 started with pid=5, os id=28086
lgwr started with pid=6, os id=28088
smon started with pid=8, os id=28092
ckpt started with pid=7, os id=28090
reco started with pid=9, os id=28094
mmon started with pid=10, os id=28096
fri sep 17 10:39:10 2010
starting up 1 dispatcher(s) for network address '(address=(partial=yes)(protocol=tcp))'...
mmnl started with pid=11, os id=28098
fri sep 17 10:39:10 2010
starting up 1 shared server(s) ...
fri sep 17 10:39:10 2010
alter database mount
fri sep 17 10:39:14 2010
setting recovery target incarnation to 2
fri sep 17 10:39:14 2010
successful mount of redo thread 1, with mount id 1828598926
fri sep 17 10:39:14 2010
database mounted in exclusive mode
completed: alter database mount
fri sep 17 10:39:14 2010
alter database open
fri sep 17 10:39:14 2010
thread 1 opened at log sequence 1
current log# 3 seq# 1 mem# 0: /u01/oracle/oradata/myoracle/redo03.log
successful open of redo thread 1
fri sep 17 10:39:14 2010
mttr advisory is disabled because fast_start_mttr_target is not set
fri sep 17 10:39:14 2010
smon: enabling cache recovery
fri sep 17 10:39:15 2010
successfully onlined undo tablespace 1.
fri sep 17 10:39:15 2010
smon: enabling tx recovery
fri sep 17 10:39:15 2010
database characterset is us7ascii
replication_dependency_tracking turned off (no async multimaster replication found)
starting background process qmnc
qmnc started with pid=15, os id=28106
fri sep 17 10:39:20 2010
completed: alter database open
fri sep 17 10:39:20 2010
stopping background process mmnl
fri sep 17 10:39:20 2010
stopping background process mmon
fri sep 17 10:39:20 2010
db_recovery_file_dest_size of 2048 mb is 0.00% used. this is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or asm diskgroup.
fri sep 17 10:39:21 2010
starting background process mmon
starting background process mmnl
fri sep 17 10:39:21 2010
alter system enable restricted session;
fri sep 17 10:39:21 2010
alter database character set internal_convert we8iso8859p1
mmnl started with pid=11, os id=28123
mmon started with pid=10, os id=28121
fri sep 17 10:39:27 2010
updating character set in controlfile to we8iso8859p1
synchronizing connection with database character set information
refreshing type attributes with new character set information
completed: alter database character set internal_convert we8iso8859p1
fri sep 17 10:39:31 2010
alter system disable restricted session;
fri sep 17 10:39:40 2010
starting background process emn0
emn0 started with pid=18, os id=28141
fri sep 17 10:39:40 2010
shutting down instance: further logons disabled
fri sep 17 10:39:45 2010
stopping background process qmnc
fri sep 17 10:39:47 2010
stopping background process mmnl
fri sep 17 10:39:48 2010
stopping background process mmon
fri sep 17 10:39:49 2010
shutting down instance (immediate)
license high water mark = 1
all dispatchers and shared servers shutdown
fri sep 17 10:39:56 2010
alter database close normal
fri sep 17 10:39:57 2010
smon: disabling tx recovery
smon: disabling cache recovery
fri sep 17 10:39:57 2010
shutting down archive processes
archiving is disabled
archive process shutdown avoided: 0 active
thread 1 closed at log sequence 1
successful close of redo thread 1
fri sep 17 10:39:57 2010
completed: alter database close normal
fri sep 17 10:39:57 2010
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 sep 17 10:39:58 2010
starting oracle instance (normal)
license_max_session = 0
license_sessions_warning = 0
picked latch-free scn scheme 2
using log_archive_dest_10 parameter default value as use_db_recovery_file_dest
autotune of undo retention is turned on.
imode=br
ilat =18
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 = 150
sga_target = 167772160
control_files = /u01/oracle/oradata/myoracle/control01.ctl, /u01/oracle/oradata/myoracle/control02.ctl, /u01/oracle/oradata/myoracle/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = auto
undo_tablespace = undotbs1
remote_login_passwordfile= exclusive
db_domain =
dispatchers = (protocol=tcp) (service=myoraclexdb)
job_queue_processes = 10
background_dump_dest = /u01/oracle/admin/myoracle/bdump
user_dump_dest = /u01/oracle/admin/myoracle/udump
core_dump_dest = /u01/oracle/admin/myoracle/cdump
audit_file_dest = /u01/oracle/admin/myoracle/adump
db_name = myoracle
open_cursors = 300
pga_aggregate_target = 16777216
pmon started with pid=2, os id=28157
psp0 started with pid=3, os id=28159
mman started with pid=4, os id=28161
dbw0 started with pid=5, os id=28163
lgwr started with pid=6, os id=28165
ckpt started with pid=7, os id=28167
smon started with pid=8, os id=28169
reco started with pid=9, os id=28171
cjq0 started with pid=10, os id=28173
mmon started with pid=11, os id=28175
fri sep 17 10:39:59 2010
starting up 1 dispatcher(s) for network address '(address=(partial=yes)(protocol=tcp))'...
mmnl started with pid=12, os id=28177
fri sep 17 10:39:59 2010
starting up 1 shared server(s) ...
fri sep 17 10:39:59 2010
alter database mount
fri sep 17 10:40:03 2010
setting recovery target incarnation to 2
fri sep 17 10:40:03 2010
successful mount of redo thread 1, with mount id 1828608703
fri sep 17 10:40:03 2010
database mounted in exclusive mode
completed: alter database mount
fri sep 17 10:40:03 2010
alter database open
fri sep 17 10:40:03 2010
thread 1 opened at log sequence 1
current log# 3 seq# 1 mem# 0: /u01/oracle/oradata/myoracle/redo03.log
successful open of redo thread 1
fri sep 17 10:40:03 2010
mttr advisory is disabled because fast_start_mttr_target is not set
fri sep 17 10:40:03 2010
smon: enabling cache recovery
fri sep 17 10:40:04 2010
successfully onlined undo tablespace 1.
fri sep 17 10:40:04 2010
smon: enabling tx recovery
fri sep 17 10:40:04 2010
database characterset is we8iso8859p1
replication_dependency_tracking turned off (no async multimaster replication found)
starting background process qmnc
qmnc started with pid=16, os id=28188
fri sep 17 10:40:08 2010
db_recovery_file_dest_size of 2048 mb is 0.00% used. this is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or asm diskgroup.
fri sep 17 10:40:08 2010
completed: alter database open
fri sep 17 10:56:12 2010
thread 1 advanced to log sequence 2
current log# 1 seq# 2 mem# 0: /u01/oracle/oradata/myoracle/redo01.log