互联网服务数据库

归档日志可以实时传到standby，但是applied的状态是NO

主库日志如下：Wed Nov 19 13:02:35 2014Thread 1 advanced to log sequence 4401 (LGWRswitch) Current log# 3 seq# 4401 mem# 0: /database/oradb/redo03_1.log Current log# 3 seq# 4401 mem# 1: /database/oradb/redo03_2.logWed Nov 19 15:41:43 2014Thread 1 advanc...显示全部

主库日志如下：

Wed Nov 19 13:02:35 2014

Thread 1 advanced to log sequence 4401 (LGWRswitch)

Current log# 3 seq# 4401 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4401 mem# 1: /database/oradb/redo03_2.log

Wed Nov 19 15:41:43 2014

Thread 1 advanced to log sequence 4402 (LGWRswitch)

Current log# 1 seq# 4402 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4402 mem# 1: /database/oradb/redo01_2.log

Wed Nov 19 15:44:14 2014

ORA-1654: unable to extend indexUSR_XS.PK_XS0112 by 128 in tablespace TBS_XS

Wed Nov 19 16:09:44 2014

ALTER TABLESPACE TBS_XS ADD DATAFILE'/database/oradb/rtbs_xs04.dbf' SIZE 2038M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED

Wed Nov 19 16:10:05 2014

Completed: ALTER TABLESPACE TBS_XS ADDDATAFILE '/database/oradb/rtbs_xs04.dbf' SIZE 2038M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED

Wed Nov 19 16:18:18 2014

Thread 1 advanced to log sequence 4403 (LGWRswitch)

Current log# 2 seq# 4403 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4403 mem# 1: /database/oradb/redo02_2.log

Wed Nov 19 18:48:31 2014

Thread 1 advanced to log sequence 4404 (LGWRswitch)

Current log# 3 seq# 4404 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4404 mem# 1: /database/oradb/redo03_2.log

Wed Nov 19 19:48:40 2014

Thread 1 advanced to log sequence 4405 (LGWRswitch)

Current log# 1 seq# 4405 mem# 0: /database/oradb/redo01_1.log

Currentlog# 1 seq# 4405 mem# 1: /database/oradb/redo01_2.log

Wed Nov 19 23:26:47 2014

Thread 1 advanced to log sequence 4406 (LGWRswitch)

Current log# 2 seq# 4406 mem# 0: /database/oradb/redo02_1.log

Currentlog# 2 seq# 4406 mem# 1: /database/oradb/redo02_2.log

Thu Nov 20 01:10:25 2014

ALTER SYSTEM ARCHIVE LOG

Thu Nov 20 01:10:25 2014

Thread 1 advanced to log sequence 4407 (LGWRswitch)

Current log# 3 seq# 4407 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4407 mem# 1: /database/oradb/redo03_2.log

Thu Nov 20 01:10:26 2014

ALTER SYSTEM ARCHIVE LOG

Thu Nov 20 01:10:26 2014

Thread 1 advanced to log sequence 4408 (LGWRswitch)

Current log# 1 seq# 4408 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4408 mem# 1: /database/oradb/redo01_2.log

Thu Nov 20 11:00:02 2014

Thread 1 advanced to log sequence 4409 (LGWRswitch)

Current log# 2 seq# 4409 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4409 mem# 1: /database/oradb/redo02_2.log

Thu Nov 20 15:00:26 2014

Thread 1 advanced to log sequence 4410 (LGWRswitch)

Current log# 3 seq# 4410 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4410 mem# 1: /database/oradb/redo03_2.log

Thu Nov 20 20:02:25 2014

Thread 1 advanced to log sequence 4411 (LGWRswitch)

Current log# 1 seq# 4411 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4411 mem# 1: /database/oradb/redo01_2.log

Thu Nov 20 23:27:30 2014

Thread 1 advanced to log sequence 4412 (LGWRswitch)

Current log# 2 seq# 4412 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4412 mem# 1: /database/oradb/redo02_2.log

Fri Nov 21 01:00:03 2014

Thread 1 advanced to log sequence 4413 (LGWRswitch)

