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
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请高手帮忙,非常感谢!