Project

General

Profile

metacat / src / alter-datafile-for-knbbackup.sql @ 8556

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