2013年09月_ZhongWeicheng

12月 11月 10月 09月 08月 07月 05月 04月 03月 02月 01月

原创 Oracle Database 12c Using duplicate standby database from active database Created Active DataGuard

primary databasedb_name=zwc, db_unique_name=zwcstandby databasedb_name=zwc, db_unique_name=standbyon primary database[oracle@vmdb12c ~]$ sqlplus sys/oracle@zwc as sysdbaSQL*Plu

2013-09-26 18:59:56 2396

原创 Oracle 12C Auto Start PDB Pluggable Database

sqlplus / as sysdbaCREATE TRIGGER open_all_pdbs AFTER STARTUP ON DATABASEBEGIN EXECUTE IMMEDIATE 'alter pluggable database all open';END open_all_pdbs;/

2013-09-26 14:17:26 1423

原创 Using RMAN duplicate Created Remote Auxiliary Database with ASM to ASM

2013-09-26 13:49:45 1297

原创 Using RMAN duplicate Created Remote Auxiliary Database

目标数据库SID=backupdb辅助数据库SID=backupdb准备工作包括：目标数据库的全备；在辅助数据库端安装oracle10gR2软件，创建相应的目录、口令文件、pfile，拷贝备份集到辅助数据库备份全库和当前的controlfileRMAN> run {2> allocate channel c1 device type disk;3> backup a

2013-09-25 20:30:20 1011

原创 Using DataPump Extract Schema DDL Scripts

2013-09-25 18:08:55 1395

原创 Oracle get DBA and RDBA

2013-09-25 17:26:10 1388

原创 Modify Oracle 11gR2 RAC PublicIP, VIP, SCANIP

[root@vzwc1 ~]# cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost.localdomain localhost#publi

2013-09-21 21:45:00 90

转载 11.2.0.4 Patch Set - List of Bug Fixes by Problem Type (Doc ID 1562142.1)

Bugs fixed in the 11.2.0.4 Patch SetSee Note:880782.1 for Support Status and Alerts affecting 11.2.0 releases.This note lists customer bugs fixed in the 11.2.0.4 Patch Set which are not alread

2013-09-20 23:30:33 67626

原创 Oracle 11gR2 RAC Votedisk and OCR Diskgroup Recovery

check votedisk and OCR [root@vzwc1 ~]# ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120

2013-09-20 22:27:42 4378

原创 Oracle 11gR2 RAC Votedisk and OCR Management

View the current Votedisk[grid@vzwc1 ~]$ crsctl query crs activeversionOracle Clusterware active version on the cluster is [11.2.0.4.0][grid@vzwc1 ~]$ [grid@vzwc1 ~]$ crsctl query css votedisk

2013-09-20 21:24:43 1882

原创 Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database

Source 2-Nodes Oracle 11.2.0.4.0 RACTarget Single Instance Oracle 11.2.0.4.0Source[oracle@vzwc1 oracle]$ mkdir /u01/app/oracle/bak[oracle@vzwc1 oracle]$ rman target /Recovery Manage

2013-09-20 13:51:39 3273

原创 Greenplum Database Installation Segment on RHEL 5

[gpadmin@gp01 gpdata]$ cat /gpdata/greenplum-db/cfg/scp_key gp01gp02gp03[gpadmin@gp01 gpdata]$ tar -jcvf greenplum-db-4.2.3.1.tar.bz2 greenplum-db-4.2.3.1[gpadmin@gp01 gpdata]$ gpscp -f /gpdata/g

2013-09-17 15:53:44 1809

原创 Greenplum Database Installation Master on RHEL 5

set /etc/sysctl.confkernel.shmmax = 500000000kernel.shmmni = 4096kernel.shmall = 4000000000kernel.sem = 250 512000 100 2048kernel.sysrq = 1kernel.core_uses_pid = 1kernel.msgmnb = 65536kerne

2013-09-16 20:57:08 1437

原创 Connecting to Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c

Connecting to the root of a container database is the same as that of any previous database instance. On the database server you can use OS Authentication[oracle@vmdb12c ~]$ sqlplus / as sysdbaSQL

2013-09-06 22:19:53 1440

原创 PostgreSQL 9.2.4 命令行帮助及SQL语句简要说明

clusterdb clusterdb 对一个数据库中先前已经建过簇的表进行建簇. 使用方法: clusterdb [选项]... [数据库名] 选项: -a,--all 对所有数据库建簇 -d,--dbname=DBNAME 对数据库 DBNAME 建簇 -e,--echo 显示发

2013-09-05 18:27:33 9267

原创 Oracle GoldenGate for Oracle 11g to PostgreSQL 9.2.4 Configuration

Installing and setting up Oracle GoldenGate connecting to an Oracle databaseAlso please make sure the Oracle database is in archive log mode[oracle@ggos ~]$ sqlplus / as sysdbaSQL*Plus: Releas

2013-09-04 22:50:27 4714 2

原创 Postgres 9.2 Replication Configuration on CentOS 5

Master server configurationEdit postgresql.confAdd variablesarchive_mode = onarchive_command = 'cp "%p" /data/pgsql/data/pg_xlog/archive_status/"%f"'archive_timeout = 500wal_level = 'ho

2013-09-03 22:09:09 1282

原创 PostgreSQL View current log

[postgres@zwc pg_xlog]$ psql -h 192.168.1.13 -p 1521 -U zwc -d testdbPassword for user zwc: psql (9.2.4)Type "help" for help.testdb=> select pg_current_xlog_location(); pg_current_xlog_location

2013-09-02 14:32:30 924

原创 PostgreSQL Use oid2name view the tables in the database

database tablespace[postgres@zwc base]$ ls -ltotal 28drwx------ 2 postgres postgres 12288 Sep 2 10:13 1drwx------ 2 postgres postgres 4096 Aug 28 12:56 12783drwx------ 2 postgres postgres

2013-09-02 13:55:38 1216

原创 Oracle Database 12c Release 1 Installation On Oracle Linux 6.4 x86_64

Create groups and users[root@vmdb12c ~]# groupadd oinstall[root@vmdb12c ~]# groupadd dba[root@vmdb12c ~]# groupadd oper[root@vmdb12c ~]# groupadd backupdba[root@vmdb12c ~]# groupadd dgdba[root@

2013-09-01 15:01:28 2354