ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Standby DB 增加数据文件

Standby DB 增加数据文件

原创 Linux操作系统 作者:yanggq 时间:2019-07-08 21:15:07 0 删除 编辑

1.22 Standby DB关闭,1.23给PRIMARY DB增加了一个数据文件,结果在standby DB中发现错误。


alter database register physical logfile 'D:FTPlogARC01493_001.Arc'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Error locating archivelog filename 'D:FTPlogARC01493_001.Arc': 308
ORA-308 signalled during: alter database register physical logfile 'D:FTPl...
Mon Jan 23 13:00:04 2006
alter database register physical logfile 'D:FTPARC01493_001.Arc'
Mon Jan 23 13:00:04 2006
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Register archivelog D:FTPARC01493_001.ARC already exists
ORA-16089 signalled during: alter database register physical logfile 'D:FTPA...
Mon Jan 23 13:00:15 2006
alter database register physical logfile 'D:FTPARC01494_001.Arc'
Mon Jan 23 13:00:15 2006
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Register archivelog D:FTPARC01494_001.ARC already exists
ORA-16089 signalled during: alter database register physical logfile 'D:FTPA...
Mon Jan 23 15:20:19 2006
Errors in file d:oracleadmintvsnwebbdumptvsnweb_dbw0_7616.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: 'D:ORACLEORADATATVSNWEBWEBDATA2.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。

Mon Jan 23 15:20:19 2006
Errors in file d:oracleadmintvsnwebbdumptvsnweb_dbw0_7616.trc:
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: 'D:ORACLEORADATATVSNWEBWEBDATA2.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。

Mon Jan 23 15:21:36 2006
alter database create datafile 'd:ORACLEORADATATVSNWEBWEBDATA2.DBF'
Mon Jan 23 15:22:00 2006
Completed: alter database create datafile 'd:ORACLEORADATA
Mon Jan 23 15:22:54 2006
ALTER DATABASE RECOVER TABLESPACE WEBDATA
Mon Jan 23 15:22:54 2006
Media Recovery Tablespace: WEBDATA
Media Recovery Start
Media Recovery failed with error 1610
ORA-283 signalled during: ALTER DATABASE RECOVER TABLESPACE WEBDATA ...
Mon Jan 23 15:24:52 2006
ALTER DATABASE REGISTER LOGFILE 'D:FTPLOGARC01395_001.ARC'
Mon Jan 23 15:24:52 2006
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Register archivelog D:FTPLOGARC01395_001.ARC already exists
ORA-16089 signalled during: ALTER DATABASE REGISTER LOGFILE 'D:FTPLOGARC013...
Mon Jan 23 15:27:11 2006
alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process
MRP0 started with pid=19
MRP0: Background Managed Standby Recovery process started
Starting datafile 1 recovery in thread 1 sequence 1395
Datafile 1: 'D:ORACLEORADATATVSNWEBSYSTEM01.DBF'
Starting datafile 2 recovery in thread 1 sequence 1395
Datafile 2: 'D:ORACLEORADATATVSNWEBUNDOTBS01.DBF'
Starting datafile 3 recovery in thread 1 sequence 1395
Datafile 3: 'D:ORACLEORADATATVSNWEBCWMLITE01.DBF'
Starting datafile 4 recovery in thread 1 sequence 1395
Datafile 4: 'D:ORACLEORADATATVSNWEBDRSYS01.DBF'
Starting datafile 5 recovery in thread 1 sequence 1395
Datafile 5: 'D:ORACLEORADATATVSNWEBEXAMPLE01.DBF'
Starting datafile 6 recovery in thread 1 sequence 1395
Datafile 6: 'D:ORACLEORADATATVSNWEBINDX01.DBF'
Starting datafile 7 recovery in thread 1 sequence 1395

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26706/viewspace-64572/,如需转载,请注明出处,否则将追究法律责任。

上一篇: v$waitstat
下一篇: compress sh
请登录后发表评论 登录
全部评论

注册时间:2002-10-29

  • 博文量
    78
  • 访问量
    55139