- 博客(12)
- 收藏
- 关注
原创 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 315
原创 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 336
原创 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 337
原创 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 488
原创 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
原创 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
原创 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 419
原创 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
原创 Oracle笔记4
十一、Managing Tables 1、创建临时表空间 --session级有效 create global temporary table tmp_session on commit preserve row
2011-08-27 15:36:23 465
原创 Oracle笔记3
五、Using Data Dictionary and Dynamic Performance Views 数据字典的表 dictionary,user_object,all_object,dba_object
2011-08-27 14:39:21 414
原创 Oracle笔记2
三、Managing an Oracle Instance 1、ORACLE启动 startup pfile=$ORACLE_HOME/dbs/initkevin.ora; 2、ORACLE启动状态:shutdown ---------->
2011-08-27 12:22:21 402
原创 Oracle体系结构
Oracle笔记: UNIX命令:ipcs sql语句:show sga --查看granule_size select component,granule_size from v$s
2011-08-25 23:30:25 492
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人