Currentlog# 3 seq# 4413 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4413 mem# 1: /database/oradb/redo03_2.log

Fri Nov 21 01:10:35 2014

ALTER SYSTEM ARCHIVE LOG

Fri Nov 21 01:10:35 2014

Thread 1 advanced to log sequence 4414 (LGWRswitch)

Current log# 1 seq# 4414 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4414 mem# 1: /database/oradb/redo01_2.log

Fri Nov 21 01:10:36 2014

ALTER SYSTEM ARCHIVE LOG

Fri Nov 21 01:10:36 2014

Thread 1 advanced to log sequence 4415 (LGWRswitch)

Current log# 2 seq# 4415 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4415 mem# 1: /database/oradb/redo02_2.log

Fri Nov 21 08:06:14 2014

Thread 1 advanced to log sequence 4416 (LGWRswitch)

Current log# 3 seq# 4416 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4416 mem# 1: /database/oradb/redo03_2.log

Fri Nov 21 09:42:37 2014

Thread 1 advanced to log sequence 4417 (LGWRswitch)

Current log# 1 seq# 4417 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4417 mem# 1: /database/oradb/redo01_2.log

Fri Nov 21 11:59:22 2014

Thread 1 advanced to log sequence 4418 (LGWRswitch)

Current log# 2 seq# 4418 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4418 mem# 1: /database/oradb/redo02_2.log

Fri Nov 21 14:47:06 2014

Thread 1 advanced to log sequence 4419 (LGWRswitch)

Current log# 3 seq# 4419 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4419 mem# 1: /database/oradb/redo03_2.log

Fri Nov 21 18:16:25 2014

Thread 1 advanced to log sequence 4420 (LGWRswitch)

Current log# 1 seq# 4420 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4420 mem# 1: /database/oradb/redo01_2.log

Fri Nov 21 23:18:44 2014

Thread 1 advanced to log sequence 4421 (LGWRswitch)

Current log# 2 seq# 4421 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4421 mem# 1: /database/oradb/redo02_2.log

Sat Nov 22 01:00:28 2014

Thread 1 advanced to log sequence 4422 (LGWRswitch)

Current log# 3 seq# 4422 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4422 mem# 1: /database/oradb/redo03_2.log

Sat Nov 22 01:10:35 2014

ALTER SYSTEM ARCHIVE LOG

Sat Nov 22 01:10:35 2014

Thread 1 advanced to log sequence 4423 (LGWRswitch)

Current log# 1 seq# 4423 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4423 mem# 1: /database/oradb/redo01_2.log

Sat Nov 22 01:10:35 2014

ALTER SYSTEM ARCHIVE LOG

Sat Nov 22 01:10:35 2014

Thread 1 advanced to log sequence 4424 (LGWRswitch)

Current log# 2 seq# 4424 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4424 mem# 1: /database/oradb/redo02_2.log

Sat Nov 22 06:00:49 2014

Thread 1 advanced to log sequence 4425 (LGWRswitch)

Current log# 3 seq# 4425 mem# 0: /database/oradb/redo03_1.log

Currentlog# 3 seq# 4425 mem# 1: /database/oradb/redo03_2.log

Sat Nov 22 09:29:52 2014

Thread 1 advanced to log sequence 4426 (LGWRswitch)

Current log# 1 seq# 4426 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4426 mem# 1: /database/oradb/redo01_2.log

Sat Nov 22 16:16:49 2014

Thread 1 advanced to log sequence 4427 (LGWRswitch)

Current log# 2 seq# 4427 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4427 mem# 1: /database/oradb/redo02_2.log

Sat Nov 22 23:28:57 2014

Thread 1 advanced to log sequence 4428 (LGWRswitch)

Current log# 3 seq# 4428 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4428 mem# 1: /database/oradb/redo03_2.log

Sun Nov 23 01:10:54 2014

ALTER SYSTEM ARCHIVE LOG

Sun Nov 23 01:10:54 2014

Thread 1 advanced to log sequence 4429 (LGWRswitch)

