-
编辑 删除
RMAN Configure Clause
RMAN Configure ClauseChange persistent RMAN configuration settings.Syntax: CONFIGURE deviceConf; CONFIGURE backupConf; CONFIGURE AUXNAME FOR DATAFILE datafileSpec...
-
编辑 删除
RMAN Change Clause
RMAN Change ClauseUpdate the status of a backup or copy in the RMAN repository.Syntax: CHANGE {BACKUP | COPY} [OF listObjList] [ maintQualifier [maintQualifier]...] { AVAILABLE...
-
编辑 删除
RMAN Backup Clause
RMAN Backup ClauseBack up database files, archive logs, backups, or copies.Syntax: BACKUP FULL Options BACKUP FULL AS (COPY | BACKUPSET) Options B...
-
编辑 删除
RMAN Crosscheck Clause
RMAN Crosscheck ClauseCheck whether backup pieces, proxy copies, or disk copies still exist in comparison to the control file's repository.Syntax: CROSSCHECK { { BACKUP [OF listObjL...
-
编辑 删除
impdp语法
$ impdp -helpImport: Release 11.1.0.6.0 - 64bit Production on Thursday, 28 April, 2011 14:20:21Copyright (c) 2003, 2007, Oracle. All rights reserved.The Data Pump Import utility provides a me...
-
编辑 删除
expdp语法
$ expdp -helpExport: Release 11.1.0.6.0 - 64bit Production on Thursday, 28 April, 2011 14:20:10Copyright (c) 2003, 2007, Oracle. All rights reserved.The Data Pump export utility provides a me...
-
编辑 删除
crosscheck archivelog all用途
当手动删除归档日志文件后，Rman备份会检测到日志缺失，从而无法进一步继续执行。所以此时需要手工执行crosscheck过程，之后Rman备份可以恢复正常。RMAN> crosscheck archivelog all;...
-
编辑 删除
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
oracle11g rac在重新创建控制文件后，以open resetlogs打开库时报了此错ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled错误原因是在rac节点1上生成的创建控制文件的脚本造成的。...
-
编辑 删除
recover database using backup controlfile与recover database的差别
要理解recover database using backup controlfile，先理解 recover databasegN {0Fvzh0也就是说，不加using backup controlfile的情况。[$WT!R/Y0在普通的recover database 或者 recover tablespace, recover datafi...
-
编辑 删除
ORA-00059错误解决
今天在执行ALTER TABLESPACE ** ADD DATAFILE ** 命令时出现了ORA-00059: 超出 DB_FILES 的最大值的错误信息，之前已经成功添加了几个datafile数据文件。 解决...
-
编辑 删除
什么是Oracle RAC
什么是Oracle RAC？文章分类:数据库 Source：http://hi.baidu.com/movieyouth/blog/item/9478800140d788d2277fb5a1.html RAC就是real application clusters的缩写，跟rack的读音同。Oracle Real Applica...
-
编辑 删除
exp语法
[oracle@standby ~]$ exp -helpExport: Release 10.2.0.4.0 - Production on Wed Mar 2 19:07:53 2011Copyright (c) 1982, 2007, Oracle. All rights reserved. You can let Export prompt you for p...
-
编辑 删除
imp语法
[oracle@standby ~]$ imp -helpImport: Release 10.2.0.4.0 - Production on Wed Mar 2 19:08:16 2011Copyright (c) 1982, 2007, Oracle. All rights reserved. You can let Import prompt you for p...
-
编辑 删除
oracle em预警
预警 : ATTENTION - Enterprise Manager Database Control 10.2.0.4 Or 10.2.0.5 - Patch Required from 31-Dec-2010 ATTENTION - Enterprise Manager Database Control 10.2.0.4 Or 10.2.0.5 - ...
-
编辑 删除
oracle查看表空间使用情况
SELECT tablespace_name,sum_m as total_m, ( sum_m- free_m) as used_m,free_m,to_char(100*(sum_m-free_m)/sum_m, '99.99') || '%' AS pct_used,to_char(100*free_m/sum_m, '99.99') || '%' AS pct_free FROM ( SE...
-
编辑 删除
Oracle11g R2 ORA-32004故障解决
（3）查看参数文件内容 [oracle@oracle dbs]$ cat inittest.ora &n...
-
编辑 删除
Oracle11g R2 ORA-32004故障解决
oracle11g R2手动在裸设备（RAW）上建库后，数据库可正常使用，当每次启动数据库时总报ORA-32004错误，如下： SQL>startup &...
