ITPub博客

SCN_TO_TIMESTAMP :PurposeSCN_TO_TIMESTAMP takes as an argument a number that evaluates to a systemchange number (SCN), and returns the approximate timestamp associated with thatSCN. The returned value is of TIMESTAMP data type. This function is useful any timeyou want to know the timestamp a...

A physical standby database is an exact, block-for-block copy of a primary database. Aphysical standby is maintained as an exact copy through a process called Redo Apply,in which redo data received from a primary database is continuously applied to aphysical standby database using the database re...

1、关掉服务或本地监听srvctl stop service -d prod -s prod -n node1srvctl stop listener -n node12、查看VIP信息srvctl config vip -n node13、停止VIP资源进程srvctl stop vip -n node1查看是否已停止ifconfig -a4、更改VIP地址srvctl modify nodeapps -n mynode -A 192.168.6.202/255.255.255.0/eth0修改/e...

Crosschecks are useful because they can do the following:■ Update outdated information about backups that disappeared from disk or tape or became corrupted更新备份的过期信息■ Update the repository if you delete archived redo logs or other files with operating system commands如果之...

When the installer finds that the NTP protocol is not active, the Cluster Time Synchronization Service is installed in active mode and synchronizes the time across the nodes. If NTP is found configured, then the Cluster Time Synchronization Service is started in observer mode, and ...

4节点：bjscj1dw2.__db_cache_size=50465865728bjscj1dw3.__db_cache_size=45902462976bjscj1dw4.__db_cache_size=54492397568bjscj1dw1.__db_cache_size=46707769344bjscj1dw2.__java_pool_size=268435456bjscj1dw3.__java_pool_size=268435456bjscj1dw4.__java_pool_size=268435456bjscj1dw1.__java_pool_size=26...

客户端的exp大版本必须与服务器端的大版本保持一致如果客户端版本过低，导入的时候会报 ORA-03120:two-task conversion routine:integer overflow过程如下：C:\Users\CSS115>exp hx_user/hxuser4655@134.12.81.7/sxlthxqf tables=yspz_xmlsjb_0420Export: Release 11.2.0.1.0 - Production on 星期五 4月 ...

外部存储设备中的同一块磁盘，在不同的节点中名称可能是不一样的，如同一块磁盘，在第一个节点中的名称是hdisk5,在第二个节点中的名称可能是hdisk4。虽然ASM实例能够正确识别出这样的硬盘，但这种情况在一定程度上可能对管理员造成困惑。不管怎样，这块硬盘有一个属性在不同节点中是相同的，那就是它的PVID（即每个硬盘在系...

 环境：两个双节点RAC  主库：Hostname=rui1,rui2db_name=proddb_unique_name=primaryinstance_name=prod1,prod2service_names=primary 备库：hostname=zhang1,zhang2db_name=PRODdb_unique_name=standbyinstance_name=std1,std2se...

The Data Recovery Advisor workflow begins when you either suspect or discover afailure. You can discover failures in many ways, including error messages, alerts, tracefiles, and failed data integrity checks. the database can automatically diagnose failures when errors occur.The basic proc...

场景：11.0.3.0-->11.0.4.0基于rman备份的恢复错误代码：ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADECause: The database was mounted for SHARED cluster access.解决方法：Set the CLUSTER_DATABASE initialization parameter to FALSE and restart the server w...

Enabling or Disabling the Standard Audit TrailYou enable the standard audit trail by setting the AUDIT_TRAIL initialization parameter. This setting determines whether to create the audit trail in the database audit trail, write the audit activities to an operating system file, or to di...

错误：通过emctl status dbconsole启动数据库em时起不来，有如下提示：Unable to determine consoleport. /u01/app/product/11.2.0/db_1/oc4j/j2ee/oc4j_dbconsole_orcle11g_orcl/config/*web_site.xml not found. No such file or directory解决方案：使用telnet 验证端口号 OEM端口号默认为1158，验证1158端口号...

In some situations, a business cannot afford to lose data regardless of the circumstances. In other situations, the availability of the database may be more important than any potential data loss in the unlikely event of a multiple failure. Finally, some applications require maximu...

1、  开闪回idle>alter database flashback on; Database altered. idle>select flashback_on fromv$database; FLASHBACK_ON------------------YES开闪回归档idle>create flashback archive fba1tablespace example quota 500m retention 1 year;...

第一步：查看RAC的server pool是基于admin-managed还是基于policy-managed[grid@node2 ~]$ srvctl config database -d prodDatabase unique name: prodDatabase name: prodOracle home: /u01/app/oracle/product/11.2.0/db_1Oracle user: oracleSpfile: +ORADATA/prod/spfileprod.oraDomain: Start options: ...

dbca -silent -createDatabase -templateName /tmp/Data_Warehouse.dbc -gdbname ora11g -sid ora11g -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 40 -emConfiguration LOCAL-templateName  模板路径+文件名-gdbname         全局数据库名-sid       &...

Task 1: Determine if Platforms are Supported and Determine EndiannessThis task is only necessary if you are transporting the tablespace set to a platform different from the source platform.这步骤只是跨平台的时候才是必须If you are transporting the tablespace set to a platform different from t...

The FAILOVER_MODE parameter must be included in the CONNECT_DATA section of a connect descriptor. FAILOVER_MODE can contain the parameters described in Table 13–4.Table 13–4 Additional Parameters of the FAILOVER_MODE Parameter

All patches may not be compatible with one another. For example, if you apply a patch, all the bugs the patch fixes could reappear after you apply another patch. This is called a conflict situation. OPatch detects such situations and raises an error when it detects a conflict.$ OPatch/opatch apply ...