Bo's Oracle Station

查看: 2483|回复: 0

第15次活动:2017-08-30(星期三晚上7:00-10:00)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-8-31 09:38:03 | 显示全部楼层 |阅读模式
  1. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  2. Connected to database ORCL (DBID=1347195613)

  3. Connected to server version 11.2.0

  4. Control Files in database:
  5.     /u01/app/oracle/oradata/winorcl/control01.ctl
  6.     /u01/app/oracle/oradata/winorcl/control02.ctl
  7.     /u01/app/oracle/oradata/winorcl/control03.ctl

  8. Change database ID and database name ORCL to WINORCL? (Y/[N]) => Y

  9. Proceeding with operation
  10. Changing database ID from 1347195613 to 2101527165
  11. Changing database name from ORCL to WINORCL
  12.     Control File /u01/app/oracle/oradata/winorcl/control01.ctl - modified
  13.     Control File /u01/app/oracle/oradata/winorcl/control02.ctl - modified
  14.     Control File /u01/app/oracle/oradata/winorcl/control03.ctl - modified
  15.     Datafile /u01/app/oracle/oradata/winorcl/system01.db - dbid changed, wrote new name
  16.     Datafile /u01/app/oracle/oradata/winorcl/sysaux01.db - dbid changed, wrote new name
  17.     Datafile /u01/app/oracle/oradata/winorcl/undotbs1.db - dbid changed, wrote new name
  18.     Datafile /u01/app/oracle/oradata/winorcl/users01.db - dbid changed, wrote new name
  19.     Datafile /u01/app/oracle/oradata/winorcl/example01.db - dbid changed, wrote new name
  20.     Datafile /u01/app/oracle/oradata/winorcl/temp01.db - dbid changed, wrote new name
  21.     Control File /u01/app/oracle/oradata/winorcl/control01.ctl - dbid changed, wrote new name
  22.     Control File /u01/app/oracle/oradata/winorcl/control02.ctl - dbid changed, wrote new name
  23.     Control File /u01/app/oracle/oradata/winorcl/control03.ctl - dbid changed, wrote new name
  24.     Instance shut down

  25. Database name changed to WINORCL.
  26. Modify parameter file and generate a new password file before restarting.
  27. Database ID for database WINORCL changed to 2101527165.
  28. All previous backups and archived redo logs for this database are unusable.
  29. Database is not aware of previous backups and archived logs in Recovery Area.
  30. Database has been shutdown, open database with RESETLOGS option.
  31. Succesfully changed database name and ID.
  32. DBNEWID - Completed succesfully.

复制代码
Screenshot.png
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-4-29 09:06 , Processed in 0.049828 second(s), 27 queries .

快速回复 返回顶部 返回列表