Backup af Oracle 9i

Hey Lars,

en alm filbackup skulle så være af en lukket database. Det ville give dig en fuzzy backup at tage af en åben - så det må du ikke.

Men jeg syntes da du skal gå efter at få løst de problemer du nævner istedet, så du kan få taget din online backup. Find ud af hvorfor den hænger når du laver en "begin backup" og hvorfor du ikke kan logge ind som andre end sys? Lyder ikke sundt.

Hej pnielsen

Mente heller ikke at jeg kunne bruge den til noget, og jeg har også stoppet den igen.

Nej, jeg er helt enig med dig, at det ikke lyder helt sundt. Nu kan jeg heller ikke lukke basen ned, da der jo er en online backup igang af et tablespace. Jeg har prøvet at skrive alter <tablespace> end backup;, men det kommer jeg ikke videre af.
Det "sjove" er, at jeg

mangler lige noget :-)
Det "sjove" er, at jeg heller ikke kan lukke ned for basen.
Udsnit af alertloggen fra de sidste par dage.
Fri Aug 19 00:45:50 2005
Thread 1 advanced to log sequence 6032
  Current log# 1 seq# 6032 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 00:45:50 2005
ARC1: Evaluating archive  log 5 thread 1 sequence 6031
ARC1: Beginning to archive log 5 thread 1 sequence 6031
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06031.ARC'
Fri Aug 19 00:46:08 2005
ARC1: Completed archiving  log 5 thread 1 sequence 6031
Fri Aug 19 00:46:16 2005
Thread 1 advanced to log sequence 6033
  Current log# 2 seq# 6033 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 00:46:16 2005
ARC0: Evaluating archive  log 1 thread 1 sequence 6032
ARC0: Beginning to archive log 1 thread 1 sequence 6032
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06032.ARC'
Fri Aug 19 00:46:56 2005
ARC0: Completed archiving  log 1 thread 1 sequence 6032
Fri Aug 19 00:51:46 2005
Thread 1 advanced to log sequence 6034
  Current log# 3 seq# 6034 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 00:51:46 2005
ARC1: Evaluating archive  log 2 thread 1 sequence 6033
ARC1: Beginning to archive log 2 thread 1 sequence 6033
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06033.ARC'
Fri Aug 19 00:52:20 2005
ARC1: Completed archiving  log 2 thread 1 sequence 6033
Fri Aug 19 00:52:58 2005
Thread 1 advanced to log sequence 6035
  Current log# 4 seq# 6035 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 00:52:58 2005
ARC0: Evaluating archive  log 3 thread 1 sequence 6034
ARC0: Beginning to archive log 3 thread 1 sequence 6034
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06034.ARC'
Fri Aug 19 00:53:20 2005
ARC0: Completed archiving  log 3 thread 1 sequence 6034
Fri Aug 19 00:55:19 2005
Thread 1 advanced to log sequence 6036
  Current log# 5 seq# 6036 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 00:55:19 2005
ARC1: Evaluating archive  log 4 thread 1 sequence 6035
ARC1: Beginning to archive log 4 thread 1 sequence 6035
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06035.ARC'
Fri Aug 19 00:55:34 2005
ARC1: Completed archiving  log 4 thread 1 sequence 6035
Fri Aug 19 00:56:25 2005
Thread 1 advanced to log sequence 6037
  Current log# 1 seq# 6037 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 00:56:25 2005
ARC0: Evaluating archive  log 5 thread 1 sequence 6036
ARC0: Beginning to archive log 5 thread 1 sequence 6036
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06036.ARC'
Fri Aug 19 00:56:59 2005
ARC0: Completed archiving  log 5 thread 1 sequence 6036
Fri Aug 19 00:57:56 2005
Thread 1 advanced to log sequence 6038
  Current log# 2 seq# 6038 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 00:57:56 2005
ARC1: Evaluating archive  log 1 thread 1 sequence 6037
ARC1: Beginning to archive log 1 thread 1 sequence 6037
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06037.ARC'
Fri Aug 19 00:58:34 2005
ARC1: Completed archiving  log 1 thread 1 sequence 6037
Fri Aug 19 00:59:20 2005
Thread 1 advanced to log sequence 6039
  Current log# 3 seq# 6039 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 00:59:20 2005
ARC0: Evaluating archive  log 2 thread 1 sequence 6038
ARC0: Beginning to archive log 2 thread 1 sequence 6038
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06038.ARC'
Fri Aug 19 00:59:49 2005
ARC0: Completed archiving  log 2 thread 1 sequence 6038
Fri Aug 19 01:00:54 2005
Thread 1 advanced to log sequence 6040
  Current log# 4 seq# 6040 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 01:00:54 2005
ARC1: Evaluating archive  log 3 thread 1 sequence 6039
ARC1: Beginning to archive log 3 thread 1 sequence 6039
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06039.ARC'
Fri Aug 19 01:01:27 2005
ARC1: Completed archiving  log 3 thread 1 sequence 6039
Fri Aug 19 01:02:24 2005
Thread 1 advanced to log sequence 6041
  Current log# 5 seq# 6041 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 01:02:24 2005
