u010692693的专栏

您可以将PDB移动到其他CDB或application container。8.1About PDB Relocation在relocation期间，源PDB可以以 read/write 模式打开并且功能齐全。当源PDB通过活动会话打开时，PDB relocation将执行源PDB数据文件的在线块级副本，redo和undo。 当目标PDB由于ALTER PLUGGABLE DATABASE OPEN语句而联机时，Oracle数据库将终止活动会话并关闭源PDB。下图显示了common PDB.

适用于:Oracle Database - Enterprise Edition - 版本 12.1.0.1 到 12.1.0.2 [发行版 12.1]Oracle Database Cloud Schema Service - 版本 N/A 和更高版本Oracle Database Exadata Cloud Machine - 版本 N/A 和更高版本Oracle Cloud Inf...

在删除一个索引之前，建议先将索引设置为不可视(invisible)状态，不可视状态相当于将索引隐藏起来。但是索引上的维护工作还会继续(DML操作的同时维护索引上的数据)。因为可能需要快速启用这个不可视索引。使索引不可视的方法：alter index idx1 invisible;create index ... invisible;使索引可视的方法：alter index i...

12.2.0.1 RAC CRS Cannot Start With Error CRS-5017 CRS-5818 (Doc ID 2521346.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to an...

How to Restore ASM Based OCR when OCR backup is located in ASM diskgroup? (Doc ID 2569847.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this documen...

Flex ASM在12c以前的版本数据库实例使用操作系统认证连接ASM实例，因为ASM CLIENT(DB INSTANCE)和ASM Server总是在同一个主机上，从12c版本开始引入的FLEX ASM架构允许数据库实例可以和ASM运行在不同的主机中，使用FLEX ASM user password文件认证， ASM密码文件存储在ASM DISKGROUP中，同时在创建Flex...

今天遇到的一个案例，一套ORACLE 12.2 FLEX CLUSTER， 在安装了RU(20180417)后节点2的CRS启动正常，但是其它如ASM、DB、GIMR 等资源都未启动， GI alert log并未发现错误，手动使用srvctl启动ASM资源提示:CRS-2549: Resource ‘ora.asm’ cannot be placed on ‘anbob02’ as it ...

Grid Infrastructure (GI) startup fails because crsd fails to start in a flex asm environment (Doc ID 2392762.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle D...

查看安装日志[root@rac1 OraInstall2017-10-31_07-35-31PM]# pwd/tmp/OraInstall2017-10-31_07-35-31PM[root@rac1 OraInstall2017-10-31_07-35-31PM]# lltotal 164-rwxr-x---. 1 grid oinstall 17598 Oct 31 19:35 c

failover 主端故障，备库变为主库主库开启数据库的flashback[oracle@12cr2 admin]$ sqlplus / as sysdbaSQL> select flashback_on from v$database;FLASHBACK_ON------------------NOSQL> alter database flashback on;alt

12c Dataguard Switchover Best Practices using DGMGRL(Dataguard Broker Command Prompt) (文档 ID 1582837.1)DGMGRL>switchover to Fails with ORA-12514 (文档 ID 1582927.1)1. switchover 主—>备使用dgm

1. 实验环境 主端备端主机名12cr2oracleIP地址192.168.16.81192.168.16.130db_unique_namenewcdbnewcdbdg2. 主端的数据库环境

1. 实验环境[oracle@oracle ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Sat Jun 17 10:18:00 2017Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Databa

Complete checklist for Manual Upgrade for Multitenant Architecture Oracle Databases from 12.1.x.x to 12.2..x.x (文档 ID 2173144.1)Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 12c

模拟故障SQL> alter session set container=pdb4;Session altered.SQL> select systimestamp from dual;SYSTIMESTAMP---------------------------------------------------------------------------11-JUN-17 10

1. 备份数据库数据库打开归档模式SQL> archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination /u01/app/oracle/product/12.2.0/db_1/

SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO

当前备库正常状态主库切换归档SQL> alter system switch logfile;备库应用71号归档日志，等待72号归档日志2017-07-01T21:51:28.075316+08:00Archived Log entry 5 added for T-1.S-71 ID 0x22fd0e8 LAD:12017-07-01T21:51:28.075490+08:00

Far Sync跨数据中心远程同步数据，减少网络延迟主库与Far Sync节点redo同步传输，Far Sync节点与standby节点redo异步传输，standby节点是一个级联备库。实验环境 主端备端Far Sync主机名12cr2oraclefarsync

[oracle@12cr2 ~]$ dgmgrl sys/oracle@newcdbDGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue Jul 4 22:41:20 2017Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

1.  静默安装12c软件[root@12cr2 ~]# cd /opt/database/response[root@12cr2 response]# lsdbca.rsp db_install.rsp netca.rsp[root@12cr2 response]# cp db_install.rsp db_install2.rsp[root@12cr2 response]#

1. 创建第一个PDB：Creatinga PDB by Using the Seed[oracle@12cr2 ~]$ export ORACLE_SID=zylong[oracle@12cr2 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Tue May 16 20:04:22 2017Copyri

1. 查看当前数据的状态和信息SQL> select name,decode(cdb, 'YES', 'Multitenant Option enabled', 'Regular 12c Database: ') "Multitenant Option" , open_mode, con_id from v$database;NAME Multitenant Option

1. 创建newcdb的参数文件[oracle@12cr2 ~]$ cd $ORACLE_HOME/dbs[oracle@12cr2 dbs]$ cat initnewcdb.ora db_create_file_dest='/u01/app/oracle/oradata/newcdb'sga_target=800Mdb_name=newcdbenable_pluggable_d

1. 使用DBCA静默安装生成脚本[oracle@12cr2 ~]$ dbca -silent -templateName $ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc -gdbname testdb1 -sid testdb1 -characterSet ZHS16GBK -sysPassword oracle -s

[oracle@12cr2 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Sat May 27 22:35:43 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Ente

[oracle@12cr2 admin]$ sqlplus c##cdbadmin/oracle@CLON_PDBSQL*Plus: Release 12.2.0.1.0 Production on Sun May 28 05:53:24 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Last Successful lo

1. 创建测试PDBSQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED RE

[oracle@12cr2 dbs]$ export ORACLE_SID=newcdb[oracle@12cr2 dbs]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Sun Jun 4 15:26:43 2017Copyright (c) 1982, 2016, Oracle. All rights re

orcl是NON-CDB[oracle@12cr2 dbs]$ export ORACLE_SID=orcl[oracle@12cr2 dbs]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Sun Jun 4 18:08:15 2017Copyright (c) 1982, 2016, Oracle.

备库切换为SnapshotStandby备机的状态SQL> select DB_UNIQUE_NAME,NAME,database_role,open_mode from v$database;DB_UNIQUE_NAME NAME DATABASE_ROLE OPEN_MODE---------------------------