手工创建控制文件

1> 最首要的备份方法是将控制文件备份为二进制文件.
ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/cf.bak' REUSE;
reuse:参数reuse的含义是可以直接将/oracle/backup/cf.bak代替现在的控制文件
2>
A binary backup is preferable to a trace file backup because it
contains additional information such as the archived log history, offline range for
read-only and offline tablespaces, and backup sets and copies (if you use RMAN).
Note that binary control file backups do not include tempfile entries.
3> to trace方式备份控制文件,获取控制文件创建脚本,方便手工创建控制文件.

[@more@]

1> 最首要的备份方法是将控制文件备份为二进制文件.
ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/cf.bak' REUSE;
reuse:参数reuse的含义是可以直接将/oracle/backup/cf.bak代替现在的控制文件
2>
A binary backup is preferable to a trace file backup because it
contains additional information such as the archived log history, offline range for
read-only and offline tablespaces, and backup sets and copies (if you use RMAN).
Note that binary control file backups do not include tempfile entries.
3> to trace方式备份控制文件,获取控制文件创建脚本,方便手工创建控制文件.

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

数据库已更改。
SQL> show parameter user_dump_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest                       string      D:oracleadminliyongudump

通过打开D:oracleadminliyongudump目录最近产生的trace文件,
可以手工创建控制文件.

CREATE CONTROLFILE REUSE DATABASE "LIYONG" NORESETLOGS  ARCHIVELOG
--  SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 'D:ORACLEORADATALIYONGREDO01.LOG'  SIZE 100M,
  GROUP 2 'D:ORACLEORADATALIYONGREDO02.LOG'  SIZE 100M,
  GROUP 3 'D:ORACLEORADATALIYONGREDO03.LOG'  SIZE 100M
-- STANDBY LOGFILE
DATAFILE
  'D:ORACLEORADATALIYONGSYSTEM01.DBF',
  'D:ORACLEORADATALIYONGUNDOTBS01.DBF',
  'D:ORACLEORADATALIYONGCWMLITE01.DBF',
  'D:ORACLEORADATALIYONGDRSYS01.DBF',
  'D:ORACLEORADATALIYONGEXAMPLE01.DBF',
  'D:ORACLEORADATALIYONGINDX01.DBF',
  'D:ORACLEORADATALIYONGODM01.DBF',
  'D:ORACLEORADATALIYONGTOOLS01.DBF',
  'D:ORACLEORADATALIYONGUSERS01.DBF',
  'D:ORACLEORADATALIYONGXDB01.DBF',
  'D:ORACLEORADATALIYONGBUSINESS.DBF',
  'D:ORACLEORADATALIYONGBILLING.DBF'
CHARACTER SET ZHS16GBK
;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/76065/viewspace-791939/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/76065/viewspace-791939/