Oracle
文章平均质量分 86
KevinSmile
这个作者很懒,什么都没留下…
展开
-
Oracle笔记7(Fundamentals II)
Logminer 1、Backup database 2、Modify spfile SQL> alter system set utl_file_dir='/u01/kevin' scope =spfile; 3、Restart database 4、原创 2011-09-18 12:35:09 · 337 阅读 · 0 评论 -
Oracle笔记3
五、Using Data Dictionary and Dynamic Performance Views 数据字典的表 dictionary,user_object,all_object,dba_object原创 2011-08-27 14:39:21 · 415 阅读 · 0 评论 -
Oracle笔记4
十一、Managing Tables 1、创建临时表空间 --session级有效 create global temporary table tmp_session on commit preserve row原创 2011-08-27 15:36:23 · 465 阅读 · 0 评论 -
Oracle笔记2
三、Managing an Oracle Instance 1、ORACLE启动 startup pfile=$ORACLE_HOME/dbs/initkevin.ora; 2、ORACLE启动状态:shutdown ---------->原创 2011-08-27 12:22:21 · 405 阅读 · 0 评论 -
Oracle笔记6(Fundamentals II)
十三、RMAN Complete Recovery 1、RMAN RECOVERY RMAN> list backup; RMAN> backup database format '/u01/backup/wb_%U'; 启动 backup 于 1原创 2011-09-18 12:15:10 · 338 阅读 · 0 评论 -
Oracle笔记2(Fundamentals II)
六、Backup and Recovery Overview 1、Categories of Failures (1) Statement failure (2) User process failure (3) User error (4) Netwo原创 2011-09-17 12:56:10 · 420 阅读 · 0 评论 -
Oracle笔记8(Fundamentals II)
十五、RMAN Incomplete Recovery 1、The Procedure (1) Mount the database (2) Allocate multiple channels for parallelization (3) Restore原创 2011-09-18 13:25:10 · 316 阅读 · 0 评论 -
Oracle笔记4(Fundamentals II)
十一、RMAN Backups 1、backup [oracle@localhost ~]$ rman target / nocatalog Recovery Manager: Release 10.2.0.1.0 - Production on Sat A原创 2011-09-17 14:36:26 · 385 阅读 · 0 评论 -
Oracle笔记3(Fundamentals II)
十、User-Managed Backups 1、Making a Whole DB Backup set feedback off heading off verify off trimspool off set pagesize 0 linesize 2原创 2011-09-17 13:31:10 · 377 阅读 · 0 评论 -
Oracle笔记1(Fundamentals II)
五、Usage and Configuration of the Oracle Shared Server 1、Processing a Request 2、The SGA and PGA 3、Configuring Shar原创 2011-09-17 12:38:39 · 271 阅读 · 0 评论 -
Oracle笔记5(Fundamentals II)
十二、User-Managed Complete Recovery 1、缺少联机重做日志文件 SQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE i原创 2011-09-17 15:38:09 · 489 阅读 · 0 评论 -
Oracle体系结构
Oracle笔记: UNIX命令:ipcs sql语句:show sga --查看granule_size select component,granule_size from v$s原创 2011-08-25 23:30:25 · 493 阅读 · 0 评论