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
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9826/viewspace-1033124/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 安全警示錄---記一次oracle資料檔案遷移過程Oracle
- 達夢資料庫資料檔案遷移過程資料庫
- ORACLE資料庫遷移Oracle資料庫
- 資料庫-oracle-資料庫遷移資料庫Oracle
- WindowsServer 2012資料庫遷移記錄WindowsServer資料庫
- 資料庫遷移手記資料庫
- Win環境至Linux環境Oracle資料庫遷移全過程LinuxOracle資料庫
- Oracle資料庫資料遷移流程Oracle資料庫
- Masonite 熟悉步驟小記錄 （三、資料庫遷移）資料庫
- 資料庫課程作業筆記 - 編寫資料庫遷移檔案資料庫筆記
- oracle 遷移資料庫到asmOracle資料庫ASM
- bi資料庫遷移小記資料庫
- Oracle資料庫（資料泵）遷移方案（上）Oracle資料庫
- Oracle資料庫（資料泵）遷移方案（下）Oracle資料庫
- 達夢資料庫系統表空間資料檔案遷移過程資料庫
- 無外網Oracle資料庫遷移Oracle資料庫
- Oracle資料庫（DataGuard）遷移方案(上)Oracle資料庫
- Oracle資料庫（DataGuard）遷移方案（中）Oracle資料庫
- Oracle資料庫（DataGuard）遷移方案（下）Oracle資料庫
- 【DATAPUMP】使用DataPump遷移Oracle資料庫Oracle資料庫
- Oracle資料庫遷移之一：RMANOracle資料庫
- Oracle資料庫遷移方案比較Oracle資料庫
- 使用 NFS 的資料遷移實驗過程NFS
- Duplicate+NFS資料遷移實驗過程NFS
- 【遷移】使用rman遷移資料庫資料庫
- 資料庫遷移資料庫
- ORACLE 資料遷移Oracle
- 透過rman全庫備份遷移資料庫資料庫
- 資料庫擴充套件表設計過程記錄資料庫套件
- 使用RMAN進行Oracle資料庫遷移Oracle資料庫
- ORACLE資料庫切換和遷移方案Oracle資料庫
- 跨平臺遷移oracle資料庫指南Oracle資料庫
- 資料庫遷移 ：理解資料庫
- laravel資料庫遷移Laravel資料庫
- Odoo遷移資料庫Odoo資料庫
- redis資料庫遷移Redis資料庫
- Cacti 遷移資料庫資料庫
- 資料庫遷移方案資料庫