SLTechnology News&Howtos › Database ›

Oracle steps to move control files under Linux

Shulou Source: shulou.com Published: 2022-06-01 07:19:04 10月17日 Update

1. View control file

[oracle@dbserver ~] $sqlplus / as sysdba

SQL > desc v$controlfile

SQL > select * from v$controlfile

two。 Create a new directory

$mkdir-p u01/oradata/epps

$mkdir-p u02/oradata/epps

$mkdir-p u03/oradata/epps

3. Check to see if it starts with spfile

SQL > show parameter spfile

(VALUE value is not empty, start for spfile)

4. Modify the control file location

SQL > alter system set control_files=

'u01Compact oradata'eppsUniverse control01.ctl`

'u02Universe oradata'eppsUniverse control02.ctl`

'u03Compact oradata'eppsUniverse control03.ctl`

Scope=spfile

5. Shut down the database

SQL > shutdown immediate

6. Mobile control file

SQL >! Mv / u01/app/oracle/oradata/epps/control01.ctl / u01/oradata/epps

SQL >! Mv / u01/app/oracle/oradata/epps/control02.ctl / u02/oradata/epps/

SQL >! Mv / u01/app/oracle/oradata/epps/control03.ctl / u03/oradata/epps/

7. Start the database

SQL > startup

8. Check complete

SQL > select * from v$controlfile