00052.Oracle控制文件移动

SQL> col namefor a40

SQL> set line120

SQL> select *from v$controlfile;

STATUS         NAME                                     IS_RECBLOCK_SIZE FILE_SIZE_BLKS

------------------------------------------------------ ------ ---------- --------------

              /home/oracle/oracle/oradata/mdsp/control NO          16384            606

               01.ctl

 

              /home/oracle/oracle/recovery_area/mdsp/c NO          16384            606

               ontrol02.ctl

SQL>alter systemset control_file='/home/oracle/oracle/backup/control01.ctl','/home/oracle/oracle/backup/control02.ctl ' scope=spfile;

SQL>shutdown  immediate

SQL>host cp/home/oracle/oracle/oradata/mdsp/control01.ctl/home/oracle/oracle/backup/control01.ctl

SQL>host cp/home/oracle/oracle/oradata/mdsp/control02.ctl/home/oracle/oracle/backup/control02.ctl

SQL>startup