- 博客(12)
- 收藏
- 关注
原创 Oracle笔记8(Fundamentals II)
十五、RMAN Incomplete Recovery1、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)
Logminer1、Backup database2、Modify spfileSQL> alter system set utl_file_dir='/u01/kevin' scope =spfile;3、Restart database4、
2011-09-18 12:35:09 336
原创 Oracle笔记6(Fundamentals II)
十三、RMAN Complete Recovery1、RMAN RECOVERYRMAN> 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 Recovery1、缺少联机重做日志文件SQL> conn / as sysdbaConnected to an idle instance.SQL> startup mountORACLE i
2011-09-17 15:38:09 488
原创 Oracle笔记4(Fundamentals II)
十一、RMAN Backups1、backup[oracle@localhost ~]$ rman target / nocatalogRecovery Manager: Release 10.2.0.1.0 - Production on Sat A
2011-09-17 14:36:26 385
原创 Oracle笔记3(Fundamentals II)
十、User-Managed Backups1、Making a Whole DB Backupset feedback off heading off verify off trimspool offset pagesize 0 linesize 2
2011-09-17 13:31:10 377
原创 Oracle笔记2(Fundamentals II)
六、Backup and Recovery Overview1、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 Server1、Processing a Request2、The SGA and PGA3、Configuring Shar
2011-09-17 12:38:39 271
原创 Oracle笔记4
十一、Managing Tables1、创建临时表空间 --session级有效 create global temporary table tmp_session on commitpreserve 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 Instance1、ORACLE启动 startup pfile=$ORACLE_HOME/dbs/initkevin.ora;2、ORACLE启动状态:shutdown ---------->
2011-08-27 12:22:21 403
原创 Oracle体系结构
Oracle笔记:UNIX命令:ipcssql语句:show sga --查看granule_size select component,granule_size from v$s
2011-08-25 23:30:25 492
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人