ARC0: Evaluating archive  log 4 thread 1 sequence 6040
ARC0: Beginning to archive log 4 thread 1 sequence 6040
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06040.ARC'
Fri Aug 19 01:02:58 2005
ARC0: Completed archiving  log 4 thread 1 sequence 6040
Fri Aug 19 01:03:50 2005
Thread 1 advanced to log sequence 6042
  Current log# 1 seq# 6042 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 01:03:50 2005
ARC1: Evaluating archive  log 5 thread 1 sequence 6041
ARC1: Beginning to archive log 5 thread 1 sequence 6041
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06041.ARC'
Fri Aug 19 01:04:19 2005
ARC1: Completed archiving  log 5 thread 1 sequence 6041
Fri Aug 19 01:05:23 2005
Thread 1 advanced to log sequence 6043
  Current log# 2 seq# 6043 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 01:05:24 2005
ARC0: Evaluating archive  log 1 thread 1 sequence 6042
ARC0: Beginning to archive log 1 thread 1 sequence 6042
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06042.ARC'
Fri Aug 19 01:06:06 2005
ARC0: Completed archiving  log 1 thread 1 sequence 6042
Fri Aug 19 01:06:45 2005
Thread 1 advanced to log sequence 6044
  Current log# 3 seq# 6044 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 01:06:46 2005
ARC1: Evaluating archive  log 2 thread 1 sequence 6043
ARC1: Beginning to archive log 2 thread 1 sequence 6043
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06043.ARC'
Fri Aug 19 01:07:10 2005
ARC1: Completed archiving  log 2 thread 1 sequence 6043
Fri Aug 19 01:08:12 2005
Thread 1 advanced to log sequence 6045
  Current log# 4 seq# 6045 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 01:08:12 2005
ARC0: Evaluating archive  log 3 thread 1 sequence 6044
ARC0: Beginning to archive log 3 thread 1 sequence 6044
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06044.ARC'
Fri Aug 19 01:08:45 2005
ARC0: Completed archiving  log 3 thread 1 sequence 6044
Fri Aug 19 01:09:51 2005
Thread 1 advanced to log sequence 6046
  Current log# 5 seq# 6046 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 01:09:51 2005
ARC1: Evaluating archive  log 4 thread 1 sequence 6045
ARC1: Beginning to archive log 4 thread 1 sequence 6045
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06045.ARC'
Fri Aug 19 01:10:26 2005
ARC1: Completed archiving  log 4 thread 1 sequence 6045
Fri Aug 19 01:11:17 2005
Thread 1 advanced to log sequence 6047
  Current log# 1 seq# 6047 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 01:11:17 2005
ARC0: Evaluating archive  log 5 thread 1 sequence 6046
ARC0: Beginning to archive log 5 thread 1 sequence 6046
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06046.ARC'
Fri Aug 19 01:11:51 2005
ARC0: Completed archiving  log 5 thread 1 sequence 6046
Fri Aug 19 01:12:49 2005
Thread 1 advanced to log sequence 6048
  Current log# 2 seq# 6048 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 01:12:49 2005
ARC1: Evaluating archive  log 1 thread 1 sequence 6047
ARC1: Beginning to archive log 1 thread 1 sequence 6047
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06047.ARC'
Fri Aug 19 01:13:19 2005
ARC1: Completed archiving  log 1 thread 1 sequence 6047
Fri Aug 19 01:14:14 2005
Thread 1 advanced to log sequence 6049
  Current log# 3 seq# 6049 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 01:14:14 2005
ARC0: Evaluating archive  log 2 thread 1 sequence 6048
ARC0: Beginning to archive log 2 thread 1 sequence 6048
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06048.ARC'
Fri Aug 19 01:14:44 2005
ARC0: Completed archiving  log 2 thread 1 sequence 6048
Fri Aug 19 01:15:44 2005
Thread 1 advanced to log sequence 6050
  Current log# 4 seq# 6050 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 01:15:44 2005
ARC1: Evaluating archive  log 3 thread 1 sequence 6049
ARC1: Beginning to archive log 3 thread 1 sequence 6049
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06049.ARC'
Fri Aug 19 01:16:15 2005
ARC1: Completed archiving  log 3 thread 1 sequence 6049
Fri Aug 19 01:17:10 2005
Thread 1 advanced to log sequence 6051
  Current log# 5 seq# 6051 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 01:17:11 2005
ARC0: Evaluating archive  log 4 thread 1 sequence 6050
ARC0: Beginning to archive log 4 thread 1 sequence 6050
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06050.ARC'
Fri Aug 19 01:17:41 2005
ARC0: Completed archiving  log 4 thread 1 sequence 6050
Fri Aug 19 01:18:32 2005
Thread 1 advanced to log sequence 6052
  Current log# 1 seq# 6052 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 01:18:36 2005
ARC1: Evaluating archive  log 5 thread 1 sequence 6051
ARC1: Beginning to archive log 5 thread 1 sequence 6051
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06051.ARC'
Fri Aug 19 01:19:13 2005
ARC1: Completed archiving  log 5 thread 1 sequence 6051
Fri Aug 19 01:20:01 2005
Thread 1 advanced to log sequence 6053
  Current log# 2 seq# 6053 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 01:20:02 2005
