深入理解数据库创建-补遗

上周在客户那里创建数据库，使用模板方式，数据库版本是Oracle10g，看了一下alert文件，发现了几条以前没注意的变化，记录一下。
1.种子数据库备份集是压缩的
从Oracle10g开始，Oracle支持备份集压缩特性，所以种子数据库当然被压缩了。

Fri Mar 07 16:56:24 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
The input backup piece F:\\ORACLE\\PRODUCT\\10.2.0\\DB\\ASSISTANTS\\DBCA\\TEMPLATES\\SEED_DATABASE.DFB is in compressed format.

2.明确的检查点及恢复用时标识
在恢复日志中，恢复时间和数据文件检查点被明确显示出来：

Full restore complete of datafile 4 to datafile copy H:\\ORADATA\\HDSL\\DATAFILE\\O1_MF_USERS_3X20SSK2_.DBF. Elapsed time: 0:00:01
checkpoint is 534906
Full restore complete of datafile 2 to datafile copy H:\\ORADATA\\HDSL\\DATAFILE\\O1_MF_UNDOTBS1_3X20SSJM_.DBF. Elapsed time: 0:00:02
checkpoint is 534906
Fri Mar 07 16:56:47 2008
Full restore complete of datafile 3 to datafile copy H:\\ORADATA\\HDSL\\DATAFILE\\O1_MF_SYSAUX_3X20SSDP_.DBF. Elapsed time: 0:00:22
checkpoint is 534906
Fri Mar 07 16:57:12 2008
Full restore complete of datafile 1 to datafile copy H:\\ORADATA\\HDSL\\DATAFILE\\O1_MF_SYSTEM_3X20SSCQ_.DBF. Elapsed time: 0:00:47
checkpoint is 534906
Fri Mar 07 16:57:12 2008
Shutting down instance (abort)

-The End-