Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.