ARC0: Evaluating archive  log 1 thread 1 sequence 6052
ARC0: Beginning to archive log 1 thread 1 sequence 6052
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06052.ARC'
Fri Aug 19 01:20:36 2005
ARC0: Completed archiving  log 1 thread 1 sequence 6052
Fri Aug 19 01:21:28 2005
Thread 1 advanced to log sequence 6054
  Current log# 3 seq# 6054 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 01:21:28 2005
ARC1: Evaluating archive  log 2 thread 1 sequence 6053
ARC1: Beginning to archive log 2 thread 1 sequence 6053
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06053.ARC'
Fri Aug 19 01:21:54 2005
ARC1: Completed archiving  log 2 thread 1 sequence 6053
Fri Aug 19 01:22:56 2005
Thread 1 advanced to log sequence 6055
  Current log# 4 seq# 6055 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 01:22:56 2005
ARC0: Evaluating archive  log 3 thread 1 sequence 6054
ARC0: Beginning to archive log 3 thread 1 sequence 6054
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06054.ARC'
Fri Aug 19 01:23:25 2005
ARC0: Completed archiving  log 3 thread 1 sequence 6054
Fri Aug 19 01:24:40 2005
Thread 1 advanced to log sequence 6056
  Current log# 5 seq# 6056 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 01:24:40 2005
ARC1: Evaluating archive  log 4 thread 1 sequence 6055
ARC1: Beginning to archive log 4 thread 1 sequence 6055
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06055.ARC'
Fri Aug 19 01:25:13 2005
ARC1: Completed archiving  log 4 thread 1 sequence 6055
Fri Aug 19 01:26:04 2005
Thread 1 advanced to log sequence 6057
  Current log# 1 seq# 6057 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 01:26:04 2005
ARC0: Evaluating archive  log 5 thread 1 sequence 6056
ARC0: Beginning to archive log 5 thread 1 sequence 6056
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06056.ARC'
Fri Aug 19 01:26:19 2005
ARC0: Completed archiving  log 5 thread 1 sequence 6056
Fri Aug 19 01:29:18 2005
Thread 1 advanced to log sequence 6058
  Current log# 2 seq# 6058 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 01:29:18 2005
ARC1: Evaluating archive  log 1 thread 1 sequence 6057
ARC1: Beginning to archive log 1 thread 1 sequence 6057
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06057.ARC'
Fri Aug 19 01:30:17 2005
ARC1: Completed archiving  log 1 thread 1 sequence 6057
Fri Aug 19 01:31:13 2005
Thread 1 advanced to log sequence 6059
  Current log# 3 seq# 6059 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 01:31:13 2005
ARC0: Evaluating archive  log 2 thread 1 sequence 6058
ARC0: Beginning to archive log 2 thread 1 sequence 6058
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06058.ARC'
Fri Aug 19 01:31:42 2005
ARC0: Completed archiving  log 2 thread 1 sequence 6058
Fri Aug 19 01:32:43 2005
Thread 1 advanced to log sequence 6060
  Current log# 4 seq# 6060 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 01:32:43 2005
ARC1: Evaluating archive  log 3 thread 1 sequence 6059
ARC1: Beginning to archive log 3 thread 1 sequence 6059
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06059.ARC'
Fri Aug 19 01:33:16 2005
ARC1: Completed archiving  log 3 thread 1 sequence 6059
Fri Aug 19 01:34:03 2005
Thread 1 advanced to log sequence 6061
  Current log# 5 seq# 6061 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 01:34:08 2005
ARC0: Evaluating archive  log 4 thread 1 sequence 6060
ARC0: Beginning to archive log 4 thread 1 sequence 6060
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06060.ARC'
Fri Aug 19 01:34:40 2005
ARC0: Completed archiving  log 4 thread 1 sequence 6060
Fri Aug 19 01:35:29 2005
Thread 1 advanced to log sequence 6062
  Current log# 1 seq# 6062 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 01:35:32 2005
ARC1: Evaluating archive  log 5 thread 1 sequence 6061
ARC1: Beginning to archive log 5 thread 1 sequence 6061
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06061.ARC'
Fri Aug 19 01:36:13 2005
ARC1: Completed archiving  log 5 thread 1 sequence 6061
Fri Aug 19 01:37:04 2005
Thread 1 advanced to log sequence 6063
  Current log# 2 seq# 6063 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 01:37:04 2005
ARC0: Evaluating archive  log 1 thread 1 sequence 6062
ARC0: Beginning to archive log 1 thread 1 sequence 6062
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06062.ARC'
Fri Aug 19 01:37:22 2005
ARC0: Completed archiving  log 1 thread 1 sequence 6062
Fri Aug 19 01:38:37 2005
Thread 1 advanced to log sequence 6064
  Current log# 3 seq# 6064 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 01:38:38 2005
