程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SyBase數據庫 >> SyBase教程 >> alter database open resetlogs時alert的輸出

alter database open resetlogs時alert的輸出

編輯:SyBase教程

alter database open resetlogs時alert的輸出


SQL> alter database open resetlogs;

Database altered.
時的提示:

ORA-279 signalled during: ALTER DATABASE RECOVER datafile 5 ...
ALTER DATABASE RECOVER CANCEL
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Sat Apr 18 18:41:33 2015
alter database open resetlogs
ORA-1139 signalled during: alter database open resetlogs...
Sat Apr 18 18:42:06 2015
ALTER DATABASE RECOVER database until cancel
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 4 slaves
Sat Apr 18 18:42:06 2015
Warning: Datafile 5 (/u01/app/oracle/oradata/test/ten01.dbf) is offline during full database recovery and will not be recovered
Media Recovery Not Required
Completed: ALTER DATABASE RECOVER database until cancel
Sat Apr 18 18:42:23 2015
alter database open resetlogs
RESETLOGS after complete recovery through change 3580552
Archived Log entry 28 added for thread 1 sequence 155 ID 0x7d875fb4 dest 1:
Resetting resetlogs activation ID 2106023860 (0x7d875fb4)
Sat Apr 18 18:42:28 2015
Setting recovery target incarnation to 3
Sat Apr 18 18:42:28 2015
Assigning activation ID 2175494118 (0x81ab67e6)
LGWR: STARTING ARCH PROCESSES
Sat Apr 18 18:42:28 2015
ARC0 started with pid=20, OS id=3826
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Apr 18 18:42:29 2015
ARC1 started with pid=21, OS id=3828
Sat Apr 18 18:42:29 2015
ARC2 started with pid=22, OS id=3830
Sat Apr 18 18:42:29 2015
ARC3 started with pid=23, OS id=3832
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/test/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Apr 18 18:42:29 2015
SMON: enabling cache recovery
[3781] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:11031024 end:11032224 diff:1200 (12 seconds)
Dictionary check beginning
File #5 is offline, but is part of an online tablespace.
data file 5: '/u01/app/oracle/oradata/test/ten01.dbf'
File #12 is offline, but is part of an online tablespace.
data file 12: '/u01/app/oracle/oradata/test/test.dbf'
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
Sat Apr 18 18:42:33 2015
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sat Apr 18 18:42:37 2015
QMNC started with pid=24, OS id=3834
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Sat Apr 18 18:42:50 2015
Completed: alter database open resetlogs
Sat Apr 18 18:42:50 2015
Starting background process CJQ0
Sat Apr 18 18:42:50 2015
CJQ0 started with pid=27, OS id=3854
Sat Apr 18 18:42:51 2015
Checker run found 2 new persistent data failures

 

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved