Neste artigo vou criar um schema de testes em meu ambiente de laboratório utilizando a ferramenta Swingbench. Na tela inicial, clicar em “Next”:
Manter a versão 2.0 e clicar em Next:
Selecionar a primeira opção e clicar em Next:
Preencher os dados de conexão e informar a senha do banco:
Preenchendo o DG que abrigará o novo datafile e clicando em Next:
Mudando o tipo de tablespace para normal:
Definindo o tamanho:
Definindo nível de paralelismo:
Processo finalizado:
Validando o ambiente:
SQL> SELECT INSTANCE_NAME,STATUS FROM GV$INSTANCE;
INSTANCE_NAME STATUS
---------------- ------------
cortex OPEN
SQL> SELECT SUM(BYTES/1024/1024/1024) FROM DBA_SEGMENTS WHERE OWNER='SOE';
SUM(BYTES/1024/1024/1024)
-------------------------
.794921875
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SOE');
PL/SQL procedure successfully completed.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@oel7 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Feb 26 06:08:35 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CORTEX (DBID=548968087)
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name CORTEX
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 910 SYSTEM YES +DG_DATA/CORTEX/DATAFILE/system.256.1039033445
3 600 SYSAUX NO +DG_DATA/CORTEX/DATAFILE/sysaux.257.1039033519
4 340 UNDOTBS1 YES +DG_DATA/CORTEX/DATAFILE/undotbs1.258.1039033555
5 824 SOE NO +DG_DATA/CORTEX/DATAFILE/soe.266.1065506205
7 5 USERS NO +DG_DATA/CORTEX/DATAFILE/users.259.1039033555
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 32 TEMP 32767 +DG_DATA/CORTEX/TEMPFILE/temp.264.1039033669
RMAN>
Portuguese
English
Spanish