ARC1: Evaluating archive  log 2 thread 1 sequence 6063
ARC1: Beginning to archive log 2 thread 1 sequence 6063
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06063.ARC'
Fri Aug 19 01:39:08 2005
ARC1: Completed archiving  log 2 thread 1 sequence 6063
Fri Aug 19 01:40:01 2005
Thread 1 advanced to log sequence 6065
  Current log# 4 seq# 6065 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 01:40:02 2005
ARC0: Evaluating archive  log 3 thread 1 sequence 6064
ARC0: Beginning to archive log 3 thread 1 sequence 6064
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06064.ARC'
Fri Aug 19 01:40:38 2005
ARC0: Completed archiving  log 3 thread 1 sequence 6064
Fri Aug 19 01:41:32 2005
Thread 1 advanced to log sequence 6066
  Current log# 5 seq# 6066 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 01:41:32 2005
ARC1: Evaluating archive  log 4 thread 1 sequence 6065
ARC1: Beginning to archive log 4 thread 1 sequence 6065
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06065.ARC'
Fri Aug 19 01:42:08 2005
ARC1: Completed archiving  log 4 thread 1 sequence 6065
Fri Aug 19 01:49:29 2005
Thread 1 advanced to log sequence 6067
  Current log# 1 seq# 6067 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 01:49:29 2005
ARC0: Evaluating archive  log 5 thread 1 sequence 6066
ARC0: Beginning to archive log 5 thread 1 sequence 6066
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06066.ARC'
Fri Aug 19 01:49:43 2005
ARC0: Completed archiving  log 5 thread 1 sequence 6066
Fri Aug 19 01:52:34 2005
Thread 1 advanced to log sequence 6068
  Current log# 2 seq# 6068 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 01:52:34 2005
ARC1: Evaluating archive  log 1 thread 1 sequence 6067
ARC1: Beginning to archive log 1 thread 1 sequence 6067
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06067.ARC'
Fri Aug 19 01:53:05 2005
ARC1: Completed archiving  log 1 thread 1 sequence 6067
Fri Aug 19 01:54:05 2005
Thread 1 advanced to log sequence 6069
  Current log# 3 seq# 6069 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 01:54:05 2005
ARC0: Evaluating archive  log 2 thread 1 sequence 6068
ARC0: Beginning to archive log 2 thread 1 sequence 6068
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06068.ARC'
Fri Aug 19 01:54:36 2005
ARC0: Completed archiving  log 2 thread 1 sequence 6068
Fri Aug 19 01:55:44 2005
Thread 1 advanced to log sequence 6070
  Current log# 4 seq# 6070 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 01:55:44 2005
ARC1: Evaluating archive  log 3 thread 1 sequence 6069
ARC1: Beginning to archive log 3 thread 1 sequence 6069
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06069.ARC'
Fri Aug 19 01:56:18 2005
ARC1: Completed archiving  log 3 thread 1 sequence 6069
Fri Aug 19 01:57:17 2005
Thread 1 advanced to log sequence 6071
  Current log# 5 seq# 6071 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 01:57:17 2005
ARC0: Evaluating archive  log 4 thread 1 sequence 6070
ARC0: Beginning to archive log 4 thread 1 sequence 6070
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06070.ARC'
Fri Aug 19 01:57:53 2005
ARC0: Completed archiving  log 4 thread 1 sequence 6070
Fri Aug 19 01:58:54 2005
Thread 1 advanced to log sequence 6072
  Current log# 1 seq# 6072 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 01:58:54 2005
ARC1: Evaluating archive  log 5 thread 1 sequence 6071
ARC1: Beginning to archive log 5 thread 1 sequence 6071
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06071.ARC'
Fri Aug 19 01:59:26 2005
ARC1: Completed archiving  log 5 thread 1 sequence 6071
Fri Aug 19 02:00:34 2005
Thread 1 advanced to log sequence 6073
  Current log# 2 seq# 6073 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 02:00:37 2005
ARC0: Evaluating archive  log 1 thread 1 sequence 6072
ARC0: Beginning to archive log 1 thread 1 sequence 6072
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06072.ARC'
Fri Aug 19 02:01:06 2005
ARC0: Completed archiving  log 1 thread 1 sequence 6072
Fri Aug 19 02:02:12 2005
Thread 1 advanced to log sequence 6074
  Current log# 3 seq# 6074 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 02:02:13 2005
ARC1: Evaluating archive  log 2 thread 1 sequence 6073
ARC1: Beginning to archive log 2 thread 1 sequence 6073
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06073.ARC'
Fri Aug 19 02:02:43 2005
ARC1: Completed archiving  log 2 thread 1 sequence 6073
Fri Aug 19 02:05:47 2005
Thread 1 advanced to log sequence 6075
  Current log# 4 seq# 6075 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 02:05:47 2005
ARC0: Evaluating archive  log 3 thread 1 sequence 6074
ARC0: Beginning to archive log 3 thread 1 sequence 6074
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06074.ARC'
Fri Aug 19 02:06:09 2005
ARC0: Completed archiving  log 3 thread 1 sequence 6074
Fri Aug 19 02:07:58 2005
Thread 1 advanced to log sequence 6076
  Current log# 5 seq# 6076 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 02:08:01 2005
ARC1: Evaluating archive  log 4 thread 1 sequence 6075
ARC1: Beginning to archive log 4 thread 1 sequence 6075
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06075.ARC'
Fri Aug 19 02:08:30 2005
ARC1: Completed archiving  log 4 thread 1 sequence 6075
Fri Aug 19 02:09:33 2005
Thread 1 advanced to log sequence 6077
  Current log# 1 seq# 6077 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 02:09:36 2005
ARC0: Evaluating archive  log 5 thread 1 sequence 6076
ARC0: Beginning to archive log 5 thread 1 sequence 6076
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06076.ARC'
Fri Aug 19 02:10:01 2005
ARC0: Completed archiving  log 5 thread 1 sequence 6076
Fri Aug 19 02:11:27 2005
Thread 1 advanced to log sequence 6078
  Current log# 2 seq# 6078 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 02:11:27 2005
ARC1: Evaluating archive  log 1 thread 1 sequence 6077
ARC1: Beginning to archive log 1 thread 1 sequence 6077
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06077.ARC'
Fri Aug 19 02:11:59 2005
ARC1: Completed archiving  log 1 thread 1 sequence 6077
Fri Aug 19 02:14:09 2005
Thread 1 advanced to log sequence 6079
  Current log# 3 seq# 6079 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 02:14:10 2005
ARC0: Evaluating archive  log 2 thread 1 sequence 6078
ARC0: Beginning to archive log 2 thread 1 sequence 6078
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06078.ARC'
Fri Aug 19 02:14:40 2005
ARC0: Completed archiving  log 2 thread 1 sequence 6078
Fri Aug 19 02:15:54 2005
Thread 1 advanced to log sequence 6080
  Current log# 4 seq# 6080 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 02:15:54 2005
ARC1: Evaluating archive  log 3 thread 1 sequence 6079
ARC1: Beginning to archive log 3 thread 1 sequence 6079
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06079.ARC'
Fri Aug 19 02:16:21 2005
ARC1: Completed archiving  log 3 thread 1 sequence 6079
Fri Aug 19 02:17:21 2005
Thread 1 advanced to log sequence 6081
  Current log# 5 seq# 6081 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 02:17:21 2005
ARC0: Evaluating archive  log 4 thread 1 sequence 6080
ARC0: Beginning to archive log 4 thread 1 sequence 6080
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06080.ARC'
Fri Aug 19 02:17:53 2005
ARC0: Completed archiving  log 4 thread 1 sequence 6080
Fri Aug 19 02:18:41 2005
Thread 1 advanced to log sequence 6082
  Current log# 1 seq# 6082 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 02:18:41 2005
ARC1: Evaluating archive  log 5 thread 1 sequence 6081
ARC1: Beginning to archive log 5 thread 1 sequence 6081
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06081.ARC'
Fri Aug 19 02:19:12 2005
ARC1: Completed archiving  log 5 thread 1 sequence 6081
Fri Aug 19 02:20:08 2005
Thread 1 advanced to log sequence 6083
  Current log# 2 seq# 6083 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 02:20:08 2005
ARC0: Evaluating archive  log 1 thread 1 sequence 6082
ARC0: Beginning to archive log 1 thread 1 sequence 6082
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06082.ARC'
Fri Aug 19 02:20:38 2005
ARC0: Completed archiving  log 1 thread 1 sequence 6082
Fri Aug 19 02:21:37 2005
Thread 1 advanced to log sequence 6084
  Current log# 3 seq# 6084 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 02:21:37 2005
ARC1: Evaluating archive  log 2 thread 1 sequence 6083
ARC1: Beginning to archive log 2 thread 1 sequence 6083
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06083.ARC'
Fri Aug 19 02:22:02 2005
ARC1: Completed archiving  log 2 thread 1 sequence 6083
Fri Aug 19 02:23:26 2005
Thread 1 advanced to log sequence 6085
  Current log# 4 seq# 6085 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 02:23:26 2005
ARC0: Evaluating archive  log 3 thread 1 sequence 6084
ARC0: Beginning to archive log 3 thread 1 sequence 6084
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06084.ARC'
Fri Aug 19 02:23:52 2005
ARC0: Completed archiving  log 3 thread 1 sequence 6084
Fri Aug 19 02:24:59 2005
Thread 1 advanced to log sequence 6086
  Current log# 5 seq# 6086 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 02:25:00 2005
ARC1: Evaluating archive  log 4 thread 1 sequence 6085
ARC1: Beginning to archive log 4 thread 1 sequence 6085
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06085.ARC'
Fri Aug 19 02:25:36 2005
ARC1: Completed archiving  log 4 thread 1 sequence 6085
Fri Aug 19 02:26:41 2005
Thread 1 advanced to log sequence 6087
  Current log# 1 seq# 6087 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 02:26:41 2005
