robin hu - 博客园

delete dbcontrol service in windows

摘要： D:\>emca -deconfig dbcontrol db EMCA 开始于 2010-9-16 19:58:00 EM Configuration Assistant 10.2.0.1.0 正式版版权所有 (c) 2003, 2005, Oracle。保留所有权利。输入以下信息: 数据库 SID: 10g2t 是否继续? [yes(Y)/no(N)]: y 2010-9-16 19... 阅读全文

posted @ 2010-09-16 20:06 robin hu 阅读(386) 评论(0) 推荐(0)

OPW-00001: Unable to open password-file (10gR2)

摘要： C:\Documents and Settings\robin>orapwd file='D:\oracle\product\10.2.0\db_1\datab ase\PWDocmdb.ora' password=h123456 entries=5; OPW-00001: Unable to open password-file Reason: needn’t single quotes... 阅读全文

posted @ 2010-09-16 19:56 robin hu 阅读(1000) 评论(0) 推荐(0)

Manual Create database (10gr2)

摘要： C:\Documents and Settings\robin>oradim -NEW -SID ocmdb pfile used to create the database: ocmdb.__db_cache_size=205520896 ocmdb.__java_pool_size=4194304 ocmdb.__large_pool_size=4194304 ocmdb.__shar... 阅读全文

posted @ 2010-09-16 18:23 robin hu 阅读(335) 评论(0) 推荐(0)

Drop database

摘要： C:\Documents and Settings\robin>set oracle_sid=10g2t C:\Documents and Settings\robin>sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 16 10:07:57 2010 Copyrig... 阅读全文

posted @ 2010-09-16 10:18 robin hu 阅读(456) 评论(0) 推荐(0)

RMAN—work through.

摘要： 1. Use DBCA to create a database as target database suppose its name is 10g2T. 2. Use DBCA to create a database as catalog database suppose its name is 10g2. 3. Login 10g2 and create user and catalo... 阅读全文

posted @ 2010-09-10 22:22 robin hu 阅读(251) 评论(0) 推荐(0)

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)

A good tool to uninstall malware

摘要： http://www.revouninstaller.com/ 阅读全文

posted @ 2010-07-09 22:33 robin hu 阅读(94) 评论(0) 推荐(0)

My dream

公告