oracle如何生成control文件,创建control_file是包错:ORA-01503: CREATE CONTROLFILE failed

Problem Description:

====================

You are attempting to recreate the controlfiles for an existing database.

During creation you may see the following errors:

Case 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file '/u02/oradata/RM805/system01.dbf'

ORA-27046: file size is not a multiple of logical block size

- or -

Case 2:

ORA-01503: CREATE CONTROLFILE failed

ORA-01160: file is not a data file

ORA-01110: data file : '/u02/oradata/RM805/system01.dbf'

Solution Description:

=====================

Adjust the DB_BLOCK_SIZE parameter accordingly:

- If you received the errors in Case 1 (ORA-01503, ORA-01565, and ORA-27046),

you should decrease the value specified by DB_BLOCK_SIZE before you attempt

to recreate the controlfile.

- If you received the errors in Case 2 (ORA-01503, ORA-01160, and ORA-01110),

you should increase the value specified by DB_BLOCK_SIZE before you attempt

to recreate the controlfile.

Explanation:

============

Both cases occur due to an incorrect setting of the db_block_size parameter in

the "init.ora" file.

Case 1: The specified db_block_size in the "init.ora" is too large.

Case 2: The specified db_block_size in the "init.ora" is too small.

The database blocksize must be specified correctly in the init.ora in order

to successfully recreate the controlfile.

Search Words:

=============

ORA-1503 ORA-1565 ORA-1503 ORA-1160 ORA-1110

  • 0
    点赞
  • 0
    收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:数字20 设计师:CSDN官方博客 返回首页
评论
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值