Project

General

Profile

Download (1.66 KB) Statistics
| Revision:

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

1 2662 tao 
/**
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';