22. august 2005 - 09:48
Der er
11 kommentarer og 2 løsninger
Backup af Oracle 9i
Hej Jeg har en database, som jeg ikke kan connecte til med en alm. bruger. Jeg kan kun connecte med SYS. Min base kører i archivelog mode. Jeg kan ikke lave en: alter <TABLESPACE> begin backup; Så står det bare stille. Nu er mit spørgsmål så, om jeg kan lave en alm. filbackup, og evt. bruge den til noget som helst?? Mvh Lars
Annonceindlæg fra Computerworld
22. august 2005 - 11:48
#1
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.
22. august 2005 - 12:10
#2
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
22. august 2005 - 12:13
#3
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
22. august 2005 - 12:56
#4
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.
22. august 2005 - 14:40
#5
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.
22. august 2005 - 14:58
#6
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.
22. august 2005 - 15:45
#7
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;
22. august 2005 - 15:47
#8
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.
22. august 2005 - 15:58
#9
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;
22. august 2005 - 16:08
#10
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.
23. august 2005 - 12:02
#11
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
24. august 2005 - 08:38
#12
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;
24. august 2005 - 18:22
#13
hehe.. ok det er en klasiker :-D
Computerworld tilbyder specialiserede kurser i database-management