ARC0: Evaluating archive  log 5 thread 1 sequence 6086
ARC0: Beginning to archive log 5 thread 1 sequence 6086
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06086.ARC'
Fri Aug 19 02:26:58 2005
ARC0: Completed archiving  log 5 thread 1 sequence 6086
Fri Aug 19 02:32:19 2005
Thread 1 advanced to log sequence 6088
  Current log# 2 seq# 6088 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 02:32:19 2005
ARC1: Evaluating archive  log 1 thread 1 sequence 6087
ARC1: Beginning to archive log 1 thread 1 sequence 6087
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06087.ARC'
Fri Aug 19 02:33:02 2005
ARC1: Completed archiving  log 1 thread 1 sequence 6087
Fri Aug 19 02:34:04 2005
Thread 1 advanced to log sequence 6089
  Current log# 3 seq# 6089 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 02:34:04 2005
ARC0: Evaluating archive  log 2 thread 1 sequence 6088
ARC0: Beginning to archive log 2 thread 1 sequence 6088
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06088.ARC'
Fri Aug 19 02:34:30 2005
ARC0: Completed archiving  log 2 thread 1 sequence 6088
Fri Aug 19 02:35:21 2005
Thread 1 advanced to log sequence 6090
  Current log# 4 seq# 6090 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 02:35:21 2005
ARC1: Evaluating archive  log 3 thread 1 sequence 6089
ARC1: Beginning to archive log 3 thread 1 sequence 6089
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06089.ARC'
Fri Aug 19 02:35:50 2005
ARC1: Completed archiving  log 3 thread 1 sequence 6089
Fri Aug 19 02:59:48 2005
Thread 1 advanced to log sequence 6091
  Current log# 5 seq# 6091 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Fri Aug 19 02:59:48 2005
ARC0: Evaluating archive  log 4 thread 1 sequence 6090
ARC0: Beginning to archive log 4 thread 1 sequence 6090
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06090.ARC'
Fri Aug 19 03:00:04 2005
ARC0: Completed archiving  log 4 thread 1 sequence 6090
Fri Aug 19 03:01:41 2005
Thread 1 advanced to log sequence 6092
  Current log# 1 seq# 6092 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Fri Aug 19 03:01:41 2005
ARC1: Evaluating archive  log 5 thread 1 sequence 6091
ARC1: Beginning to archive log 5 thread 1 sequence 6091
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06091.ARC'
Fri Aug 19 03:02:03 2005
ARC1: Completed archiving  log 5 thread 1 sequence 6091
Fri Aug 19 03:03:18 2005
Thread 1 advanced to log sequence 6093
  Current log# 2 seq# 6093 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Fri Aug 19 03:03:18 2005
ARC0: Evaluating archive  log 1 thread 1 sequence 6092
ARC0: Beginning to archive log 1 thread 1 sequence 6092
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06092.ARC'
Fri Aug 19 03:03:50 2005
ARC0: Completed archiving  log 1 thread 1 sequence 6092
Fri Aug 19 03:04:48 2005
Thread 1 advanced to log sequence 6094
  Current log# 3 seq# 6094 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Fri Aug 19 03:04:48 2005
ARC1: Evaluating archive  log 2 thread 1 sequence 6093
ARC1: Beginning to archive log 2 thread 1 sequence 6093
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06093.ARC'
Fri Aug 19 03:05:13 2005
ARC1: Completed archiving  log 2 thread 1 sequence 6093
Fri Aug 19 04:57:42 2005
Thread 1 advanced to log sequence 6095
  Current log# 4 seq# 6095 mem# 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 04:57:42 2005
