天行健，君子以自强不息

培训已经结束几天了，一直没来得及贴上来大纲，今天继续贴第二天的内容：

Day 2
Charpter4 Recovery from non-critical losses

If critical data lost, the database can’t functional works, or else database can still works.
If loss the temp data files, drop the old one and create a new one.
Log group state current: alter system switch log will switch the log group.
Log group state active: there are data not write to data file, alter system checkpoint will flush it.
If lose redo group member, drop the old one and add a new.
If index lost, re-create a new one. Use parallel and nologging to speed up the creation.
If password file lost, use orapwd command to create a new one. Then restart the instance.
Remote_login_password_file can be set to exclusive/ shared and none

Charpter5 Database Recovery

There are two kinds of recovery: use management way and using RMAN
User management: first restore=> manually copy data file/archived file to destination
Then recover=> recover the database, that’s apply the online /archived log files
You can recover the whole database, specified data file or tablespaces.
RMAN management also finished the same task, it’s automatically: restore and recover.
Situations need incompletely recover: missing archived/online redo or use control file to recover.
Incomplete recover can recover to: until time/until cancel/until SCN/until log sequence
Incomplete recovery has to open the db with resetlogs => then log sequence start from 1
Incomplete recovery can also recover to restore point (SCN/date), need to create before restore.
Create a new control file or use control file auto backup, we can create control file from command: backup control file to trace.
If we create new control file, then need to register the backup set to control file: catalog database.
Recovery from readonly tablespace is some different.
阅读全文 »

Share This

Oracle database 10.2.0.4 patchset的Windows版本和Linux版本发布已经有一段时间了
在最新的Oracle数据库产品中，Windows和Linux平台是基础平台，新版本或者patchset的发布一般首先是这两大平台，然后是三大UNIX平台即AIX，HP-UX和Solaris

现在Oracle Database 10.2.0.4也就是Oracle Database的第三个大的patchset Solaris版本和HP版本已经发布几天了，在metalink上已经提供下载，AIX平台估计很快也提供下载。patch number是6810189 ，大小大概1个G左右，够大的。

请到updates.oracle.com下载（需要Metalink帐号）

….
230-
230- Welcome to the Oracle Patch Download FTP Server
230-
230- For detailed help, use command “quote site help”.
230
ftp> cd 6810189
250 Changed directory OK.
ftp> dir
200 PORT command OK.
150 Opening data connection for file listing.
total 1
-r–r–r– 1 root other 1758061824 Apr 30 20:58 p6810189_10204_HPUX-IA64.zip
-r–r–r– 1 root other 1195551830 Mar 17 05:36 p6810189_10204_Linux-x86-64.zip
-r–r–r– 1 root other 1053748381 Feb 22 18:58 p6810189_10204_Linux-x86.zip
-r–r–r– 1 root other 1276477084 Apr 30 19:25 p6810189_10204_Solaris-64.zip
-r–r–r– 1 root other 1034079272 Mar 18 00:03 p6810189_10204_Win32.zip
226 Listing complete. Data connection has been closed.
ftp: 收到 444 字节，用时 0.00Seconds 444000.00Kbytes/sec.
ftp>

从上面的截图看，Solaris和HPUX-IA都是在4月30号发布的。

2008-05-15 update: 10.2.0.4 Patch Set for AIX also released

Share This

MySQL被Sun收购了，今天早上从Sun的官方网站得到证实，这肯定会成为2008数据库市场的标志性收购事件，收购金额大概一个billion，10亿美金。(对数字太不敏感，犯了两次错误，多谢NinGoo老兄提醒)

现在老牌的几个大厂纷纷挥军进入软件行业，比如HP去年收购了Mercury，Dell据说也要开发自己的软件，现在Sun突然收购MySQL，正式进入数据库市场，这样就好玩多了，以后Sun和Oracle也是竞争对手了。

官方报道：
Sun announced an agreement to acquire MySQL AB, an open source icon and developer of one of the world’s fastest growing open source databases. This acquisition accelerates Sun’s position in enterprise IT to now include the $15 billion database market and reaffirms Sun’s position as the leading provider of platforms for the Web economy and its role as the largest commercial open source contributor.

恐怕过两天还有更猛的消息出来吧，期待。。。

不用过两天了，更猛的消息已经出来了：
Oracle最终终于收购bea了，成交价是每股$19.375，总价85亿美金，比较早前的每股$17稍高一些
就在同一天，Oracle收购了另外一家公司：Captovation

看来，Oracle的收购又进入高发期了。

Share This