Controlfile_Перенос

Для отдельной БД(не находящейся в кластере)

Выполните следующие шаги для переноса Controlfile из /u01 в /u03

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 target / 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

Взято с https://dbaclass.com/article/move-controlfile-new-location/