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

作者： | 【：转载时请务必以超链接形式标明文章和作者信息及】
链接：

---

 

上周在客户那里创建数据库，使用模板方式，数据库版本是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-

-----