ITPub博客

首页 > 应用开发 > IT综合 > 手工创建控制文件

手工创建控制文件

原创 IT综合 作者:foreverlee 时间:2005-03-08 13:37:32 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: crontab
请登录后发表评论 登录
全部评论

注册时间:2008-11-26

  • 博文量
    72
  • 访问量
    1354341