DBA Hub

📋Steps in this guide1/2

How to move controlfile to a new location in oracle database DBACLASS

Below are steps to move or rename controlfile to a new location(Mount point or diskgroup). In ORACLE RAC:(Move from +ORACLDG diskgroup to +DATA diskgroup) 1. Get the current control_file location SQL> show parameter control_files NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ control_files string +ORACLDG/DBACLASS/CONTROLFILE/co

oracle configurationintermediate
by OracleDba
20 views
1

In ORACLE RAC:(Move from +ORACLDG diskgroup to +DATA diskgroup)

1. Get the current control_file location 2. Set the new location of controlfile: 3. start the database in nomount stage: 4. Restore controlfile to new location: 5. restart the database: 6. Check the control_file again:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
SQL>  show parameter control_files

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
control_files                        string                           +ORACLDG/DBACLASS/CONTROLFILE/control01.ctl

SQL> alter system set control_files='+DATA' scope=spfile; System altered.

srvctl stop database -d DBACLASS
srvctl start database -d DBACLASS -o nomount

RMAN>  restore controlfile from '+ORACLDG/DBACLASS/CONTROLFILE/control01.ctl';

Starting restore at 13-JAN-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2201 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+DATA/DBACLASS/CONTROLFILE/current.349.997455411
Finished restore at 13-JAN-19

srvctl stop database -d DBACLASS
srvctl start database -d DBACLASS

SQL>  show parameter control_files


NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
control_files                        string                           +DATA/DBACLASS/CONTROLFILE/curren
                                                                      t.349.997455411
2

FOR STANDALONE DB(SINGLE INSTANCE DB):

Follow below steps if controlfile resides inside file system(Move from /u01 mount point to /u03 ) 1. Get the current control_file location 2. Set the new location of controfile: 3. start the database in nomount stage: 4. Restore controlfile to new location: 5. restart the database: 6. Check the control_file again:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
SQL>  show parameter control_files

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
control_files                        string                           /u01/oracle/dbaclass/control01.ctl

SQL> alter system set control_files='/u03/oracle/dbaclass/control01.ctl' scope=spfile;

System altered.

shutdown immediate;
startup nomount

RMAN>  restore controlfile  from '/u01/oracle/dbaclass/control01.ctl';

Starting restore at 13-JAN-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2201 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=/u03/oracle/dbaclass/control01.ctl
Finished restore at 13-JAN-19

alter database mount;
alter database open;

SQL>  show parameter control_files


NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
control_files                        string                           /u03/oracle/dbaclass/control01.ctl

Comments (0)

Please to add comments

No comments yet. Be the first to comment!