Procedimento para "virar" o banco

- Drop do banco de dados atual em homologação/desenvolvimento.

Procedimento atual:

sqlplus / as sysdba
shutdown immediate
startup mount restrict
drop database;

- Inicialização do banco de dados com arquivo básico

Arquivo atual:

HOMOLOG.__db_cache_size=8120172544
HOMOLOG.__java_pool_size=134217728
HOMOLOG.__large_pool_size=16777216
HOMOLOG.__oracle_base='/u02/server/oracle'#ORACLE_BASE set from environment
HOMOLOG.__pga_aggregate_target=16290676736
HOMOLOG.__sga_target=10552868864
HOMOLOG.__shared_io_pool_size=0
HOMOLOG.__shared_pool_size=2113929216
HOMOLOG.__streams_pool_size=16777216
*.archive_lag_target=900
*.audit_file_dest='/u02/server/oracle/admin/homolog/adump'
*.audit_trail='db'
*.compatible='11.2.0.3.0'
*.control_files='/u02/homolog/controlfile/current.1185.938448053'#Set by RMAN
*.control_management_pack_access='DIAGNOSTIC'
*.db_block_size=8192
*.db_cache_size=4294967296
*.db_create_file_dest='/u02/homolog/oradata'
*.db_domain=''
*.db_flashback_retention_target=4320
*.db_name='HOMOLOG'#Reset to original value by RMAN
*.db_recovery_file_dest_size=819195805696
*.db_recovery_file_dest='/u02/homolog/recovery'
*.db_securefile='PERMITTED'
*.diagnostic_dest='/u02/server/oracle'
*.disk_asynch_io=TRUE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODUCAOXDB)'
*.filesystemio_options='SETALL'
*.java_pool_size=134217728
*.job_queue_processes=10
*.large_pool_size=16777216
*.log_archive_format='PRODUCAO_ARCH%t_%s_%r.dbf'
*.memory_max_target=26843545600
*.memory_target=26843545600
*.open_cursors=1000
*.optimizer_index_caching=80
*.optimizer_index_cost_adj=40
*.optimizer_mode='ALL_ROWS'
*.pga_aggregate_target=0
*.processes=2000
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_case_sensitive_logon=false
*.session_cached_cursors=100
*.sessions=2500
*.sga_max_size=0
*.sga_target=0
*.shared_pool_size=1073741824
*.standby_file_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.utl_file_dir='*'

- Conectar através do RMAN no ambiente de ORIGEM (target) e utilizar o banco de dados de DESTINO como auxiliar (auxiliary). Procedimento atual:

rman target sys/*********@PRODUCAO_SOURCE auxiliary sys/*********@HOMOLOG_DEST

Sendo * as senhas dos dois ambientes, que devem ser iguais.

- Executar o duplicate do RMAN para copiar os dados do target para o auxiliary.

Procedimento atual:

DUPLICATE TARGET DATABASE 
TO HOMOLOG 
FROM ACTIVE DATABASE 
LOGFILE
'/u02/homolog/logfiles/logHomolog1.ora' SIZE 2500M,
'/u02/homolog/logfiles/logHomolog2.ora' SIZE 2500M,
'/u02/homolog/logfiles/logHomolog3.ora' SIZE 2500M
DB_FILE_NAME_CONVERT '/u02/app/oracle/oradata/prod/PROD','/u02/homolog/oradata'
SPFILE
SET MEMORY_TARGET '20G'
SET AUDIT_FILE_DEST '/u02/server/oracle/admin/homolog/adump'
SET SGA_MAX_SIZE '0'
SET SGA_TARGET '0'
SET db_recovery_file_dest '/u02/homolog/recovery'
SET diagnostic_dest '/u02/server/oracle/'
SET LARGE_POOL_SIZE '16M'
set CONTROL_FILES '/u02/homolog/controlfile/homolog.ctl'
set db_create_online_log_dest_1 '/u02/homolog/logfiles'
set use_large_pages 'FALSE'
set db_create_file_dest '/u02/homolog/oradata'
set DB_RECOVERY_FILE_DEST '/u02/homolog/recovery' 
SET DB_FILE_NAME_CONVERT '/u02/app/oracle/oradata/prod/PROD','/u02/homolog/oradata'
set LOG_FILE_NAME_CONVERT 
/u03/app/oracle/fast_recovery_area','/u02/homolog/fast_recovery_area'
SET log_archive_config ''
set LOG_ARCHIVE_DEST_1 ''
SET log_archive_dest_2 ''
SET log_archive_dest '/u02/homolog/archivelog'
SET standby_archive_dest ''; 

- Executar os scripts pós backup

Procedimento atual:

create pfile from memory;;
alter system set memory_max_target=20G scope=spfile;
alter system set memory_target=20G scope=spfile;
alter system set cpu_count=0 scope=spfile;
alter system set resource_manager_cpu_allocation=0 scope=spfile;
shutdown immediate; 
startup mount;
alter database noarchivelog;
alter database open;
alter user tce_go account unlock;
alter user tce_go identified by xxxpolianaxxx;
alter user adminuser identified by 871841351291331031932042331332;
update cbd_acpesistema set codg_senha_a = '581452571081322812681032' where codg_senha_a = '451' and gerusua_id in (Select gerusua_id from ger_usuario where sys_user_name like 'LSIQUEIRA%');
commit;

- Executar reset das senhas:

Disponível em \\fileserver\unidade_l$\GER-TI\ResetSenha