Current log# 1 seq# 4429 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4429 mem# 1: /database/oradb/redo01_2.log

Sun Nov 23 01:10:55 2014

ALTER SYSTEM ARCHIVE LOG

Sun Nov 23 01:10:55 2014

Thread 1 advanced to log sequence 4430 (LGWRswitch)

Current log# 2 seq# 4430 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4430 mem# 1: /database/oradb/redo02_2.log

Sun Nov 23 08:11:36 2014

Thread 1 advanced to log sequence 4431 (LGWRswitch)

Current log# 3 seq# 4431 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4431 mem# 1: /database/oradb/redo03_2.log

Sun Nov 23 10:03:48 2014

Thread 1 advanced to log sequence 4432 (LGWRswitch)

Currentlog# 1 seq# 4432 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4432 mem# 1: /database/oradb/redo01_2.log

Sun Nov 23 12:09:34 2014

Thread 1 advanced to log sequence 4433 (LGWRswitch)

Current log# 2 seq# 4433 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4433 mem# 1: /database/oradb/redo02_2.log

Sun Nov 23 17:15:33 2014

Thread 1 advanced to log sequence 4434 (LGWRswitch)

Current log# 3 seq# 4434 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4434 mem# 1: /database/oradb/redo03_2.log

Sun Nov 23 22:44:51 2014

Thread 1 advanced to log sequence 4435 (LGWRswitch)

Current log# 1 seq# 4435 mem# 0: /database/oradb/redo01_1.log

Current log# 1 seq# 4435 mem# 1: /database/oradb/redo01_2.log

Mon Nov 24 01:00:44 2014

Thread 1 advanced to log sequence 4436 (LGWRswitch)

Current log# 2 seq# 4436 mem# 0: /database/oradb/redo02_1.log

Current log# 2 seq# 4436 mem# 1: /database/oradb/redo02_2.log

Mon Nov 24 01:16:12 2014

ALTER SYSTEM ARCHIVE LOG

Mon Nov 24 01:16:12 2014

Thread 1 advanced to log sequence 4437 (LGWRswitch)

Current log# 3 seq# 4437 mem# 0: /database/oradb/redo03_1.log

Current log# 3 seq# 4437 mem# 1: /database/oradb/redo03_2.log

Mon Nov 24 01:16:12 2014

ALTER SYSTEM ARCHIVE LOG

########################################################################

备库日志如下：

Setting recovery target incarnation to 1ARCH: STARTING ARCH PROCESSESARC0 started with pid=16, OS id=4643Fri Dec 19 12:18:53 2014ARC0: Archival startedARC1: Archival startedARCH: STARTING ARCH PROCESSES COMPLETEARC1 started with pid=17, OS id=4645Fri Dec 19 12:18:53 2014ARC0: Becoming the 'no FAL' ARCHARC0: Becoming the 'no SRL' ARCHARC0: Thread not mountedFri Dec 19 12:18:53 2014ARC1: Becoming the heartbeat ARCHARC1: Thread not mountedFri Dec 19 12:18:53 2014Successful mount of redo thread 1, with mount id 2264738089Fri Dec 19 12:18:53 2014Physical Standby Database mounted.Completed: alter database mount standby databaseFri Dec 19 12:19:19 2014alter database recover managed standby database disconnect from sessionFri Dec 19 12:19:19 2014Attempt to start background Managed Standby Recovery process (oradb)MRP0 started with pid=18, OS id=4647Fri Dec 19 12:19:19 2014MRP0: Background Managed Standby Recovery process started (oradb)Managed Standby Recovery not using Real Time ApplyFri Dec 19 12:19:24 2014Errors in file /oracle/admin/oradb/bdump/oradb_dbw0_4620.trc:ORA-01157: cannot identify/lock data file 5 - see DBWR trace fileORA-01110: data file 5: '/usr/local/blackboard/oracle/bbadmin_data_file1.dbf'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3Fri Dec 19 12:19:24 2014Errors in file /oracle/admin/oradb/bdump/oradb_dbw0_4620.trc:ORA-01157: cannot identify/lock data file 6 - see DBWR trace fileORA-01110: data file 6: '/usr/local/blackboard/oracle/bbadmin_indx_file1.dbf'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3Fri Dec 19 12:19:24 2014Errors in file /oracle/admin/oradb/bdump/oradb_dbw0_4620.trc:ORA-01157: cannot identify/lock data file 7 - see DBWR trace fileORA-01110: data file 7: '/usr/local/blackboard/oracle/bb_bb60_data_file1.dbf'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3Fri Dec 19 12:19:24 2014Errors in file /oracle/admin/oradb/bdump/oradb_dbw0_4620.trc:ORA-01157: cannot identify/lock data file 8 - see DBWR trace fileORA-01110: data file 8: '/usr/local/blackboard/oracle/bb_bb60_indx_file1.dbf'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3Fri Dec 19 12:19:24 2014Errors in file /oracle/admin/oradb/bdump/oradb_dbw0_4620.trc:ORA-01157: cannot identify/lock data file 9 - see DBWR trace fileORA-01110: data file 9: '/usr/local/blackboard/oracle/bb_bb60_stats_data_file1.dbf'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3Fri Dec 19 12:19:24 2014

