ITPub博客

查看Oracle Database 10g 的数据库支持的操作系统[@more@]column platform_name format a30select * from v$transportable_platform;TTS可以在多个不同平台间传输表空间,TTS要求源数据库和目标数据库具有相同的操作系统;endian_format 格式转换要注意

除了实例和线程参数外,还有一些在RAC环境中有特殊意义的参数:Cluster_DatabaseCluster_InterconnectsActive_Instance_CountMax_Commit_Propagation_Delay[@more@]= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = cluster_database 决定着控制文件是否要在共享模式下安装,大多数情况下必须将此值设置为true;升级打补丁时所有实例必须关闭,且只有该实例被打开并将cluster_database设置为false;升级脚本通常在startup migrate 命令之后运行;另外情况是数据库要设置成归档日志模式或闪回模式时必须将所有实例关闭后将cl

使用RMAN常用命令的演示[@more@]RMAN> show all; RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultRMAN> report schema;Report of database schemaFile K-bytes Tablespace RB segs Datafile Name---- ---------- -------------------- ------- -------------------1 256000 SYSTEM YES /opt/oracle/localdata/system01.dbf2 204800 UNDOTBS1 YES /opt/oracle/localdata/undotbs01.dbf3 25600 INDX NO /opt/oracle/localdata/indx01.dbf4 10

　　使用RMAN进行备份和恢复常用命令　　[@more@]############################################################　　连接到目标数据库(不用恢复目录数据库) 　　rman target / nocatalogrman target rman/rman123 rcvcat rman/rman@catalogdb　　rman cmdfile=/sh/orcl.rcv　　显示rman配置　　RMAN> show all;　　　　　############################################################　　报告目标数据库的物理结构　　RMAN> report schema;　　报告陈旧备份　　RMAN> report obsolete;　　报告不可恢复的数据文件　　RMAN>

对ORACLE的SGA 进行检查,有以下脚本来实现 [@more@]SQL> compute sum of bytes on poolSQL> break on pool skip 1SQL> select pool ,name ,round(bytes/1024,2)bytes from v$sgastat order by pool ,name;POOL NAME BYTES----------- -------------------------- ----------large pool free memory 16777216*********** ----------sum 16777216shared pool 1M buffer 2098176Checkpoint queue 1026560FileOpenBlock 3796104KGK heap 7000KGLS heap 3702624KQR L PO 1902568KQR L SO 143368POOL NAME BYTES----------- ----------

startup 数据库时报出ORA-01157、ORA-01110的错误及处理过程[@more@]SQL> startupORACLE instance started.Total System Global Area 268435456 bytesFixed Size 1218920 bytesVariable Size 113247896 bytesDatabase Buffers 146800640 bytesRedo Buffers 7168000 bytesDatabase mounted.ORA-01157: cannot identify/lock data file 7 - see DBWR trace fileORA-01110: data file 7: '/opt/oracle/emcdata/recovery_oa/oadata03.dbf'01157, 00000, "cannot identify/lock data file %s - see DBWR trace file"// *Cause: Th

#sqlplus /nologSQL>startup nomount;ORA-32700: error occurred in DIAG Group Service重建控制文件时报出:ORA-00221: error on write to controlfileORA-00206: error in writing (block 1, # blocks 1) of controlfileORA-00202: ontrolfile: /***/localdata/control01.ctl'ORA-27041: unable to open file ORA-01503: CREATE CONTROLFILE failedORA-01163: SIZE clause indicates 40960 (blocks), ORA-01517: log member: /***/localdata/redo03.log[@more@]#sqlplus /nologSQL>startup nomount;ORA-32700: error occurred in D

A)ORA-01031: insufficient privilegesB)客户端用PL/SQL sys/pwd@*** as sysdba登录时出现同样的报错C)服务器端remote_login_passwordfile设置D)ORAPWD重新设置密码[@more@]################Errors###################C:>sqlplus /@oa2 as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期五 3月 14 10:58:32 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-01031: insufficient privileges客户端用PL/SQL sys/pwd@*** as sysdba登录时出现同样的报错################客户端配置################客户端

Each running Oracle database is associated with an Oracle instance. When a database is started on a database server, the Oracle software allocates a shared memory area called the System Global Area (SGA) and starts several Oracle background processes. This combination of the SGA and the Oracle processes is called an Oracle instance.[@more@]

9i下创建视图权限不足！用户已经具有create any view 权限@mystats.sql from v$statname a, v$mystat b * ERROR at line 4: ORA-01031 privileges [@more@]解决最佳方式:grant select on v_$mystat to scott;