Loading...

Follow Lore Data on Feedspot


Valid
or
Continue with Google
Continue with Facebook

Olá pessoal, nesta série de artigos vou escrever sobre o Oracle GoldenGate, para que ele serve, como instalá-lo, como configurá-lo, como efetuar a carga de dados inicial, como iniciar a replicação e outras coisas mais.

O Oracle GoldenGate é um software que permite replicarmos dados em ambientes heterogêneos, por exemplo replicação de dados entre Oracle e SQL Server. É possível utilizá-lo para diversas finalidades como solução de alta disponibilidade, integração de dados em tempo real, captura de dados transacionais, replicação de dados, transformação e validação entre sistemas transacionais e analíticos.

O GoldenGate faz a replicação e a manipulação dos dados no nível transacional entre diferentes plataformas para toda a empresa. Basicamente trabalha com transações efetuadas garantindo integridade e baixo impacto no desempenho do ambiente.

As seguintes topologias são suportadas:

Além das topologias acima apresentadas, o GoldenGate atende também as seguintes necessidades de negócio:

  • Continuidade operacional e alta disponibilidade;
  • Migrações de bancos de dados e carga inicial de dados;
  • Integração de dados;
  • Atualização e construção de ambientes DSS e DW.

A suíte do GoldenGate é composta dos seguintes produtos:

  • Oracle GoldenGate Media Pack: é o conjunto essencial do GoldenGate que reune os processos de captura e entrega de alterações nos bancos de dados.
  • Oracle GoldenGate Veridata: utilizado para comparar dados entre origem e destino, identificar o tempo de atraso na replicação e corrigir dados fora de sincronismo.
  • Oracle GoldenGate Management Pack: é composto do GG Monitor e do Plugin para o OEMCC.
  • Oracle GoldenGate for Big Data: permite integrar dados dos trail files com tecnologias de Big Data como HDFS, HBase, Kafka, Flume, JDBC, Cassandra, and MongoDB.
  • Oracle GoldenGate Application Adapters: possibilita a utilização do Java Message Services (JMS) como origem e/ou destino.

O Oracle GoldenGate oferece suporte para captura (capture/extract) de dados diversos bancos de dados:

  • Oracle Database
  • MySQL
  • IBM DB2
  • Microsoft SQL Server
  • Sybase
  • Teradata
  • Enscribe
  • SQL/MP
  • SQL/MX
  • Informix
  • JMS Message Queues

Para a entrega (delivery/replicat) dos dados:

  • Todos os listados acima
  • TimesTen
  • Flat Files

Também suporta diversas plataformas de sistemas operacionais:

  • Linux
  • Windows
  • Oracle Solaris
  • IBM AIX
  • IBM z/OS
  • IBM iSeries
  • z/Linux
  • HP-UX
  • HP NonStop
  • HP OpenVMS

Neste breve post vimos um pouco sobre o que é o Oracle GoldenGate, alguns de seus benefícios e topologias, os principais produtos da suíte e em que plataformas e bancos de dados ele é suportado.

No próximo post vamos ver como instalá-lo no sistema operacional Linux para só depois então começarmos a explorar sua arquitetura.

Abraços e até mais.

Franky

Referências:

https://docs.oracle.com/goldengate/c1230/gg-winux/GGCON/introduction-oracle-goldengate.htm#GUID-EF513E68-4237-4CB3-98B3-2E203A68CBD4

O post Oracle GoldenGate: Introdução apareceu primeiro em Lore Data.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi everyone, it has been quite a while I don’t publish anything. It is due to the amount of work I have for a few months. Things are becoming more stable now and I will be back to the blog more frequently.

Olá galera, faz um tempinho que não publico nada né? Isso se deve a quantidade de trabalho que tive por alguns meses. As coisas estão ficando mais estáveis agora e vou voltar ao blog com mais frequência.

Today I just want to bring to you all quickly how to extend a LVM based filesystem.

Hoje eu só quero trazer para vocês rapidamente como estender um filesystem em LVM.

This is an Oracle Linux 6.9 virtual machine and the /u01 filesystem got full:

Esta é uma máquina virtual com Oracle Linux 6.9 onde o filesystem /u01 encheu:

[root@oracle01 ~]# cat /etc/oracle-release
Oracle Linux Server release 6.9

