RMAN备份异机恢复并创建新DBID(六)
Tag: TAG20130409T093640
Piece Name: /u03/RMAN/arch0io6kr7a_18_1.bak
List of Archived Logs in backup set 14
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6 3524945662 09-APR-13 3524945667 09-APR-13
9. 用open resetlogs 打开数据库
RMAN> alter database open resetlogs;
database opened
在open resetlogs 之后，自动在原来默认的路径创建了temp 表空间和3组redo 文件。
如果恢复目录和原来相同，就不用修改。
如果目录不同，我们就需要把这些文件移到我们现在的data目录。
10. NID 修改DBID和DBNAME
SQL> select name,dbid from v$database;
NAME DBID
--------- ----------
ORCL 1230508166
几点说明：
（1）在修改DBID期间仍然可能会遇到不可恢复的错误。所以修改之前备份数据库，特使是控制文件。因为nid 会修改控制文件中的信息。
（2）需要将DB 启动到mount 状态才能修改。
SQL> shutdown immediate
SQL> startup mount;
在执行NID 命令之前：一定要关闭所有的session连接。
nid 命令到执行的最后会关闭数据库，如果有session 连接，就会阻止这个操作，修改dbid就会被挂死。如果中断这个操作。修改就会失败，数据库就不能mount。需要恢复。
（1）只改DBID，不改db_name
[oracle@rhel133 orcl]$ nid target=sys/oracle
DBNEWID: Release 10.2.0.4.0 - Production on Tue Apr 9 16:48:51 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to database ORCL (DBID=1230508166)
Connected to server version 10.2.0
Control Files in database:
/u01/oradata/orcl/control01.ctl
/u01/oradata/orcl/control02.ctl
/u01/oradata/orcl/control03.ctl
Change database ID of database ORCL (Y/[N]) => y
Proceeding with operation
Changing database ID from 1230508166 to 1340095604
Control File /u01/oradata/orcl/control01.ctl - modified
Control File /u01/oradata/orcl/control02.ctl - modified
Control File /u01/oradata/orcl/control03.ctl - modified
Datafile /u01/oradata/orcl/system01.dbf - dbid changed
Datafile /u01/oradata/orcl/undotbs01.dbf - dbid changed
Datafile /u01/oradata/orcl/sysaux01.dbf - dbid changed
Datafile /u01/oradata/orcl/DEALSPACE_002.dbf - dbid changed
Datafile /u01/oradata/orcl/DEALSPACE_001.dbf - dbid changed
Datafile /u01/oradata/orcl/l5mspace01.dbf - dbid changed
Datafile /u01/oradata/orcl/RCFSPACE_002.dbf - dbid changed
Datafile /u01/oradata/orcl/RCFSPACE_001.dbf - dbid changed
Datafile /u01/oradata/orcl/DTSPACE_001.dbf - dbid changed
Datafile /u01/oradata/orcl/temp01.dbf - dbid changed
Control File /u01/oradata/orcl/control01.ctl - dbid changed
Control File /u01/oradata/orcl/control02.ctl - dbid changed
Control File /u01/oradata/orcl/control03.ctl - dbid changed
Instance shut down
Database ID for database ORCL changed to 1340095604.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.
SQL> startup
ORACLE instance started.
Total System Global Area 1325400064 bytes
Fixed Size 1267236 bytes
Variable Size 1256196572 bytes
Database Buffers 52428800 bytes
Redo Buffers 15507456 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for data