Commit d2accd
2025-12-06 09:51:32 feagor: -/-| /dev/null .. oracle/oracle_files/Controlfile_Перенос.md | |
| @@ 0,0 1,45 @@ | |
| + | # 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/ |