[root@oracle01 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              12G  4.9G  6.3G  44% /
tmpfs                 3.9G  641M  3.3G  17% /dev/shm
/dev/sda1             2.0G  276K  2.0G   1% /boot/efi
/dev/mapper/vg_oracle-lvu01
                       58G   58G   16K 100% /u01

When that happens you start seeing this error everywhere: “Error message: Linux-x86_64 Error: 28: No space left on device”

Quando isso acontece você começa a ver esse erro em todo lugar: “Error message: Linux-x86_64 Error: 28: No space left on device”

LVM architecture overview

I just added 3 new disks with 30GB size each.

Eu adicionei 3 novos discos de 30GB cada.

If you pay attention here sda and sdc are being used already in vg_oracle Volume Group:

Se você prestar atenção aqui o sda e o sdc já estão sendo usados no Volume Group vg_oracle:

[root@oracle01 ~]# pvs
  PV         VG        Fmt  Attr PSize  PFree
  /dev/sda2  vg_oracle lvm2 a--u 30.00g    0
  /dev/sdc   vg_oracle lvm2 a--u 30.00g 1.99g

sdb is an ASM disk:

O sdb é um disco do ASM:

[root@oracle01 ~]# oracleasm querydisk -v -p /dev/sdb1
Device "/dev/sdb1" is marked an ASM disk with the label "DATA00"

So it remains from this list only sdd, sde and sdf:

Então restam desta lista somente sdd, sde e sdf:

[root@oracle01 ~]# ls -lh /dev/sd*
brw-rw----. 1 root disk 8,  0 Jan  7 10:15 /dev/sda
brw-rw----. 1 root disk 8,  1 Jan  7 10:15 /dev/sda1
brw-rw----. 1 root disk 8,  2 Feb  8 09:33 /dev/sda2
brw-rw----. 1 root disk 8,  3 Jan  7 10:15 /dev/sda3
brw-rw----. 1 root disk 8,  4 Jan  7 10:15 /dev/sda4
brw-rw----. 1 root disk 8, 16 Jan  7 10:15 /dev/sdb
brw-rw----. 1 root disk 8, 17 Jan  7 10:15 /dev/sdb1
brw-rw----. 1 root disk 8, 32 Feb  8 09:33 /dev/sdc
brw-rw----. 1 root disk 8, 48 Mar 15 18:03 /dev/sdd
brw-rw----. 1 root disk 8, 64 Mar 15 18:06 /dev/sde
brw-rw----. 1 root disk 8, 80 Mar 15 18:08 /dev/sdf

We could also check listing the block devices:

Nós podemos ainda verificar listando os block devices:

[root@oracle01 ~]# lsblk
NAME                       MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT
sda                          8:0    0   60G  0 disk
|-sda1                       8:1    0    2G  0 part /boot/efi
|-sda2                       8:2    0   30G  0 part
| `-vg_oracle-lvu01 (dm-0) 251:0    0  118G  0 lvm  /u01
|-sda3                       8:3    0   12G  0 part /
`-sda4                       8:4    0    8G  0 part [SWAP]
sdb                          8:16   0  120G  0 disk
`-sdb1                       8:17   0  120G  0 part
sdc                          8:32   0   30G  0 disk
`-vg_oracle-lvu01 (dm-0)   251:0    0  118G  0 lvm  /u01
sdd                          8:48   0   30G  0 disk
`-vg_oracle-lvu01 (dm-0)   251:0    0  118G  0 lvm  /u01
sde                          8:64   0   30G  0 disk
`-vg_oracle-lvu01 (dm-0)   251:0    0  118G  0 lvm  /u01
sdf                          8:80   0   30G  0 disk
sr0                         11:0    1 1024M  0 rom

Now we will use the new disks to increase our filesystem.

Agora vamos usar os novos discos para aumentar o filesystem.

First we create a Physical Volume for each one of them:

Primeiro criamos um Physical Volume para cada um deles:

[root@oracle01 ~]# pvcreate /dev/sdd
  Physical volume "/dev/sdd" successfully created

[root@oracle01 ~]# pvcreate /dev/sde
  Physical volume "/dev/sde" successfully created

[root@oracle01 ~]# pvcreate /dev/sdf
  Physical volume "/dev/sdf" successfully created

We list the physical volumes to check if they were created as expected:

Listamos os physical volumes para verificar se foram criados como esperado:

[root@oracle01 ~]# pvs
  PV         VG        Fmt  Attr PSize  PFree
  /dev/sda2  vg_oracle lvm2 a--u 30.00g     0
  /dev/sdc   vg_oracle lvm2 a--u 30.00g  1.99g
  /dev/sdd             lvm2 ---- 30.00g 30.00g
  /dev/sde             lvm2 ---- 30.00g 30.00g
  /dev/sdf             lvm2 ---- 30.00g 30.00g

Then we add the physical volumes to our volume group vg_oracle:

Então adicionamos os physical volumes no nosso volume group vg_oracle:

[root@oracle01 ~]# vgextend vg_oracle /dev/sdd
  Volume group "vg_oracle" successfully extended

[root@oracle01 ~]# vgextend vg_oracle /dev/sde
  Volume group "vg_oracle" successfully extended

[root@oracle01 ~]# vgextend vg_oracle /dev/sdf
  Volume group "vg_oracle" successfully extended

We can confirm the volume group was extended:

Podemos confirmar que o volume group foi estendido:

[root@oracle01 ~]# vgs
  VG        #PV #LV #SN Attr   VSize   VFree
  vg_oracle   5   1   0 wz--n- 149.98g 91.98g

Listing our Logical Volumes we see the lvu01 has 58GB in size:

Listando nossos logical volumes vemos que o lvu01 tem 58GB de tamanho:

[root@oracle01 ~]# lvs
  LV    VG        Attr       LSize  Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert
  lvu01 vg_oracle -wi-ao---- 58.00g

We extend it adding 60GB:

Estendemos adicionando 60GB:

[root@oracle01 ~]# lvextend -L +60G /dev/mapper/vg_oracle-lvu01
  Size of logical volume vg_oracle/lvu01 changed from 58.00 GiB (14848 extents) to 118.00 GiB (30208 extents).
  Logical volume lvu01 successfully resized.

Ok, done? No. If we check the filesystem size it was not yet increased:

Ok, pronto? Não. Se verificarmos o tamanho do filesystem ele não foi expandido:

[root@oracle01 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              12G  4.9G  6.3G  44% /
tmpfs                 3.9G  641M  3.3G  17% /dev/shm
/dev/sda1             2.0G  276K  2.0G   1% /boot/efi
/dev/mapper/vg_oracle-lvu01
                       58G   58G   16K 100% /u01

Since we are using a XFS filesystem here we need to update the /u01 filesystem with the LVM data. In order to do that for a XFS filesystem we use the xfs_growfs command:

Como estamos usando um filesystem XFS aqui precisamos fazer a atualização do filesystem /u01 com os dados do LVM. Para fazer isso para um filesystem XFS usamos o comando xfs_growfs:

[root@oracle01 ~]# xfs_growfs /u01
meta-data=/dev/mapper/vg_oracle-lvu01 isize=256    agcount=12, agsize=1310720 blks
         =                       sectsz=4096  attr=2, projid32bit=1
         =                       crc=0        finobt=0
data     =                       bsize=4096   blocks=15204352, imaxpct=25
         =                       sunit=0      swidth=0 blks
naming   =version 2              bsize=4096   ascii-ci=0 ftype=0
log      =internal               bsize=4096   blocks=2560, version=2
         =                       sectsz=4096  sunit=1 blks, lazy-count=1
realtime =none                   extsz=4096   blocks=0, rtextents=0
data blocks changed from 15204352 to 30932992

Note: If you are using EXT3 or EXT4 you should still use the resize2fs command instead of the xfs_growfs.

Obs: Se você estiver usando EXT3 ou EXT4 você ainda deve usar o comando resize2fs ao invés do xfs_growfs.

Now we see the filesystem /u01 has more space available:

Agora vemos que o filesystem /u01 tem mais espaço disponível:

[root@oracle01 ~]# df -h /u01
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_oracle-lvu01
                      118G   60G   59G  51% /u01

If we list the volume group vg_oracle again we will see that we still have available +30GB free, that’s because we added 3 disks of 30GB each and we only extended 60GB in our logical volume:

Se listarmos o volume group vg_oracle novamente veremos que ainda temos +30GB disponíveis, isso porque adicionamos 3 discos de 30GB cada e estendemos somente 60GB no nosso logical volume:

[root@oracle01 ~]# vgs
  VG        #PV #LV #SN Attr   VSize   VFree
  vg_oracle   5   1   0 wz--n- 149.98g 31.98g

[root@oracle01 ~]# vgdisplay vg_oracle
  --- Volume group ---
  VG Name               vg_oracle
  System ID
  Format                lvm2
  Metadata Areas        5
  Metadata Sequence No  10
  VG Access             read/write
  VG Status             resizable
  MAX LV                0
  Cur LV                1
  Open LV               1
  Max PV                0
  Cur PV                5
  Act PV                5
  VG Size               149.98 GiB
  PE Size               4.00 MiB
  Total PE              38395
  Alloc PE / Size       30208 / 118.00 GiB
  Free  PE / Size       8187 / 31.98 GiB
  VG UUID               wC9kc3-0bAa-VsLB-Rcov-cLlz-H471-H0cYy0

That’s all for today folks. In case of any doubt leave a comment.

Por hoje é só pessoal. Em caso de qualquer dúvida deixe um comentário.

Franky

O post Easily extending a LVM filesystem apareceu primeiro em Lore Data.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Olá pessoal, aqui vou mostrar como instalar rapidamente o Ansible no OSX.

Hi guys, here I am showing how to quickly install Ansible in OSX.

Um breve resumo do que o Ansible é:

Ninguém gosta de tarefas repetitivas. Com o Ansible, administradores de TI podem começar a automatizar o trabalho pesado de seu dia-a-dia. Automação liberta os admins para focar seus esforços de maneira que ajudem a entregar mais valor ao negócio aumentando a velocidade da entrega de aplicações e construindo uma cultura de sucesso. Ultimamente o Ansible tem dado aos times o que eles não conseguem ter o suficiente: tempo. Permitindo pessoas inteligentes focar em coisas inteligentes.

O Ansible é uma linguagem simples de automoção que pode perfeitamente descrever uma infraestrutura de TI. É fácil de aprender, é auto-documentado e não requer um nível de cientista da computação para lê-lo. Automação não deve ser mais complexa que as tarefas que substitui.

A briefly summary of what Ansible is:

No one likes repetitive tasks. With Ansible, IT admins can begin automating away the drudgery from their daily tasks. Automation frees admins up to focus on efforts that help deliver more value to the business by speeding time to application delivery, and building on a culture of success. Ultimately, Ansible gives teams the one thing they can never get enough of: time. Allowing smart people to focus on smart things.

Ansible is a simple automation language that can perfectly describe an IT application infrastructure. It’s easy-to-learn, self-documenting, and doesn’t require a grad-level computer science degree to read. Automation shouldn’t be more complex than the tasks it’s replacing.

Instalação do Ansible / Ansible Installation

Primeiro precisamos instalar o PIP para depois podermos baixar o Ansible através dele:

First of all we have to install PIP to later enable Ansible download from it:

Frankys-MBP:~ franky$  sudo easy_install pip
Password:
Searching for pip
Reading https://pypi.python.org/simple/pip/
Best match: pip 9.0.1
Downloading https://pypi.python.org/packages/11/b6/abcb525026a4be042b486df43905d6893fb04f05aac21c32c638e939e447/pip-9.0.1.tar.gz#md5=35f01da33009719497f01a4ba69d63c9
Processing pip-9.0.1.tar.gz
Writing /tmp/easy_install-s7HZSN/pip-9.0.1/setup.cfg
Running pip-9.0.1/setup.py -q bdist_egg --dist-dir /tmp/easy_install-s7HZSN/pip-9.0.1/egg-dist-tmp-GgKras
/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown distribution option: 'python_requires'
  warnings.warn(msg)
warning: no previously-included files found matching '.coveragerc'
warning: no previously-included files found matching '.mailmap'
warning: no previously-included files found matching '.travis.yml'
warning: no previously-included files found matching '.landscape.yml'
warning: no previously-included files found matching 'pip/_vendor/Makefile'
warning: no previously-included files found matching 'tox.ini'
warning: no previously-included files found matching 'dev-requirements.txt'
warning: no previously-included files found matching 'appveyor.yml'
no previously-included directories found matching '.github'
no previously-included directories found matching '.travis'
no previously-included directories found matching 'docs/_build'
no previously-included directories found matching 'contrib'
no previously-included directories found matching 'tasks'
no previously-included directories found matching 'tests'
creating /Library/Python/2.7/site-packages/pip-9.0.1-py2.7.egg
Extracting pip-9.0.1-py2.7.egg to /Library/Python/2.7/site-packages
Adding pip 9.0.1 to easy-install.pth file
Installing pip script to /usr/local/bin
Installing pip2.7 script to /usr/local/bin
Installing pip2 script to /usr/local/bin

Installed /Library/Python/2.7/site-packages/pip-9.0.1-py2.7.egg
Processing dependencies for pip
Finished processing dependencies for pip

Clique em install para concluir a instalação do PIP.

Just click install to finish PIP installation.

Agora usamos o PIP para fazer download e instalar o Ansible:

Now we use PIP to download and install Ansible:

Frankys-MBP:~ franky$ sudo pip install ansible
The directory '/Users/franky/Library/Caches/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
The directory '/Users/franky/Library/Caches/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
Collecting ansible
  Downloading ansible-2.4.1.0.tar.gz (6.7MB)
    100% |████████████████████████████████| 6.7MB 195kB/s
Collecting jinja2 (from ansible)
  Downloading Jinja2-2.10-py2.py3-none-any.whl (126kB)
    100% |████████████████████████████████| 133kB 5.6MB/s
Collecting PyYAML (from ansible)
  Downloading PyYAML-3.12.tar.gz (253kB)
    100% |████████████████████████████████| 256kB 3.8MB/s
Collecting paramiko (from ansible)
  Downloading paramiko-2.4.0-py2.py3-none-any.whl (192kB)
    100% |████████████████████████████████| 194kB 4.4MB/s
Collecting cryptography (from ansible)
  Downloading cryptography-2.1.3-cp27-cp27m-macosx_10_6_intel.whl (1.5MB)
    100% |████████████████████████████████| 1.5MB 731kB/s
Requirement already satisfied: setuptools in /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python (from ansible)
Collecting MarkupSafe>=0.23 (from jinja2->ansible)
  Downloading MarkupSafe-1.0.tar.gz
Collecting pyasn1>=0.1.7 (from paramiko->ansible)
  Downloading pyasn1-0.4.2-py2.py3-none-any.whl (71kB)
    100% |████████████████████████████████| 71kB 6.0MB/s
Collecting bcrypt>=3.1.3 (from paramiko->ansible)
  Downloading bcrypt-3.1.4-cp27-cp27m-macosx_10_6_intel.whl (51kB)
    100% |████████████████████████████████| 61kB 7.0MB/s
Collecting pynacl>=1.0.1 (from paramiko->ansible)
  Downloading PyNaCl-1.2.0-cp27-cp27m-macosx_10_6_intel.whl (243kB)
    100% |████████████████████████████████| 245kB 3.2MB/s
Requirement already satisfied: six>=1.4.1 in /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python (from cryptography->ansible)
Collecting cffi>=1.7; platform_python_implementation != "PyPy" (from cryptography->ansible)
  Downloading cffi-1.11.2-cp27-cp27m-macosx_10_6_intel.whl (238kB)
    100% |████████████████████████████████| 245kB 4.2MB/s
Collecting enum34; python_version < "3" (from cryptography->ansible)
  Downloading enum34-1.1.6-py2-none-any.whl
Collecting idna>=2.1 (from cryptography->ansible)
  Downloading idna-2.6-py2.py3-none-any.whl (56kB)
    100% |████████████████████████████████| 61kB 7.6MB/s
Collecting asn1crypto>=0.21.0 (from cryptography->ansible)
  Downloading asn1crypto-0.23.0-py2.py3-none-any.whl (99kB)
    100% |████████████████████████████████| 102kB 7.1MB/s
Collecting ipaddress; python_version < "3" (from cryptography->ansible)
  Downloading ipaddress-1.0.18-py2-none-any.whl
Collecting pycparser (from cffi>=1.7; platform_python_implementation != "PyPy"->cryptography->ansible)
  Downloading pycparser-2.18.tar.gz (245kB)
    100% |████████████████████████████████| 256kB 1.6MB/s
Installing collected packages: MarkupSafe, jinja2, PyYAML, pyasn1, pycparser, cffi, bcrypt, enum34, idna, asn1crypto, ipaddress, cryptography, pynacl, paramiko, ansible
  Running setup.py install for MarkupSafe ... done
  Running setup.py install for PyYAML ... done
  Running setup.py install for pycparser ... done
  Running setup.py install for ansible ... done
Successfully installed MarkupSafe-1.0 PyYAML-3.12 ansible-2.4.1.0 asn1crypto-0.23.0 bcrypt-3.1.4 cffi-1.11.2 cryptography-2.1.3 enum34-1.1.6 idna-2.6 ipaddress-1.0.18 jinja2-2.10 paramiko-2.4.0 pyasn1-0.4.2 pycparser-2.18 pynacl-1.2.0

E estamos prontos para começar a usar o Ansible.

And we are ready to start using Ansible.

Frankys-MBP:~ franky$ ansible --version
ansible 2.4.1.0
  config file = None
  configured module search path = [u'/Users/franky/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules']
  ansible python module location = /Library/Python/2.7/site-packages/ansible
  executable location = /usr/local/bin/ansible
  python version = 2.7.10 (default, Jul 15 2017, 17:16:57) [GCC 4.2.1 Compatible Apple LLVM 9.0.0 (clang-900.0.31)]

Espero que seja útil para alguém.

Hope it helps someone.

Abraços,

Best regards,

Franky

O post Ansible: Installing on Mac OSX apareceu primeiro em Lore Data.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Fala galera. Aqui vou mostrar uma visão geral do que acontece quando você usa o novo recurso Online Tablespace Encryption do Oracle Database 12cR2 .

What’s up guys? Here just a quick overview of what happens when you use the new feature Online Tablespace Encryption of Oracle Database 12cR2 .

Só quero mostrar o que o Oracle faz quando está criptografando uma tablespace existente de maneira online. Então vamos ver o exemplo.

I just want to show what Oracle does when encrypting an existing tablespace online. So let us see the example.

Conecte-se ao banco de dados:

Connect to the database:

[oracle@oracle-srv ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Nov 26 20:51:21 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Como estamos trabalhando com o TDE precisamos ver o status da wallet:

As we are dealing with TDE we have to check the wallet status:

SQL> SET LIN 1000
SQL> COL WRL_PARAMETER FORM A60
SQL> COL STATUS FORM A20
SQL> SELECT WRL_PARAMETER,STATUS,WALLET_TYPE FROM V$ENCRYPTION_WALLET;

WRL_PARAMETER						     					 STATUS		  		  WALLET_TYPE
------------------------------------------------------------ -------------------- --------------------
/u01/app/oracle/product/12.2.0.1/			     			 OPEN		  		  PASSWORD

A wallet está aberta no nível do CDB, mas a tablespace que eu quero alterar está num PDB, então vou alternar minha sessão para o SOEPDB:

It is open at the CDB level, but the tablespace I want to change is on a PDB, so I will alternate my session to SOEPDB:

SQL> alter session set container=soepdb;

Session altered.

Agora vamos tentar criptografar a tablespace:

Let us try to encrypt the tablespace:

SQL> ALTER TABLESPACE tsdsoe ENCRYPTION ONLINE USING 'AES192' ENCRYPT;
ALTER TABLESPACE tsdsoe ENCRYPTION ONLINE USING 'AES192' ENCRYPT
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet

Não funcionou, pois eu ainda não possuo uma keystore para este PDB.

It did not work, since I did not have a keystore for this PDB yet.

Então vamos criar a keystore:

So let’s create the keystore:

SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "oracle" WITH BACKUP USING 'mkey_bkp' ;

keystore altered.

Agora vamos tentar criptografar novamente:

Now we try to encrypt again:

SQL> ALTER TABLESPACE tsdsoe ENCRYPTION ONLINE USING 'AES192' ENCRYPT;

Tablespace altered.

Joia, funcionou. Vamos consultar a dba_tablespaces para verificar:

Fine, it worked. Let’s query dba_tablespaces to check:

SQL> select TABLESPACE_NAME, STATUS, CONTENTS, ENCRYPTED from dba_tablespaces;

TABLESPACE_NAME 	       	   STATUS	 CONTENTS	       	   ENC
------------------------------ --------- --------------------- ---
SYSTEM			       		   ONLINE	 PERMANENT	           NO
SYSAUX			       		   ONLINE	 PERMANENT	           NO
UNDOTBS1		       		   ONLINE	 UNDO		           NO
TEMP			       		   ONLINE	 TEMPORARY	           NO
TSDSOE			       		   ONLINE	 PERMANENT	           YES

5 rows selected.

Aqui vem a parte interessante… Se verificarmos o alert.log vamos ver o que acabou de acontecer. Vou dividir para explicar melhor.

Here comes the interesting part… If we check the alert.log we will see what just happened. I will split it to explain better.

Aqui é a parte que deu erro devido a keystore que estava faltando:

Here the error due to the missing keystore:

2017-11-26T20:51:42.178245+01:00
SOEPDB(3):ALTER TABLESPACE tsdsoe ENCRYPTION ONLINE USING 'AES192' ENCRYPT
SOEPDB(3):ORA-28374 signalled during: ALTER TABLESPACE tsdsoe ENCRYPTION ONLINE USING 'AES192' ENCRYPT...

Aqui temos a keystore que acabou de ser criada:

Here we have the keystore that was just created:

2017-11-26T20:52:10.014414+01:00
SOEPDB(3):Creating new database key for new master key and wallet
SOEPDB(3):Creating new database key with the new master key
SOEPDB(3):Retiring: ena 2 flag 6 mkloc 0
SOEPDB(3):   encrypted key 2b1a5e2f3558f388cbfb462baade6d4d00000000000000000000000000000000
SOEPDB(3):   mkid a143b7686a934fedbfdcf2064294430e
SOEPDB(3):Creating: ena 2 flag e mkloc 1
SOEPDB(3):   encrypted key e219426db356adfcaf17b19e958ea28300000000000000000000000000000000
SOEPDB(3):   mkid 88b8e3272f964f41bf3dacd75e230de2
SOEPDB(3):New database key and new master key created successfully

E aqui o procedimento de criptografia propriamente dito. Observe que o Oracle copiou os dados de um existente datafile para um novo:

And here is the encryption procedure itself. Observe that Oracle copied data from an existing datafile to a new one:

2017-11-26T20:52:21.577789+01:00
SOEPDB(3):ALTER TABLESPACE tsdsoe ENCRYPTION ONLINE USING 'AES192' ENCRYPT
2017-11-26T20:52:21.584722+01:00
SOEPDB(3):About to encrypt tablespace TSDSOE (tsn 3/4)
SOEPDB(3):Rekeying datafile /u02/oradata/CDB2/58542FF64D541288E0530F0FA8C0C065/datafile/o1_mf_tsdsoe_dtsdhmr8_.dbf (12) to /u02/oradata/CDB2/58542FF64D541288E0530F0FA8C0C065/datafile/o1_mf_tsdsoe_%u_.dbf
2017-11-26T20:52:26.449204+01:00
SOEPDB(3):Rekey operation committed for file /u02/oradata/CDB2/58542FF64D541288E0530F0FA8C0C065/datafile/o1_mf_tsdsoe_f1p6vonj_.dbf

E depois excluiu o datafile não criptografado:

And then deleted the non encrypted datafile:

2017-11-26T20:52:28.462284+01:00
SOEPDB(3):About to zero out original file "/u02/oradata/CDB2/58542FF64D541288E0530F0FA8C0C065/datafile/o1_mf_tsdsoe_dtsdhmr8_.dbf"
2017-11-26T20:52:30.658380+01:00
SOEPDB(3):Successfully zero'ed out original file "/u02/oradata/CDB2/58542FF64D541288E0530F0FA8C0C065/datafile/o1_mf_tsdsoe_dtsdhmr8_.dbf"
SOEPDB(3):Successfully deleted original file "/u02/oradata/CDB2/58542FF64D541288E0530F0FA8C0C065/datafile/o1_mf_tsdsoe_dtsdhmr8_.dbf"
SOEPDB(3):Completed rekey for tablespace TSDSOE (tsn 3/4) from key version 0 to 1.
SOEPDB(3):Completed: ALTER TABLESPACE tsdsoe ENCRYPTION ONLINE USING 'AES192' ENCRYPT
2017-11-26T20:53:41.656374+01:00

Então quando você quiser criptografar online uma tablespace tenha certeza de que você possui espaço audiente para dobrar o tamanho da tablespace para que esta operação conclua com sucesso.

So when you want to online encrypt a tablespace make sure you have enough room to double the size of this tablespace for this operation to be successfully concluded.

Espero que tenham gostado!

Hope you enjoyed it!

Abraços e até mais,

Best regards,

Franky

O post What happens when using Online Tablespace Encryption apareceu primeiro em Lore Data.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Olá galera, gostaria de compartilhar com vocês um método para realizar o deinstall do Oracle Database sem remover os arquivos do banco de dados durante o processo. Eu ajudei um amigo nessa situação semana passada e decidi publicar aqui para todo mundo. O cenário dele era remover o software do Oracle Database 11gR2 Standard Edition e instalar o Oracle Database 11gR2 Enterprise Edition no mesmo Oracle Home (OH) devido à limitação de espaço no filesystem. Resumindo… ele queria somente remover o software sem afetar o banco de dados.

Hi guys, here I want to show a method of removing your Oracle Database installation without removing your database in the process. I helped a friend in this situation last week and decided to publish here for everyone. His scenario was to remove Oracle Database 11gR2 Standard Edition and install Oracle Database 11gR2 Enterprise Edition in the same Oracle Home (OH) due to filesystem space limitation. So he wanted only to remove the software without affecting the database.

Está claro que o procedimento de desinstalação remove todos os arquivos do banco de dados, mas encontrei uma solução bem fácil para evitar que o script de desinstalação faça isso: Mover todos os spfiles/pfiles armazenados no OH que será removido para um diretório temporário e só então executar o procedimento de desinstalação. Por favor, lembre-se de copiar todos os arquivos do Oracle Net, arquivos de senha e todos os demais arquivos específicos para o seu ambiente antes de executar o script de desinstalação, pois ele remove completamente toda a árvore de diretórios do OH.

So it is clear that deinstall procedure removes all the database files, but there is an easy solution that came to my mind to avoid the deinstall script from doing that: Move all spfiles/pfiles that reside in the OH that will be removed to a temporary directory and then run deinstall. Please, remember to copy your Oracle Net files, password files and all other files that maybe specific to your environment before running the deinstall script since OH directory tree will be completely deleted.

Ajuste as variáveis de ambiente para o OH desejado:

Define your environment variables to the desired OH:

[oracle@oracle-srv ~]$ . oraenv
ORACLE_SID = [UPGR] ? CDB1
The Oracle base remains unchanged with value /u01/app/oracle

Vá ao diretório do OH:

Change directory to the OH:

[oracle@oracle-srv ~]$ cd $ORACLE_HOME/dbs

Liste o conteúdo:

List the contents:

[oracle@oracle-srv dbs]$ ls
hc_CDB1.dat  init.ora  lkCDB1  orapwCDB1  spfileCDB1.ora

E mova todos os spfiles/pfiles:

And move all spfiles/pfiles:

[oracle@oracle-srv dbs]$ mv spfileCDB1.ora /tmp/spfileCDB1.ora_bkp

Vá ao diretório do script de desinstalação:

Change directory to the deinstall script:

[oracle@oracle-srv dbs]$ cd ../deinstall/

Execute o script de desinstalação e forneça as informações necessárias (não informe o local do spfile):

Run the deinstall script and provide information as requested (do not provide spfile location):

[oracle@oracle-srv deinstall]$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /u01/app/oraInventory/logs/

############ ORACLE DECONFIG TOOL START ############


######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##


Checking for existence of the Oracle home location /u01/app/oracle/product/12.1.0.2
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oraInventory

## [END] Install check configuration ##


Network Configuration check config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2017-11-25_09-17-07-PM.log

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2017-11-25_09-17-15-PM.log

Use comma as separator when specifying list of values as input

Specify the list of database names that are configured in this Oracle home [CDB1]:



###### For Database 'CDB1' ######

Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database) [1]: Specify the diagnostic destination location of the database [/u01/app/oracle/diag/rdbms/cdb1]: 1
Specify the storage type used by the Database ASM|FS []: FS

Specify the list of directories if any database files exist on a shared file system. If 'CDB1' subdirectory is found, then it will be deleted. Otherwise, the specified directory will be deleted. Alternatively, you can specify list of database files with full path [ ]:

Specify the fast recovery area location, if it is configured on the file system. If 'CDB1' subdirectory is found, then it will be deleted. []:

Specify the database spfile location [ ]:

Database Check Configuration END
Oracle Configuration Manager check START
OCM check log file location : /u01/app/oraInventory/logs//ocm_check4658.log
Oracle Configuration Manager check END

######################### DECONFIG CHECK OPERATION END #########################


####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /u01/app/oracle/product/12.1.0.2
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
The following databases were selected for de-configuration : CDB1
Database unique name : CDB1
Storage used : FS
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2017-11-25_09-17-07-PM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2017-11-25_09-17-07-PM.err'

######################## DECONFIG CLEAN OPERATION START ########################
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_clean2017-11-25_09-24-19-PM.log
Database Clean Configuration START CDB1
This operation may take few minutes.




Database Clean Configuration END CDB1

Network Configuration clean config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_clean2017-11-25_09-28-35-PM.log

De-configuring Local Net Service Names configuration file...
Local Net Service Names configuration file de-configured successfully.

De-configuring backup files...
Backup files de-configured successfully.

The network configuration has been cleaned up successfully.

Network Configuration clean config END

Oracle Configuration Manager clean START
OCM clean log file location : /u01/app/oraInventory/logs//ocm_clean4658.log
Oracle Configuration Manager clean END

######################### DECONFIG CLEAN OPERATION END #########################


####################### DECONFIG CLEAN OPERATION SUMMARY #######################
Successfully de-configured the following database instances : CDB1
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
#######################################################################


############# ORACLE DECONFIG TOOL END #############

Using properties file /tmp/deinstall2017-11-25_09-16-40PM/response/deinstall_2017-11-25_09-17-07-PM.rsp
Location of logs /u01/app/oraInventory/logs/

############ ORACLE DEINSTALL TOOL START ############



####################### DEINSTALL CHECK OPERATION SUMMARY #######################
A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2017-11-25_09-17-07-PM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2017-11-25_09-17-07-PM.err'

######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to oracle-srv
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2017-11-25_09-16-40PM/oraInst.loc
Setting oracle.installer.local to false

## [END] Preparing for Deinstall ##

Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START

Detach Oracle home '/u01/app/oracle/product/12.1.0.2' from the central inventory on the local node : Done

Delete directory '/u01/app/oracle/product/12.1.0.2' on the local node : Done

The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/u01/app/oracle/product/12.2.0.1'.

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END


## [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2017-11-25_09-16-40PM' on node 'oracle-srv'

## [END] Oracle install clean ##


######################### DEINSTALL CLEAN OPERATION END #########################


####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/u01/app/oracle/product/12.1.0.2' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/product/12.1.0.2' on the local node.
Oracle Universal Installer cleanup was successful.

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################


############# ORACLE DEINSTALL TOOL END #############

A desinstalação finalizou com sucesso. Vamos ver como as coisas ficaram:

Deinstall has finished successfully. Let us check how things are now:

[oracle@oracle-srv deinstall]$ pwd
/u01/app/oracle/product/12.1.0.2/deinstall

Vou tentar subir um diretório:

I will try to change to the above directory:

[oracle@oracle-srv deinstall]$ cd ..
cd: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

Como esperado todos os diretórios do OH foram removidos.

As expected all directories inside the OH were deleted.

Então vou alternar para um diretório existente:

So I will change to an existing directory:

[oracle@oracle-srv ..]$ cd
[oracle@oracle-srv ~]$

E agora vamos verificar os arquivos do banco de dados:

And now let us check our database files:

[oracle@oracle-srv ~]$ cd /u02/oradata/CDB1

Liste o diretório dos arquivos do banco de dados:

List the database files directory:

[oracle@oracle-srv CDB1]$ ll
total 5378508
drwxr-x---. 3 oracle dba       4096 Sep 13 01:52 5907BDCE10441229E0530C0FA8C007D7
-rw-r-----. 1 oracle dba   17973248 Nov 13 02:06 control01.ctl
-rw-r-----. 1 oracle dba   17973248 Nov 13 02:06 control02.ctl
drwxr-xr-x. 2 oracle dba       4096 Jul 23  2016 pdb3
drwxr-x---. 2 oracle dba       4096 Aug 12  2016 pdbseed
-rw-r-----. 1 oracle dba  524288512 Nov 12 15:28 redo01.log
-rw-r-----. 1 oracle dba  524288512 Nov 13 02:05 redo02.log
-rw-r-----. 1 oracle dba  524288512 Nov 12 15:28 redo03.log
-rw-r-----. 1 oracle dba  524288512 Nov 12 15:28 redo04.log
-rw-r-----. 1 oracle dba  524288512 Nov 12 15:28 redo05.log
-rw-r-----. 1 oracle dba  576724992 Nov 13 02:05 sysaux01.dbf
-rw-r-----. 1 oracle dba  891297792 Nov 13 02:05 system01.dbf
-rw-r-----. 1 oracle dba  125837312 Nov 13 02:01 temp01.dbf
-rw-r-----. 1 oracle dba 1253056512 Nov 13 02:05 undotbs01.dbf
-rw-r-----. 1 oracle dba    5251072 Nov 13 02:05 users01.dbf

Está tudo intacto. Agora você pode seguir com sua próxima instalação no mesmo filesystem e usar todos os arquivos de configuração que você salvou do OH que foi removido.

Everything is intact. Now you can proceed your next installation in the same filesystem you had and use all the configuration files you saved from the OH that was removed.

Por hoje é só pessoal, grande abraço e até mais.

That is all for today folks, best regards and see you soon.

Franky

O post How to deinstall your OH without removing your DB apareceu primeiro em Lore Data.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Olá pessoal, gostaria de compartilhar com vocês que no dia 22 de novembro de 2017 a Oracle me nomeou publicamente como Oracle ACE. O momento para isso acontecer não poderia ser melhor e você vai descobrir porque em breve. O sentimento é de felicidade e realização. O título é dado para profissionais que demonstram domínio na área em que atuam e compartilham o conhecimento com a comunidade. A partir de agora tenho meu perfil nesta página da Oracle: Perfil.

Hello guys, I would like to share with you that on November 22nd, 2017 Oracle has publicly nominated me as Oracle ACE. The time for that to happen could not be better and you will find out why soon. The feeling is of happiness and fulfillment. It is much appreciated to be recognized by Oracle with this award. This title is given to professionals who show extensive knowledge in their area of expertise and share their knowledge with the community. From now on I have a profile in this Oracle webpage: Profile.

O Programa tem três níveis:

  • Oracle ACE Associate: É o nível de entrada, para profissionais que estão começando a compartilhar o conhecimento com a comunidade.
  • Oracle ACE: É o nível intermediária, para experts que já estão bem conhecidos na comunidade e tem um bom volume de contribuição.
  • Oracle ACE Director: É o nível mais alto, para experts que trabalham de maneira mais próxima da Oracle com a finalidade de desenvolver a comunidade e também compartilhar o vasto conhecimento que possuem.

The Program has three levels:

  • Oracle ACE Associate: Is entry level, for professionals that are starting to share their knowledge with the community.
  • Oracle ACE: Is the middle level, for experts that are well known in the community and has a good amount of contribution.
  • Oracle ACE Director: Is the top level, for experts who work closely to Oracle to grow the community and also share their extensive knowledge.

Veja este vídeo e saiba mais sobre o programa. Também acesse este link.

Watch this video and learn more about the program. Also check this link.

Se tiver qualquer dúvida e quiser trocar uma ideia é só entrar em contato.

If you have any doubt and would you like to chat about it, feel free to contact me.

Grande abraço,

Best regards,

Franky
 

O post Oracle ACE award achieved! apareceu primeiro em Lore Data.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Olá pessoal, hoje vamos ver aqui como consultar o tamanho de cada componente do AWR e como estimar o tamanho do AWR.

Hi everyone, today we will see how to query the size of each AWR component and how to estimate AWR size.

Vamos só esclarecer um ponto primeiro… AWR significa Automatic Workload Repository, que é um repositório de dados referente à carga do ambiente. Podemos gerar um relatório desse repositório para analisar mudanças na carga de trabalho, mas não é isto que faremos aqui. Para saber mais sobre o AWR e o relatório do AWR você pode consultar este artigo.

First, let me clear a thing… AWR means Automatic Workload Repository, which is a data repository regarding to environment’s workload. We can generate a report of the repository to analyze changes in the workload, but that is not what we are doing here. If you want to know more about the AWR and AWR Report you can read this post.

Conteúdo do AWR / AWR contents

Vamos agora verificar como consultar o conteúdo do AWR de maneira fácil. Para isso a Oracle fornece um script chamado awrinfo.sql e ele já é padrão em todas as instalações.

Let us check now how to easily query AWR contents. To do that Oracle provides a simple script called awrinfo.sql and it comes by default in every installation.

Podemos executá-lo da seguinte maneira através do SQL*Plus:

We can run it directly from SQL*Plus:

SQL> @?/rdbms/admin/awrinfo

This script will report general AWR information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Specify the Report File Name
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrinfo.txt.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name:

Using the report name awrinfo.txt
No errors.
No errors.
~~~~~~~~~~~~~~~
AWR INFO Report
~~~~~~~~~~~~~~~

******demais linhas do output omitidas******
******other output lines omitted******

Se você não informar nenhum nome específico para o relatório ele será gerado com o nome padrão awrinfo.txt.

If you do not provide any specific name for the report it will be generated with the default name awrinfo.txt.

Este relatório possui várias seções referentes ao conteúdo do AWR:

This report has many sections regarding AWR contents:

(I) AWR Snapshots Information
(1a) SYSAUX usage - Schema breakdown (dba_segments)
(1b) SYSAUX occupants space usage (v$sysaux_occupants)
(1c) SYSAUX usage - Unregistered Schemas
(1d) SYSAUX usage - Unaccounted space in registered schemas
(2) Size estimates for AWR snapshots
(3a) Space usage by AWR components (per database)
(3b) Space usage within AWR Components (> 500K)
(4) Space usage by non-AWR components (> 500K)
(5a) AWR snapshots - last 50
(5b) AWR snapshots with errors or invalid
(5c) AWR snapshots -- OLDEST Non-Baselined snapshots
(6) AWR Control Settings - interval, retention
(7a) AWR Contents - row counts for each snapshots
(7b) AWR Contents - average row counts per snapshot
(7c) AWR total item counts - names, text, plans
(II) Advisor Framework Info
(1) Advisor Tasks - Last 50
(2) Advisor Task - Oldest 5
(3) Advisor Tasks With Errors - Last 50
(III) ASH Usage Info
(1a) ASH histogram (past 3 days)
(1b) ASH histogram (past 1 day)
(2a) ASH details (past 3 days)
(2b) ASH details (past 1 day)
(2c) ASH sessions (Fg Vs Bg) (past 1 day across all instances in RAC)

Veja aqui neste link o relatório gerado como exemplo para este artigo.

Click this link to see the report generated as an example for this article.

Estimando o tamanho do AWR e da tablespace SYSAUX / Estimating AWR and SYSAUX tablespace size

Vimos como gerar o relatório para consultar o conteúdo do AWR, agora vamos ver como estimar o tamanho do AWR conforme nossas especificações.

We just saw how to generate the report to query AWR contents and now we are going to see how to estimate AWR size based on our specification.

Este script também gera um relatório e também está presente por padrão em todas as instalações do Oracle Database.

This script also generates a report and it also comes by default in any Oracle Database installation.

Para gerar o relatório executamos o seguinte script via SQL*Plus:

To generate the report we can execute the following script via SQL*Plus:

SQL> @?/rdbms/admin/utlsyxsz


This script estimates the space required for the SYSAUX tablespace.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
******demais linhas do output omitidas******
******other output lines omitted******

Você vai ver que precisa fornecer alguns dados de acordo com suas necessidades para que a estimativa seja mais precisa.

You will see that you have to provide some data regarding your needs for the estimates to be more precise.

Os dados que você precisa informar são:

Those input data are the following:

~~~~~~~~~~~~~~~~~~~~
AWR Space Estimation
~~~~~~~~~~~~~~~~~~~~

| To estimate the size of the Automatic Workload Repository (AWR)
| in SYSAUX, we need the following values:
|
|     - Interval Setting (minutes)
|     - Retention Setting (days)
|     - Number of Instances
|     - Average Number of Active Sessions
|     - Number of Datafiles

Um output como este será gerado:

Some output like this will be generated:

| ***************************************************
| Estimated size of AWR:                   2,145.6 MB
|
|   The AWR estimate was computed using
|   the following values:
|
|            Interval -        15 minutes
|           Retention -     30.00 days
|       Num Instances -         1
|     Active Sessions -     12.00
|           Datafiles -         5
| ***************************************************

Você também pode estimar o tamanho do histórico de estatísticas (Statistics History) informando mais alguns dados:

Then you can estimate also the size of Statistics History providing some more data:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Optimizer Stat History Space Estimation
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

| To estimate the size of the Optimizer Statistics History
| we need the following values:
|
|     - Number of Tables in the Database
|     - Number of Partitions in the Database
|     - Statistics Retention Period (days)
|     - DML Activity in the Database (level)

O output será similar a este:

The output will be similar to this:

| ***************************************************
| Estimated size of Stats history             21.9 MB
|
|   The space for Optimizer Statistics history was
|   estimated using the following values:
|
|                         Tables -      88
|                        Indexes -     100
|                        Columns -     990
|                     Partitions -       0
|          Indexes on Partitions -       0
|          Columns in Partitions -       0
|        Stats Retention in Days -      31
|          Level of DML Activity -  Medium
| ***************************************************

E por fim o relatório estará pronto de acordo com o nome informado.

In the end the report will be ready according to the provided name.

Confira o relatório usado neste exemplo aqui.

Check the report used in this article here.

Espero que tenham gostado, por hoje é só.

I hope you like it, that is all for today.

Franky

O post Estimating AWR and SYSAUX size apareceu primeiro em Lore Data.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Olá pessoal, notícia rápida aqui pra contar que na semana passada meu blog foi listado pelo site Feedspot entre os Top 100 Oracle Blogs. Não faço ideia de como funciona esse ranking e nem porque o blog está nele. Tem coisas que só cabe agradecer, acho que essa é uma delas. O Blog Lore Data está na posição 64: Top 100 Oracle Blogs. A partir de agora posso usar essa medalha aqui no blog:

Hello everyone, quick news here just to tell you that last week my blog was listed by Feedspot website between the Top 100 Oracle Blogs. I have no idea how this ranking works and neither why the blog is in it. There are things that we have only to thank for and I think this is one of them. Lore Data is the 64th blog on the list: Top 100 Oracle Blogs. From now on I can use this badge here:

Abraços e até mais,

See you soon,

Franky

O post Top 100 Oracle Blogs ranking apareceu primeiro em Lore Data.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview