ITPub博客

首页 > Linux操作系统 > Linux操作系统 > create controlfile 参数总结

create controlfile 参数总结

原创 Linux操作系统 作者:lynch0227 时间:2009-08-28 16:00:26 0 删除 编辑

CREATE CONTROLFILE REUSE DATABASE 'xx' NORESETLOGS  ARCHIVELOG;中参数的含义:


REUSE:
Specify REUSE to indicate that existing control files identified by the initialization parameter CONTROL_FILES can be reused, overwriting any information they may currently contain. If you omit this clause and any of these control files already exists, then Oracle Database returns an error.

RESETLOGS:
Specify RESETLOGS if you want Oracle Database to ignore the contents of the files listed in the LOGFILE clause. These files do not have to exist. Each redo_log_file_spec in the LOGFILE clause must specify the SIZE parameter. The database assigns all online redo log file groups to thread 1 and enables this thread for public use by any instance. After using this clause, you must open the database using the RESETLOGS clause of the ALTER DATABASE statement.

NORESETLOGS:  
Specify NORESETLOGS if you want Oracle Database to use all files in the LOGFILE clause as they were when the database was last open. These files must exist and must be the current online redo log files rather than restored backups. The database reassigns the redo log file groups to the threads to which they were previously assigned and reenables the threads as they were previously enabled.

ARCHIVELOG | NOARCHIVELOG:
Specify ARCHIVELOG to archive the contents of redo log files before reusing them. This clause prepares for the possibility of media recovery as well as instance or system failure recovery.
If you omit both the ARCHIVELOG clause and NOARCHIVELOG clause, then Oracle Database chooses noarchivelog mode by default. After creating the control file, you can change between archivelog mode and noarchivelog mode with the ALTER DATABASE statement.

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

上一篇: other
下一篇: sys_refcursor的用法
请登录后发表评论 登录
全部评论

注册时间:2009-04-02

  • 博文量
    32
  • 访问量
    66300