OracleÊý¾ÝÎļþǨÒÆÖª¶àÉÙ£¿

±¾ÈËÒÔÇ°ÕûÀíµÄÊý¾Ý¿âÎļþǨÒƹý³Ì£¬Ï£ÍûÄܹ»¶Ô´ó¼ÒÓÐËù°ïÖú
1¡¢sqlplus "sys/sys@·þÎñÃû as sysdba"
 
2¡¢Ð޸ĿØÖÆÎļþ:
 
    alter system set control_files='E:\oracle\oradata\myOracle_1\control01.ctl',
 'E:\oracle\oradata\myOracle_1\control02.ctl','E:\oracle\oradata\myOracle_1\control03.ctl'
  scope=spfile;
3¡¢±¸·Ý¿ØÖÆÎļþ
 alter database backup controlfile to 'E:\oracle\oradata\testdb.ctl' reuse;
4¡¢±¸·Ýµ½¸ú×ÙÎļþ, ·½±ãÖؽ¨¿ØÖÆÎļþ
 alter database backup controlfile to trace;
6¡¢²é¿´´æ·Å·¾¶
 show parameter user_dump_dest
 
6¡¢Êý¾ÝÎļþ¿½±´µ½¶ÔÓ¦µÄĿ¼:
  
7¡¢µ½¶ÔÓ¦µÄORACLEµÄÊý¾ÝĿ¼ user_dump_des,ÕÒµ½¶ÔÓ¦µÄ×îеÄTRACEÎļþ£¬¿½±´¶ÔÓ¦µÄÊý¾Ý³öÀ´£º
 ÄÚÈÝÈçÏ£º
 1¡¢ÖØ×öÈÕÖ¾Îļþ¿ÉÓõÄÇé¿ö
 STARTUP NOMOUNT;
 
 CREATE CONTROLFILE REUSE DATABASE "MYORACLE" NORESETLOGS  NOARCHIVELOG
 --  SET STANDBY TO MAXIMIZE PERFORMANCE
     MAXLOGFILES 3
     MAXLOGMEMBERS 3
     MAXDATAFILES 20
     MAXINSTANCES 1
     MAXLOGHISTORY 226
 LOGFILE
   GROUP 1 'E:\ORACLE\ORADATA\MYORACLE_1\REDO01.LOG'  SIZE 30M,
   GROUP 2 'E:\ORACLE\ORADATA\MYORACLE_1\REDO02.LOG'  SIZE 30M,
   GROUP 3 'E:\ORACLE\ORADATA\MYORACLE_1\REDO03.LOG'  SIZE 30M
 -- STANDBY LOGFILE
 DATAFILE
   'E:\ORACLE\ORADATA\MYORACLE_1\SYSTEM01.DBF',
   'E:\ORACLE\ORADATA\MYORACLE_1\UNDOTBS01.DBF',
   'E:\ORACLE\ORADATA\MYORACLE_1\DRSYS01.DBF',
   'E:\ORACLE\ORADATA\MYORACLE_1\INDX01.DBF',
   'E:\ORACLE\ORADATA\MYORACLE_1\TOOLS01.DBF',
   'E:\ORACLE\ORADATA\MYORACLE_1\USERS01.DBF',
   'E:\ORACLE\ORADATA\MYORACLE_1\XDB01.DBF',
   'E:\ORACLE\ORADATA\MYORACLE_1\PERFSTAT.ORA'
 CHARACTER SET ZHS16GBK;
 
 alter database rename file 'E:\ORACL