ITPub博客

When you drop a table, the database does not immediately remove the spaceassociated with the table. The database renames the table and places it and anyassociated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time. This feature is call...

restore headeronly from disk='D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\scott.bak'

通过内容进行过滤grep 关键字 文件名如下：[root@source ~]# cat anaconda-ks.cfg # Kickstart file automatically generated by anaconda.#version=DEVELinstallcdromlang en_US.UTF-8keyboard usnetwork --onboot no --device eth0 --bootproto dhcp --noipv6rootpw  --iscrypted $6$JvEQdLOWp...

CREATE VIEW v_user_viewas(SELECT uu_uugr_ug_uo_ugrr_ur.id,uu_uugr_ug_uo_ugrr_ur.groupid,uu_uugr_ug_uo_ugrr_ur.groupname,uu_uugr_ug_uo_ugrr_ur.identifier,uu_uugr_ug_uo_ugrr_ur.username,uu_uugr_ug_uo_ugrr_ur.account,uu_uugr_ug_uo_ugrr_ur.password,uu_uugr_ug_uo_ugrr_ur.position,uu_uugr_ug_uo...

查看虚拟机编辑器中Nat模式下的网关，如下图所示将虚拟机的网关全部设置为192.168.206.2即可

启动MYSQL[root@zhangruiu1 ~]# mysqld_safe &[1] 39558[root@zhangruiu1 ~]# 160520 20:40:35 mysqld_safe Logging to '/var/log/mysqld.log'.160520 20:40:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql[root@zhangruiu1 ~]# ps -ef | grep mysqlroot      43541 &nbs...

由于数据库异常down机造成undo数据文件损坏导致无法开库在将该undo数据文件剔除起库后重新创建undo文件后报下列错误：SQL> CREATE UNDO TABLESPACE undotbs_02 DATAFILE '/u01/app/oracle/oradata/PROD/undo01.dbf' SIZE 200m  REUSE AUTOEXTEND ON;CREATE UNDO TABLESPACE undotbs_02 DATAFILE '/u01/app/orac...

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...

错误如下：[oracle@node1 ~]$ emca -config dbcontrol db -repos create -clusterSTARTED EMCA at Apr 11, 2016 6:09:57 PMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle.  All rights reserved.Enter the following information:Database unique name: prod...

环境Linux 6.4Oracle Rac 11.2.0.4[root@web1 grid]# /u01/app/11.2.0/grid/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:    ORACLE_OWNER= grid    ORACLE_HOME=  /u01/app/11.2.0/grid...

在用户环境变量参数文件中需要加入以下参数信息umask 022含义为假如新建文件默认您访问权限是666,目录权限是777.在创建文件或目录时,系统把默认权限的值域umask的值相减,得到新建文件的访问权限(文件644,目录755).

   配置/etc/hosts时必须使用小写，如使用大写则会报此错误

##注册方法###注册方法:    在 注册时选择 License server ，填 http://idea.lanyus.com ，然后点击 OK

如果查看lun信息[root@BJLT2J1HDDB01 ~]# upadminUltraPath CLI #0 >UltraPath CLI #0 >show vlun------------------------------------------------------------------------------------------------------------------------------------------------- Vlun ID  Disk         &n...

A用户的过程如下：create or replace procedure ssasv_ename varchar(30);begin select ut.ename into v_ename from emp ut where rownum=1; dbms_output.put_line(v_ename);end;在A用户下执行此过程SQL> set serveroutput on SQL> exec ss;SMITHPL/SQL procedure successfully compl...