rman总结(包含10g rman中的新特性)
正在不断更新中......[@more@]1>10grman在backup的时候将当前没有用的到block跳过,不备份.而在以前的版本中rman只是跳过never been allocated blocks.2>The CONFIGURE DEVICE TYPE ... PARALLELISM command specifies the number ofautomatic channels to allocate for a specified device type. For example, if you configure parallelism to 3 for a device type, then RMAN allocates three channels for the device type when using automatic channels.3>并行通道的个数应该和物理设备的match,也就是说如果只有一个磁带设备
在单机linux上安装两个不同版本数据库时注意事项
在linux上安装两个不同版本的oracle时,在安装第二个版本时要将/etc/oraInst.loc文件中的inventory_loc改成正确的路径,以免在安装时oracle自动往原来的安装路径下写东西而造成对文件或者路径没有写权限的错误。[@more@]
v$parameter
v$parameter中的ISSES_MODIFIABLE记录哪些参数可以在session级别动态修改,ISSYS_MODIFIABLE记录哪些参数可以在instance级别动态修改。[@more@]
前两天遇到了一个错误 ora-27121 unable to determine size of shared memory segment
OS: Solaris db version: 9.2[@more@]问题描述: db 没有shudown 就关闭了OS再启动db就报ora-27121.metalink上的建议是用ipcs查看ORPHANED SHARED MEMORY SEGMENTS AND SEMAPHORES然后用ipcrm Remove orphaned shared memory segments and semaphores.用ipcs -a查看发现并没有oracle占用的orphaned shared memory segments and semaphores,到是root用户占用了.用ipcs -a 找到root占用的ID,然后用ipcrm -m <ID> - for shared memory ipcrm -s <ID> - for semaphores 释放后再启动db,一切正常.
Full of fight --- Stephen Jackson
If you're a friend of Pacers' Jackson, he's got your backIn the concrete world of Port Arthur, Texas, where Stephen Jackson grew up, family and friends stuck together. Thick or thin, right or wrong, bonds were absolute, and when conflict arose, the plan was simple and direct: Act now and deal with the consequences later.There was the time, for example, when he and a high school teammate, Isaac Washington, walked five miles across town to an unfamiliar park to play basketball. When their claim fo
install oracle92 on redhat as4 x86-64
Install racle92 no redhat as4 x86-64Pre-installation Tasks 安装之前要确定一下的RPM包已经打上,其实包的版本略有不同感觉问题不大,起码在安装的并没有报错.但要注意这些包的后缀应该为x86-64,不能是i386.还要注意的是这些包可能相互有依赖性,也会依赖于其他包,请一一下载安装.可以在 http://rpm.pbone.net/ 搜索下载所需RPM包安装前先用rpm –qa来检查一下安装情况,如果未曾安装则用rpm –ihv安装.Download and Install Required Packages The following packages (or later versions) must be installed: compat-db-4.1.25-9compat-g