玉面飞龙 oracle,Oracle10gR2中一些新特性

Oracle10gR2中一些新特性

Oracle再次首发了Linux版本的10g Release2，昨天在文档站点上通览了一下new features，摘选其中一些个人觉得还比较有兴趣的东西。

1。Optimized Asynchronous Redo Transmission。希望这个改动可以提高在低速网络时DG的性能

Asynchronous redo transmission using the log writer process is no longer limited by the size of the network buffer. The log writer process is no longer blocked on network time outs during asynchronous redo transmission. This allows a greater number of archiver processes to archive redo logs remotely.

2。Database Transport Across Same Endian Platforms。提供了一个简单的RMAN命令用来在不同平台间迁移整个数据库

RMAN CONVERT DATABASE

3。Easy Conversion of a Physical Standby Database to a Reporting Database。呵呵，这个功能不知道会不会有人用，不过看上去还是不错的

Activate then Flashback

4。Unused Block Compression。我们的知识又一次被颠覆，记住，10gR2的RMAN备份是真的不备份那些没有用到的block了，不管是不是以前曾经用过

By optimizing database backups, only blocks currently used by the database are backed up. In previous releases, NULL compression was utilized, whereby only never-used blocks were excluded from backup. With this new feature, all unused blocks, whether they have been used or not in the past, will be excluded from backup.

This enables faster backups and smaller backup files

5。Eliminate Control File Re-Creation。简单化的一个操作，其实早就该加进来了

With the control file enhancements, there is no longer a requirement to re-create the control file when changes in the configuration parameters are made. These include the MAXLOGFILE, MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES parameters.

6。Enhanced Server Side Shutdown。文档里越来越多的使用startup force，是不是说明shutdown abort倒是推荐的关闭数据库方法了，因为快啊，呵呵

When using the SHUTDOWN ABORT command with Oracle Database 10g Release 2 and higher clients, all processes (including, for Unix, the foreground process) will be terminated.

7。Temporary Datafiles Are Re-Created on RMAN Recovery。人性化的修改，简化了我们恢复数据库的操作步骤

Temporary datafiles that belong to locally managed temporary tablespaces are automatically re-created during recovery operation.

This eliminates the need to manually create temporary tablespaces after recovery.

8。Self-Tuning Multiblock Read Count。DBA们，我们又少了一项可以用来炫耀的技巧了

9。ASM Command-Line Interface。总算有了自己的shell，包含了cd，ls，mkdir等一系列常用的命令，现在不会感到asm是一个完全封闭的黑盒子了

10。Drop Empty Datafile。这次好了，不会因为那些被别人误加的看上去很傻的数据文件而头疼了，以前只能是缩小到5M什么的，仍然看上去很烦人，现在世界可以清净了

This feature provides the ability to drop an empty datafile. It drops the datafile from the database and deletes it from the file system.

If a DBA adds a datafile in the wrong location or to the wrong tablespace, this feature provides a simple way to correct the error by dropping the datafile.

By eygle on 2005-08-03 16:02 |

Comments (8) |

OraNews | 363 |

8 Comments

RMAN CONVERT DATABASE

这个是很强的，我喜欢。

我倒是对这个没什么需求，都是小库，唉，直接exp，imp完了就。

倒是对ASM新增的那个shell觉得挺好玩的

俺说了那么久风花雪月的

好歹也得说点专业知识不是？

桔子，当俺们不存在好啦

ASM新增的shell，看Oracle的用意是为了消除SA的抱怨，其实没有带来任何新的东西。

属于易用性的改进。

等啥时候Solaris的出来，把我的库升个级。

这个drop empty datafile真是不错啊