2008年7月3日
摘要: Define the purpose of tablespaces and data files #数据库中的block是操作系统的2的n 次幂倍,如0, 2, 4, 8 .... #database 中的一个table 至少要有一个segment. # SYSTEM tablespce created with database , contains the data dictionary, c... 阅读全文
posted @ 2008-07-03 17:09 Alex.Zhang 阅读(308) 评论(0) 推荐(0) 编辑
摘要: Explain the purpose of online redo log files Record all changes made to data Provide a recovery mechanism at least two groups required online redo log file group : identical copies of online redo lo... 阅读全文
posted @ 2008-07-03 13:36 Alex.Zhang 阅读(318) 评论(0) 推荐(0) 编辑
摘要: uses of the control file a. binary file b. define current state of physical database d. 只要data file 和redo log file 不丢,control file 还是有可能恢复的 ---------------------------------- cd dbs ls -al strings spf... 阅读全文
posted @ 2008-07-03 12:34 Alex.Zhang 阅读(251) 评论(0) 推荐(0) 编辑