2022.2.13: 模板建库的controlfile creation脚本和跨平台迁移的对应脚本的对比
1. 模板建库的controlfile creation脚本:dbca模板建库时,设定库名为emrep,保存脚本如下:create controlfile reuse set database "emrep"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'&&file0',
'&&file1',
'&&file2',
'&&file3'
LOGFILE GROUP 1SIZE 1024M,
GROUP 2SIZE 1024M,
GROUP 3SIZE 1024M,
GROUP 4SIZE 1024M,
GROUP 5SIZE 1024M RESETLOGS;
注意:建库的create controlfile语句里有“set”,而用于恢复controlfile的trace脚本(有set1和set2两段)都没有“set”。下面查看一下该建库的create controlfile语句创建的emrep数据库的化身:
$ rman target/
Recovery Manager: Release 19.0.0.0.0 - Production on Sun Feb 13 16:44:13 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.All rights reserved.
connected to target database: EMREP (DBID=22794985)
RMAN> list incarnation of database;
using target database control file instead of recovery catalog
List of Database Incarnations
DB KeyInc Key DB NameDB ID STATUSReset SCNReset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 EMREP 22794985 PARENT1 17-APR-19
2 2 EMREP 22794985 CURRENT 1920977 23-JAN-22
RMAN>
发现会记录原模板中的化身,就是说会保留PARENT 化身,而用于恢复controlfile的trace脚本(有set1和set2两段)都清除历史化身,只会留下当前化身。注意区别。
2. 跨平台迁移的controlfile creation脚本(与改数据库名字的脚本一样):
跨平台迁移时,rman的执行“convert database to platform”会话的trace文件里有create controlfile语句保存成脚本如下:CREATE CONTROLFILE REUSE SET DATABASE mydb RESETLOGSARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcl2/redo01.log' SIZE 500M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/orcl2/redo02.log' SIZE 500M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/orcl2/redo03.log' SIZE 500M BLOCKSIZE 512
DATAFILE
'/u01/app/oracle/oradata/orcl2/sysaux01.dbf',
'/u01/app/oracle/oradata/orcl2/system01.dbf',
'/u01/app/oracle/oradata/orcl2/undotbs1.dbf',
'/u01/app/oracle/oradata/orcl2/users01.dbf'
CHARACTER SET ZHS16GBK
;
create controlfile语句里也有“set”,与模板建库情况相同,与用于恢复controlfile的trace脚本(有set1和set2两段)的情况不同,因此化身也会保留PARENT部分:
$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Sun Feb 13 16:43:16 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.All rights reserved.
connected to target database: MYDB (DBID=376305118)
RMAN> list incarnation of database;
using target database control file instead of recovery catalog
List of Database Incarnations
DB KeyInc Key DB NameDB ID STATUSReset SCNReset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 MYDB 376305118 PARENT2103854 13-FEB-22
2 2 MYDB 376305118 CURRENT 2188190 13-FEB-22
3. “nid”命令改dbid和dbname后的数据库会保留历史化身(与改数据库名字的脚本一样):
将上面的mydb数据库改名字成orcl2数据库,使用“nid target=sys/oracle_4U dbname=orcl2”命令,数据库重新启动:
$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Feb 13 16:53:49 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> create spfile from pfile;
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 2566913256 bytes
Fixed Size 8899816 bytes
Variable Size 553648128 bytes
Database Buffers 1996488704 bytes
Redo Buffers 7876608 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
Database altered.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Sun Feb 13 16:55:45 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL2 (DBID=1077418382)
RMAN> list incarnation of database;
using target database control file instead of recovery catalog
List of Database Incarnations
DB KeyInc Key DB NameDB ID STATUSReset SCNReset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCL2 1077418382 PARENT2103854 13-FEB-22
2 2 ORCL2 1077418382 PARENT2188190 13-FEB-22
3 3 ORCL2 1077418382 CURRENT 2189976 13-FEB-22
RMAN>
页:
[1]