Oracle 12c特性解读-容器数据库和灾备-05 PDB迁移和克隆

本地克隆创建PDB

创建一个新的PDB from SEED

alter session set container=PDB$SEED;
select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl1/pdbseed/system01.dbf
/u01/app/oracle/oradata/orcl1/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/orcl1/pdbseed/undotbs01.dbf

conn / as sysdba
create pluggable database pdb2
  admin user pdb_mgr identified by oracle
  file_name_convert=('/u01/app/oracle/oradata/orcl1/pdbseed','/u01/app/oracle/oradata/orcl1/pdb2');

alter pluggable database pdb2 open;
show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO

在DELL R730物理机上安装配置Oracle Linux 7.3图解

Oracle Linux 7.3(Oracle Linux 7 Update 3)在2016.11.10发布。Oracle Linux全称为Oracle Enterprise Linux,是由Oracle公司提供支持的企业级Linux发行。这是第一个包含UEK版本 4(UEK R4)的 Oracle Linux 7 ISO,新安装的 Oracle Linux 7 Update 3 将默认安装和引导 UEK R4 内核。
显著更新:
UEFI 安全引导支持 - 此更新允许您在已启用 UEFI 安全引导的系统上安装和使用 Oracle Linux 7,这在 Oracle Linux 7 Update 3 上完全支持。

使用Dell iDRAC服务器远程控制安装操作系统简要图解

iDRAC又称为Integrated Dell Remote Access Controller,也就是集成戴尔远程控制卡,这是戴尔服务器的独有功能,iDRAC卡相当于是附加在服务器上的一计算机,可以实现一对一的服务器远程管理与监控,通过与服务器主板上的管理芯片BMC进行通信,监控与管理服务器的硬件状态信息。它拥有自己的系统和IP地址,与服务器上的OS无关。是管理员进行远程访问和管理的利器,戴尔服务器集成了iDRAC控制卡,我们就可以扔掉价格昂贵的KVM设备了。

Oracle 12c特性解读-容器数据库和灾备-03 创建与管理CDB和PDB

手工创建cdb数据库(create database语句)

创建前的准备工作

# 创建密码文件
orapwd file=$ORACLE_HOME/dbs/orapworcl1 password=oracle force=y format=12

# 创建参数文件
vi spfileorcl1.ora
#---------------------------------------------------
db_name=orcl1
sga_target=2048M
db_create_file_dest='/u01/app/oracle/oradata/orcl1'
enable_pluggable_database=true
#---------------------------------------------------

# 创建所需目录
mkdir -p /u01/app/oracle/oradata/orcl1

Hugepage计算脚本

REQUIREMENTS

  1. Oracle Database instance(s) are up and running
  2. Oracle Database 11g Automatic Memory Management (AMM) is not setup (See Note 749851.1)
  3. The shared memory segments can be listed by command “ipcs -m”
  4. Oracle Linux
  5. Package ‘bc’ installed

MySQL-DBA从小白到大神实战-15 MySQL源码初探

通过gdb工具分析mysqld进程启动的过程

gdb --args /u01/mysql/bin/mysqld
#--------------------------------------------------------------------------------
GNU gdb (GDB) Red Hat Enterprise Linux (7.2-90.el6)
Copyright (C) 2010 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /u01/mysql/bin/mysqld...done.
(gdb) b mysqld_main   # 设置断点
Breakpoint 1 at 0x58c0e4: file /u01/mysql-5.6.35/sql/mysqld.cc, line 5245.
(gdb) r   # 运行
Starting program: /u01/mysql/bin/mysqld 
[Thread debugging using libthread_db enabled]

Breakpoint 1, mysqld_main (argc=1, argv=0x7fffffffe668) at /u01/mysql-5.6.35/sql/mysqld.cc:5245
5245    {
Missing separate debuginfos, use: debuginfo-install glibc-2.12-1.192.el6.x86_64 keyutils-libs-1.4-5.0.1.el6.x86_64 
krb5-libs-1.10.3-57.el6.x86_64 libcom_err-1.42.8-1.0.2.el6.x86_64 libgcc-4.4.7-17.el6.x86_64 
libselinux-2.0.94-7.el6.x86_64  libstdc++-4.4.7-17.el6.x86_64 nss-softokn-freebl-3.14.3-23.el6_7.x86_64 
openssl-1.0.1e-48.el6.x86_64 zlib-1.2.3-29.el6.x86_64
(gdb) n   # 向下
5250      my_progname= argv[0];
(gdb) n
5254      if (my_init())                 // init my_sys library & pthreads
(gdb) s   # 看源码位置
my_init () at /u01/mysql-5.6.35/mysys/my_init.c:69
69        if (my_init_done)
(gdb) n
74        my_umask= 0660;                       /* Default umask for new files */
(gdb) n
75        my_umask_dir= 0700;                   /* Default umask for new directories */
#--------------------------------------------------------------------------------