请高手帮忙，非常感谢！

收起

关注1

参与11

查看其它 9 个回答ibmx31_1的回答

ibmx31_1软件开发工程师iihk

下面是/oracle/admin/oradb/bdump/oradb_dbw0_4620.trc 的日志：

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: Linux
Node name:    oradb
Release:       2.6.18-194.el5
Version:       #1 SMP Tue Mar 16 21:52:39 EDT 2010
Machine:       x86_64
Instance name: oradb
Redo thread mounted by this instance: 1
Oracle process number: 5
Unix process pid: 4465, image: oracle@oradb (DBW0)

*** 2014-12-19 14:52:41.589
*** SERVICE NAME:() 2014-12-19 14:52:41.589
*** SESSION ID:(1652.1) 2014-12-19 14:52:41.589
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/usr/local/blackboard/oracle/bbadmin_data_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/usr/local/blackboard/oracle/bbadmin_indx_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/usr/local/blackboard/oracle/bb_bb60_data_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/usr/local/blackboard/oracle/bb_bb60_indx_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/usr/local/blackboard/oracle/bb_bb60_stats_data_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10: '/usr/local/blackboard/oracle/bb_bb60_stats_indx_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/usr/local/blackboard/oracle/cms_data_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: '/usr/local/blackboard/oracle/cms_indx_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/usr/local/blackboard/oracle/cms_files_users_data_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 14 - see DBWR trace file
ORA-01110: data file 14: '/usr/local/blackboard/oracle/cms_files_users_indx_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 15 - see DBWR trace file
ORA-01110: data file 15: '/usr/local/blackboard/oracle/cms_files_courses_data_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 16 - see DBWR trace file
ORA-01110: data file 16: '/usr/local/blackboard/oracle/cms_files_courses_indx_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 17 - see DBWR trace file
ORA-01110: data file 17: '/usr/local/blackboard/oracle/cms_files_orgs_data_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
ORA-01110: data file 18: '/usr/local/blackboard/oracle/cms_files_orgs_indx_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 19 - see DBWR trace file
ORA-01110: data file 19: '/usr/local/blackboard/oracle/cms_files_inst_data_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 20 - see DBWR trace file
ORA-01110: data file 20: '/usr/local/blackboard/oracle/cms_files_inst_indx_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 21 - see DBWR trace file
ORA-01110: data file 21: '/usr/local/blackboard/oracle/cms_files_library_data_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01157: cannot identify/lock data file 22 - see DBWR trace file
ORA-01110: data file 22: '/usr/local/blackboard/oracle/cms_files_library_indx_file1.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
[oracle@oradb bdump]$ ORACLE_HOME = /oracle/product/10.2.0/db_1

互联网服务 · 2014-12-22

归档日志可以实时传到standby，但是applied的状态是NO

查看其它 9 个回答ibmx31_1的回答

回答者

ibmx31_1 最近回答过的问题

回答状态