My dream

随笔分类 -  oracle

Top 10 Backup and Recovery best practices
摘要：Subject: Top 10 Backup and Recovery best practices.Doc ID: Note:388422.1 Type: FAQ Last Revision Date: 05-DEC-2007 Status: PUBLISHEDIn this Document PurposeTop 10 Backup and Recovery best practices. Q... 阅读全文

posted @ 2010-07-12 01:30 robin hu 阅读(224) 评论(0) 推荐(0)

Manual apply archive log
摘要：Suppose online backup a database on tim1, then continue to backup the archive log on time 2, time 3, ……time n (last archive log backup)When database crash want to recover the database ba... 阅读全文

posted @ 2010-07-12 01:21 robin hu 阅读(202) 评论(0) 推荐(0)

Useful object name
摘要：1. dba_objects2. all_tab_colsto be continue……… 阅读全文

posted @ 2010-07-10 11:37 robin hu 阅读(100) 评论(0) 推荐(0)

Enable auto archivelog mode
摘要：1. For oracle 9i:SYS@test > alter system set log_archive_start=true scope=spfile; System altered.SYS@test > shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. S... 阅读全文

posted @ 2010-07-09 23:15 robin hu 阅读(308) 评论(0) 推荐(0)