Home A - Z
Menu

Blame

d2accd feagor 2025-12-06 09:51:32
1 
# Controlfile_Перенос
2
3
Для отдельной БД(не находящейся в кластере)
4
5
Выполните следующие шаги для переноса Controlfile из /u01 в /u03
6
7
``SQL> show parameter control_files
8
9
NAME TYPE VALUE
10
------------------------------------ -------------------------------- ------------------------------
11
control_files string /u01/oracle/dbaclass/control01.ctl
12
13
14
SQL> alter system set control_files='/u03/oracle/dbaclass/control01.ctl' scope=spfile;
15
System altered.
16
17
18
shutdown immediate;
19
startup nomount
20
21
22
rman target /
23
RMAN> restore controlfile from '/u01/oracle/dbaclass/control01.ctl';
24
25
Starting restore at 13-JAN-19
26
using target database control file instead of recovery catalog
27
allocated channel: ORA_DISK_1
28
channel ORA_DISK_1: SID=2201 device type=DISK
29
30
channel ORA_DISK_1: copied control file copy
31
output file name=/u03/oracle/dbaclass/control01.ctl
32
Finished restore at 13-JAN-19
33
34
35
alter database mount;
36
alter database open;
37
38
39
SQL> show parameter control_files
40
41
NAME TYPE VALUE
42
------------------------------------ -------------------------------- ------------------------------
43
control_files string /u03/oracle/dbaclass/control01.ctl
44
45
Взято с https://dbaclass.com/article/move-controlfile-new-location/