ARC0: Evaluating archive  log 3 thread 1 sequence 6094
ARC0: Beginning to archive log 3 thread 1 sequence 6094
Creating archive destination LOG_ARCHIVE_DEST_1: 'D:\ORACLE\ORADATA\DW\ARCHIVE\DW_ARC06094.ARC'
Fri Aug 19 04:57:55 2005
ARC0: Completed archiving  log 3 thread 1 sequence 6094
Fri Aug 19 10:27:48 2005
/* OracleOEM */ ALTER TABLESPACE "INDX" ADD DATAFILE 'D:\ORACLE\ORADATA\DW\INDX06.DBF' SIZE 200M AUTOEXTEND ON NEXT  100M MAXSIZE  4000M
Fri Aug 19 10:28:06 2005
Completed: /* OracleOEM */ ALTER TABLESPACE "INDX" ADD DATAFI
Fri Aug 19 10:28:40 2005
Error 2068 trapped in 2PC on transaction 15.10.72673. Cleaning up.
Error stack returned to user:
ORA-02068: efter alvorlig fejl fra BILL
ORA-03113: EOF på kommunikationskanal
Dump file d:\oracle\admin\dw\bdump\alert_dw.log
Fri Aug 19 10:31:40 2005
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Fri Aug 19 10:31:40 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics        = TRUE
  shared_pool_size        = 209715200
  sga_max_size            = 839984280
  large_pool_size          = 8388608
  java_pool_size          = 33554432
  control_files            = D:\oracle\oradata\dw\CONTROL01.CTL, D:\oracle\oradata\dw\CONTROL02.CTL, D:\oracle\oradata\dw\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 419430400
  compatible              = 9.2.0.0.0
  log_archive_dest_1      = LOCATION=D:\oracle\oradata\DW\archive MANDATORY REOPEN
  log_archive_format      = DW_ARC%S.ARC
  db_file_multiblock_read_count= 32
  fast_start_mttr_target  = 300
  undo_management          = AUTO
  undo_tablespace          = UNDO
  undo_retention          = 21600
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = dw
  dispatchers              = (PROTOCOL=TCP) (SERVICE=dwXDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  hash_area_size          = 1048576
  background_dump_dest    = D:\oracle\admin\dw\bdump
  user_dump_dest          = D:\oracle\admin\dw\udump
  core_dump_dest          = D:\oracle\admin\dw\cdump
  open_links              = 100
  open_links_per_instance  = 100
  sort_area_size          = 1048576
  db_name                  = dw
  open_cursors            = 300
  star_transformation_enabled= TRUE
  query_rewrite_enabled    = TRUE
  pga_aggregate_target    = 201326592
  aq_tm_processes          = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Aug 19 10:31:44 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Aug 19 10:31:45 2005
alter database mount exclusive
Fri Aug 19 10:31:50 2005
Successful mount of redo thread 1, with mount id 2984802769.
Fri Aug 19 10:31:50 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Aug 19 10:31:50 2005
alter database open
Fri Aug 19 10:31:54 2005
Beginning crash recovery of 1 threads
Fri Aug 19 10:31:54 2005
Started first pass scan
Fri Aug 19 10:31:54 2005
Completed first pass scan
3550 redo blocks read, 78 data blocks need recovery
Fri Aug 19 10:31:54 2005
Started recovery at
Thread 1: logseq 6095, block 114634, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 4 Seq 6095 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\ORADATA\DW\REDO04.LOG
Fri Aug 19 10:31:55 2005
Completed redo application
Fri Aug 19 10:31:55 2005
Ended recovery at
Thread 1: logseq 6095, block 118184, scn 1.1705323286
78 data blocks read, 78 data blocks written, 3550 redo blocks read
Crash recovery completed successfully
Fri Aug 19 10:32:00 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 6096
Thread 1 opened at log sequence 6096
  Current log# 5 seq# 6096 mem# 0: D:\ORACLE\ORADATA\DW\REDO05.LOG
Successful open of redo thread 1.
Fri Aug 19 10:32:02 2005
SMON: enabling cache recovery
Fri Aug 19 10:32:02 2005
Undo Segment 1 Onlined
Undo Segment 11 Onlined
Undo Segment 12 Onlined
Undo Segment 13 Onlined
Undo Segment 14 Onlined
Undo Segment 15 Onlined
Undo Segment 16 Onlined
Undo Segment 17 Onlined
Undo Segment 18 Onlined
Undo Segment 19 Onlined
Successfully onlined Undo Tablespace 12.
Fri Aug 19 10:32:03 2005
SMON: enabling tx recovery
Fri Aug 19 10:32:03 2005
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Sat Aug 20 00:52:19 2005
Thread 1 advanced to log sequence 6097
  Current log# 1 seq# 6097 mem# 0: D:\ORACLE\ORADATA\DW\REDO01.LOG
Sat Aug 20 00:53:00 2005
Thread 1 advanced to log sequence 6098
  Current log# 2 seq# 6098 mem# 0: D:\ORACLE\ORADATA\DW\REDO02.LOG
Sat Aug 20 00:58:24 2005
Thread 1 advanced to log sequence 6099
  Current log# 3 seq# 6099 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Sat Aug 20 00:58:59 2005
Thread 1 cannot allocate new log, sequence 6100
All online logs needed archiving
  Current log# 3 seq# 6099 mem# 0: D:\ORACLE\ORADATA\DW\REDO03.LOG
Mon Aug 22 08:54:16 2005
alter tablespace CWMLITE begin backup
Mon Aug 22 08:54:16 2005
Completed: alter tablespace CWMLITE begin backup
Mon Aug 22 10:15:19 2005
Shutting down instance: further logons disabled
Mon Aug 22 10:15:47 2005
alter tablespace CWMLITE end backup
Mon Aug 22 10:20:16 2005
Shutting down instance: further logons disabled
Mon Aug 22 10:31:22 2005
Shutting down instance: further logons disabled
Mon Aug 22 10:32:04 2005
alter tablespace CWMLITE end backup
Mon Aug 22 10:39:06 2005
Shutting down instance: further logons disabled
Mon Aug 22 10:39:27 2005
alter database datafile 'D:\ORACLE\ORADATA\DW\CWMLITE01.DBF' end backup
Mon Aug 22 10:39:27 2005
ORA-1235 signalled during: alter database datafile 'D:\ORACLE\ORADATA\DW\CWML...
Mon Aug 22 10:40:28 2005
Shutting down instance: further logons disabled
Mon Aug 22 10:42:21 2005
alter database datafile 'D:\ORACLE\ORADATA\DW\CWMLITE01.DBF' end backup
Mon Aug 22 10:42:21 2005
ORA-1235 signalled during: alter database datafile 'D:\ORACLE\ORADATA\DW\CWML...
Mon Aug 22 10:42:40 2005
alter database end backup
Mon Aug 22 10:42:40 2005
ORA-1260 signalled during: alter database end backup...
Mon Aug 22 12:11:14 2005
alter database datafile 3 end backup
Mon Aug 22 12:11:14 2005
ORA-1235 signalled during: alter database datafile 3 end backup...

Det mærkelige er, at der står at den kører i cluster consistent mode. Det er ikke noget som jeg har sat på.
Mvh
Lars

Hvis jeg genstarter serveren, så genstarter basen jo også. Hvad er sandsynligheden for,at basen er currupt, når serveren kommer i luften igen??
Jeg kører med archivelogs, så jeg burde kunne lave recover på den datafil, hvos der er problemer med den.

Udelad bare alle de logswithes næste gang fra din alert.log..
..
Det ser ud til at nogle tablespaces/datafiler er i backup mode når du prøver at lukke ned - det er noget skidt!

Hvis databasen kommer op igen når du starter serveren, er databasen recoveret. Men check lige at alle tablespaces er online - og ikke i backup/recover mode. (select tablespace_name, status from dba_tablespaces og SELECT * FROM V$BACKUP)

Prøv at lave end backup på de tablespaces der evt. står i backup mode. Hvis det ikke lykkedes kan du prøve på datafilerne direkte - f.eks. alter database datafile 3 end backup; Se nummeret på datafilen i v£datafile;

Du har en ORA-01260 hvilket kan tyde på at du sætter datafiler i backup mode og andre ikke. Det er ikke godt! Sørg for at sætte hele tablespacet i backup mode og tag backup af alle filer før du sætter det i end backup.

Mht. at logge ind med andre brugere syntes jeg du skal prøve at køre utlrp scriptet som ligger i din rdbms\admin. Check så derefter om du har invalide objecter.
Har du nogle login triggers?
Hvad sker der når du logger ind med andre brugere?



Du kan ignorere at der står "CLUSTER CONSISTENT mode". Det har ingen betydning for dette her.

OK - det skal jeg nok slette en anden gang. Fylder jo også lidt meget.

Jeg synes ikke, at det lyder godt "Hvis databasen kommer op igen". Tror du, at den er smadret nu eller hvad anbefaler du, at jeg skal gøre. Jeg kan jo desværre ikke gøre så meget andet end, at genstarte serveren.
Jeg har ikke prøvet at sætte enkelte datafiler i backupmode. Jeg forsøgte at sætte et tablespace til backup.
Jeg har prøvet at lave en alter database datafile 3 end backup;, og det giver også fejl.
SQL> alter database datafile 3 end backup;
alter database datafile 3 end backup
*
FEJL i linie 1:
ORA-01235: END BACKUP fejlede for 1 fil(er) og er fuldf°rt for 0
ORA-01234: kan ikke afslutte backup af filen 3 - filen er i brug eller
retableres
ORA-01110: datafilen 3: 'D:\ORACLE\ORADATA\DW\CWMLITE01.DBF'
Login.
Når jeg forsøger at logge ind, så "hænger" indlogningen bare. Jeg kommer ikke ind.
Ingen login triggers.
jeg kan ikke køre det script. Så hænger SQL*plus også bare.

prøv:

shutdown immediate
startup mount
recover database
SELECT * FROM V$BACKUP;
check også v$datafile
hvis alt er online og der ikke er noget der står i backup kan du
alter database open;

Jeg kan ikke lave en shutdown immediate;
Så kommer den med en fejl:
SQL> shutdown immediate;
ORA-01149: nedlukning er ikke mulig - filen 3 er sat til online-backup
ORA-01110: datafilen 3: 'D:\ORACLE\ORADATA\DW\CWMLITE01.DBF'

Tror bare, at jeg bliver nødt til at genstarte serveren, og så håbe på, at den kommer op igen.

check lige at du har 'D:\ORACLE\ORADATA\DW\CWMLITE01.DBF' på dit drev?
Hvad siger tidsstempel på den?

ellers brug en shutdown abort og gør de samme ting som jeg har skrevet ovenfor.

startup mount
recover database
SELECT * FROM V$BACKUP;
check også v$datafile
hvis alt er online og der ikke er noget der står i backup kan du
alter database open;

Jeg har en fil med det navn
Tidsstempel
19-08-2005 10:38
Så tror jeg, at jeg prøver det imorgen tidlig.
Tak for hjælpen Paw.

Hej Paw

Jeg genstartede serveren, og krydsede hvad der krydes kunne, og så kom serveren op.
Basen var i mount, så jeg lavede en recover database. Kiggede på datafilerne, og det så fint ud.
Alter database open; og nu er jeg kørende igen.
Mange tak for hjælpen.
Mvh
Lars

Jeg har fundet ud af, hvorfor jeg ikke kunne logge ind på basen, og den bare hang.
Jeg har sat archivelog til på basen, men jeg har "glemt" at skrive: alter system archive log start;

hehe.. ok det er en klasiker :-D