|
1
|
/**
|
|
2
|
* This file is to alter the system and other file's location in control file
|
|
3
|
* It is for running the data file from knb backup archive file. Since the user
|
|
4
|
* change the files location, the the infomoration need be updated in control file
|
|
5
|
* Note: the new location should be correcte and should be modified.
|
|
6
|
*/
|
|
7
|
|
|
8
|
|
|
9
|
/**
|
|
10
|
*alter database rename file '/oracle01/oradata/knb/system01.dbf' to '/oracle01/oradata/knb/system01.dbf';
|
|
11
|
*/
|
|
12
|
|
|
13
|
alter database rename file '/oracle01/oradata/knb/system02.dbf' to '/oracle02/oradata/knb/system02.dbf';
|
|
14
|
|
|
15
|
alter database rename file '/oracle01/oradata/knb/system03.dbf' to '/oracle02/oradata/knb/system03.dbf';
|
|
16
|
|
|
17
|
alter database rename file '/oracle01/oradata/knb/drsys01.dbf' to '/oracle03/oradata/knb/drsys01.dbf';
|
|
18
|
|
|
19
|
alter database rename file '/oracle01/oradata/knb/indx01.dbf' to '/oracle03/oradata/knb/indx01.dbf';
|
|
20
|
|
|
21
|
alter database rename file '/oracle01/oradata/knb/rbs01.dbf' to '/oracle03/oradata/knb/rbs01.dbf';
|
|
22
|
|
|
23
|
alter database rename file '/oracle01/oradata/knb/redo01.log' to '/oracle03/oradata/knb/redo01.log';
|
|
24
|
|
|
25
|
alter database rename file '/oracle01/oradata/knb/redo02.log' to '/oracle03/oradata/knb/redo02.log';
|
|
26
|
|
|
27
|
alter database rename file '/oracle01/oradata/knb/redo03.log' to '/oracle03/oradata/knb/redo03.log';
|
|
28
|
|
|
29
|
alter database rename file '/oracle02/oradata/knb/system04.dbf' to '/oracle03/oradata/knb/system04.dbf';
|
|
30
|
|
|
31
|
alter database rename file '/oracle01/oradata/knb/temp01.dbf' to '/oracle03/oradata/knb/temp01.dbf';
|
|
32
|
|
|
33
|
alter database rename file '/oracle01/oradata/knb/tools01.dbf' to '/oracle03/oradata/knb/tools01.dbf';
|
|
34
|
|
|
35
|
alter database rename file '/oracle01/oradata/knb/users01.dbf' to '/oracle03/oradata/knb/users01.dbf';
|
|
36
|
|