Oracle遷移資料庫過程記錄

2010年4月23日，遷移了部分資料檔案，但是沒有調整臨時表空間的設定。

OS:windows server 2003 x64 english

DB:oracle 10.2

oracel_sid=er1

Achivelog=no

[@more@]

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

D:Documents and SettingsAdministrator>set oracle_sid=er1

D:Documents and SettingsAdministrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Apr 23 19:07:05 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1358954496 bytes
Fixed Size 2053432 bytes
Variable Size 687868616 bytes
Database Buffers 654311424 bytes
Redo Buffers 14721024 bytes
Database mounted.
SQL> alter database rename file 'G:oracleER1sapdata1sr3_1SR3.DATA1',
2 'G:oracleER1sapdata1sr3_2SR3.DATA2',
3 'G:oracleER1sapdata1sr3_3SR3.DATA3',
4 'G:oracleER1sapdata1sr3_4SR3.DATA4',
5 'G:oracleER1sapdata1sr3_5SR3.DATA5',
6 'G:oracleER1sapdata1sr3usr_1SR3USR.DATA1',
7 'G:oracleER1sapdata1sr3700_1SR3700.DATA1',
8 'G:oracleER1sapdata1sr3700_2SR3700.DATA2',
9 'G:oracleER1sapdata1sr3700_3SR3700.DATA3',
10 'G:oracleER1sapdata1sr3700_4SR3700.DATA4',
11 'G:oracleER1sapdata1sysaux_1SYSAUX.DATA1',
12 'G:oracleER1sapdata1system_1SYSTEM.DATA1',
13 'G:oracleER1sapdata2sr3_6SR3.DATA6',
14 'G:oracleER1sapdata2sr3_7SR3.DATA7',
15 'G:oracleER1sapdata2sr3_8SR3.DATA8',
16 'G:oracleER1sapdata2sr3_9SR3.DATA9',
17 'G:oracleER1sapdata2sr3_10SR3.DATA10',
18 'G:oracleER1sapdata2sr3700_5SR3700.DATA5',
19 'G:oracleER1sapdata2sr3700_6SR3700.DATA6',
20 'G:oracleER1sapdata2sr3700_7SR3700.DATA7',
21 'G:oracleER1sapdata2sr3700_8SR3700.DATA8',
22 'G:oracleER1sapdata2temp_1TEMP.DATA1',
23 'G:oracleER1sapdata3sr3_11SR3.DATA11',
24 'G:oracleER1sapdata3sr3_12SR3.DATA12',
25 'G:oracleER1sapdata3sr3_13SR3.DATA13',
26 'G:oracleER1sapdata3sr3_14SR3.DATA14',
27 'G:oracleER1sapdata3sr3_15SR3.DATA15',
28 'G:oracleER1sapdata3sr3700_9SR3700.DATA9',
29 'G:oracleER1sapdata3sr3700_10SR3700.DATA10',
30 'G:oracleER1sapdata3sr3700_11SR3700.DATA11',
31 'G:oracleER1sapdata3sr3700_12SR3700.DATA12',
32 'G:oracleER1sapdata3undo_1UNDO.DATA1',
33 'G:oracleER1sapdata4sr3_16SR3.DATA16',
34 'G:oracleER1sapdata4sr3_17SR3.DATA17',
35 'G:oracleER1sapdata4sr3_18SR3.DATA18',
36 'G:oracleER1sapdata4sr3_19SR3.DATA19',
37 'G:oracleER1sapdata4sr3_20SR3.DATA20',
38 'G:oracleER1sapdata4sr3700_13SR3700.DATA13',
39 'G:oracleER1sapdata4sr3700_14SR3700.DATA14',
40 'G:oracleER1sapdata4sr3700_15SR3700.DATA15',
41 'G:oracleER1sapdata4sr3700_16SR3700.DATA16'
42 to
43 'J:oracleER1sapdata1sr3_1SR3.DATA1',
44 'J:oracleER1sapdata1sr3_2SR3.DATA2',
45 'J:oracleER1sapdata1sr3_3SR3.DATA3',
46 'J:oracleER1sapdata1sr3_4SR3.DATA4',
47 'J:oracleER1sapdata1sr3_5SR3.DATA5',
48 'J:oracleER1sapdata1sr3usr_1SR3USR.DATA1',
49 'J:oracleER1sapdata1sr3700_1SR3700.DATA1',
50 'J:oracleER1sapdata1sr3700_2SR3700.DATA2',
51 'J:oracleER1sapdata1sr3700_3SR3700.DATA3',
52 'J:oracleER1sapdata1sr3700_4SR3700.DATA4',
53 'J:oracleER1sapdata1sysaux_1SYSAUX.DATA1',
54 'J:oracleER1sapdata1system_1SYSTEM.DATA1',
55 'J:oracleER1sapdata2sr3_6SR3.DATA6',
56 'J:oracleER1sapdata2sr3_7SR3.DATA7',
57 'J:oracleER1sapdata2sr3_8SR3.DATA8',
58 'J:oracleER1sapdata2sr3_9SR3.DATA9',
59 'J:oracleER1sapdata2sr3_10SR3.DATA10',
60 'J:oracleER1sapdata2sr3700_5SR3700.DATA5',
61 'J:oracleER1sapdata2sr3700_6SR3700.DATA6',
62 'J:oracleER1sapdata2sr3700_7SR3700.DATA7',
63 'J:oracleER1sapdata2sr3700_8SR3700.DATA8',
64 'J:oracleER1sapdata2temp_1TEMP.DATA1',
65 'J:oracleER1sapdata3sr3_11SR3.DATA11',
66 'J:oracleER1sapdata3sr3_12SR3.DATA12',
67 'J:oracleER1sapdata3sr3_13SR3.DATA13',
68 'J:oracleER1sapdata3sr3_14SR3.DATA14',
69 'J:oracleER1sapdata3sr3_15SR3.DATA15',
70 'J:oracleER1sapdata3sr3700_9SR3700.DATA9',
71 'J:oracleER1sapdata3sr3700_10SR3700.DATA10',
72 'J:oracleER1sapdata3sr3700_11SR3700.DATA11',
73 'J:oracleER1sapdata3sr3700_12SR3700.DATA12',
74 'J:oracleER1sapdata3undo_1UNDO.DATA1',
75 'J:oracleER1sapdata4sr3_16SR3.DATA16',
76 'J:oracleER1sapdata4sr3_17SR3.DATA17',
77 'J:oracleER1sapdata4sr3_18SR3.DATA18',
78 'J:oracleER1sapdata4sr3_19SR3.DATA19',
79 'J:oracleER1sapdata4sr3_20SR3.DATA20',
80 'J:oracleER1sapdata4sr3700_13SR3700.DATA13',
81 'J:oracleER1sapdata4sr3700_14SR3700.DATA14',
82 'J:oracleER1sapdata4sr3700_15SR3700.DATA15',
83 'J:oracleER1sapdata4sr3700_16SR3700.DATA16'
84 ;

Database altered.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------

J:ORACLEER1SAPDATA1SYSTEM_1SYSTEM.DATA1
J:ORACLEER1SAPDATA3UNDO_1UNDO.DATA1
J:ORACLEER1SAPDATA1SYSAUX_1SYSAUX.DATA1
J:ORACLEER1SAPDATA1SR3_1SR3.DATA1
J:ORACLEER1SAPDATA1SR3_2SR3.DATA2
J:ORACLEER1SAPDATA1SR3_3SR3.DATA3
J:ORACLEER1SAPDATA1SR3_4SR3.DATA4
J:ORACLEER1SAPDATA1SR3_5SR3.DATA5
J:ORACLEER1SAPDATA2SR3_6SR3.DATA6
J:ORACLEER1SAPDATA2SR3_7SR3.DATA7
J:ORACLEER1SAPDATA2SR3_8SR3.DATA8

NAME
--------------------------------------------------------------------------------

J:ORACLEER1SAPDATA2SR3_9SR3.DATA9
J:ORACLEER1SAPDATA2SR3_10SR3.DATA10
J:ORACLEER1SAPDATA3SR3_11SR3.DATA11
J:ORACLEER1SAPDATA3SR3_12SR3.DATA12
J:ORACLEER1SAPDATA3SR3_13SR3.DATA13
J:ORACLEER1SAPDATA3SR3_14SR3.DATA14
J:ORACLEER1SAPDATA3SR3_15SR3.DATA15
J:ORACLEER1SAPDATA4SR3_16SR3.DATA16
J:ORACLEER1SAPDATA4SR3_17SR3.DATA17
J:ORACLEER1SAPDATA4SR3_18SR3.DATA18
J:ORACLEER1SAPDATA4SR3_19SR3.DATA19

NAME
--------------------------------------------------------------------------------

J:ORACLEER1SAPDATA4SR3_20SR3.DATA20
J:ORACLEER1SAPDATA1SR3700_1SR3700.DATA1
J:ORACLEER1SAPDATA1SR3700_2SR3700.DATA2
J:ORACLEER1SAPDATA1SR3700_3SR3700.DATA3
J:ORACLEER1SAPDATA1SR3700_4SR3700.DATA4
J:ORACLEER1SAPDATA2SR3700_5SR3700.DATA5
J:ORACLEER1SAPDATA2SR3700_6SR3700.DATA6
J:ORACLEER1SAPDATA2SR3700_7SR3700.DATA7
J:ORACLEER1SAPDATA2SR3700_8SR3700.DATA8
J:ORACLEER1SAPDATA3SR3700_9SR3700.DATA9
J:ORACLEER1SAPDATA3SR3700_10SR3700.DATA10

NAME
--------------------------------------------------------------------------------

J:ORACLEER1SAPDATA3SR3700_11SR3700.DATA11
J:ORACLEER1SAPDATA3SR3700_12SR3700.DATA12
J:ORACLEER1SAPDATA4SR3700_13SR3700.DATA13
J:ORACLEER1SAPDATA4SR3700_14SR3700.DATA14
J:ORACLEER1SAPDATA4SR3700_15SR3700.DATA15
J:ORACLEER1SAPDATA4SR3700_16SR3700.DATA16
J:ORACLEER1SAPDATA1SR3USR_1SR3USR.DATA1

40 rows selected.

SQL> alter database recover datafile 'J:oracleER1sapdata1sr3_1SR3.DATA1',
2 'J:oracleER1sapdata1sr3_2SR3.DATA2',
3 'J:oracleER1sapdata1sr3_3SR3.DATA3',
4 'J:oracleER1sapdata1sr3_4SR3.DATA4',
5 'J:oracleER1sapdata1sr3_5SR3.DATA5',
6 'J:oracleER1sapdata1sr3usr_1SR3USR.DATA1',
7 'J:oracleER1sapdata1sr3700_1SR3700.DATA1',
8 'J:oracleER1sapdata1sr3700_2SR3700.DATA2',
9 'J:oracleER1sapdata1sr3700_3SR3700.DATA3',
10 'J:oracleER1sapdata1sr3700_4SR3700.DATA4',
11 'J:oracleER1sapdata1sysaux_1SYSAUX.DATA1',
12 'J:oracleER1sapdata2sr3_6SR3.DATA6',
13 'J:oracleER1sapdata2sr3_7SR3.DATA7',
14 'J:oracleER1sapdata2sr3_8SR3.DATA8',
15 'J:oracleER1sapdata2sr3_9SR3.DATA9',
16 'J:oracleER1sapdata2sr3_10SR3.DATA10',
17 'J:oracleER1sapdata2sr3700_5SR3700.DATA5',
18 'J:oracleER1sapdata2sr3700_6SR3700.DATA6',
19 'J:oracleER1sapdata2sr3700_7SR3700.DATA7',
20 'J:oracleER1sapdata2sr3700_8SR3700.DATA8',
21 'J:oracleER1sapdata3sr3_11SR3.DATA11',
22 'J:oracleER1sapdata3sr3_12SR3.DATA12',
23 'J:oracleER1sapdata3sr3_13SR3.DATA13',
24 'J:oracleER1sapdata3sr3_14SR3.DATA14',
25 'J:oracleER1sapdata3sr3_15SR3.DATA15',
26 'J:oracleER1sapdata3sr3700_9SR3700.DATA9',
27 'J:oracleER1sapdata3sr3700_10SR3700.DATA10',
28 'J:oracleER1sapdata3sr3700_11SR3700.DATA11',
29 'J:oracleER1sapdata3sr3700_12SR3700.DATA12',
30 'J:oracleER1sapdata3undo_1UNDO.DATA1',
31 'J:oracleER1sapdata4sr3_16SR3.DATA16',
32 'J:oracleER1sapdata4sr3_17SR3.DATA17',
33 'J:oracleER1sapdata4sr3_18SR3.DATA18',
34 'J:oracleER1sapdata4sr3_19SR3.DATA19',
35 'J:oracleER1sapdata4sr3_20SR3.DATA20',
36 'J:oracleER1sapdata4sr3700_13SR3700.DATA13',
37 'J:oracleER1sapdata4sr3700_14SR3700.DATA14',
38 'J:oracleER1sapdata4sr3700_15SR3700.DATA15',
39 'J:oracleER1sapdata4sr3700_16SR3700.DATA16';

Database altered.

SQL> alter database open;

Database altered.

File:http://trigger_lau.itpub.net/get/370/oracle_trans_process.txt