Pular para o conteúdo

Como configurar e otimizar um ambiente Data Guard para operações Nologging

Carga nologging em um ambiente DATAGUARD

Primeiramente, vou explicar como configurar um ambiente Data Guard para realizarmos o teste de carga. Em seguida, daremos início à execução do teste.

A escolha pelo uso de nologging é estratégica, pois permite uma execução mais ágil, evitando a geração de archivelogs no banco primário.

Essa abordagem traz dois grandes benefícios: otimização do armazenamento em ambos os ambientes e redução do tráfego de dados entre eles. Além disso, ao minimizar a transmissão de archivelogs, evitamos concorrências indesejadas com os backups noturnos, preservando o desempenho do sistema.

Por fim, retornarei a este ambiente para redigir um artigo sobre Disaster Recovery, garantindo um conteúdo bem estruturado e impactante.

Criando ambiente DATAGUARD

Recebi um arquivo chamado 11g-nonCDB.ova, que contém o Oracle 11g (versão 11.2.0.4) com um banco de dados denominado orcl11g.

O primeiro passo é importar esse arquivo para o VirtualBox.

image 14

Click próximo

image 16

Click Finalizar

Depois que criar essa vm você terá que ir em configurações → rede → ok

Agora, para iniciar a máquina virtual, será necessário clicar duas vezes sobre ela.

O usuário será root e, no meu caso, a senha definida será senha.

Alterando o IPADDR para sua rede.

ShellScript
cd /etc/sysconfig/network-scripts/
vi ifcfg-enp0s3
IPADDR=192.168.0.242

Mudando hostname

ShellScript
hostnamectl set-hostname servidor1.localdomain

Como ficou a configuração

image 17

Alterando o nome do servidor

image 19

Atualizando /etc/hosts

ShellScript
vi /etc/hosts

cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.241   servidor1.localdomain servidor1
192.168.0.242   servidor2.localdomain servidor2

image 20

Parando o servidor para fazer um clone

ShellScript
shutdown -h now

Fazendo um clone

image 22

Próximo

image 25

Finalizar

Ligar o clone

Mudar o IP

ShellScript
cd /etc/sysconfig/network-scripts/
vi ifcfg-enp0s3
IPADDR=192.168.0.242

Mudar hostname

ShellScript
hostnamectl set-hostname servidor2.localdomain

Como ficou a configuração

image 26

reboot

Ligar o servidor1

Servidor2

Podemos apagar a base que tem lá (orcl11g), pois ainda temos no servidor1 (primary).

ShellScript
dbca -silent -deleteDatabase -sourceDB orcl11g -sysDBAUserName sys -sysDBAPassword senha

image 28

Servidor1

Vamos verificar a base para fazer um DATAGUARD (ele será Primary).

image 30

O banco está No Archive Mode.

Colocando em Archivelog

image 33

Preparando o DATAGUARD

SQL
alter system set db_create_file_dest='/u02/oradata/' scope=both sid='*';

ALTER DATABASE FORCE LOGGING;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 101 SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 102 SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 103 SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 104 SIZE 50M;

Mostrando a execução dos comandos

image 35
image 37

Importante saber:

É necessário criar N+1 standby logs em relação aos logs ativos.

Observe que há três grupos (group#) na visão V$LOG, o que significa que devem existir quatro grupos (group#) na visão V$STANDBY_LOG. Por isso, foram criados quatro grupos, garantindo a configuração adequada.

Configurando o DATAGUARD no Primary

SQL
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(ORCL11G, ORCL11GDG)'   scope=both;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl11g'     scope=both;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=orcl11gdg NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl11gdg' scope=both;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE                 scope=both;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE                 scope=both;
ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf'               scope=SPFILE;
ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=30                    scope=both;
ALTER SYSTEM SET fal_client=orcl11g                              scope=both;
ALTER SYSTEM SET FAL_SERVER=orcl11gdg                            scope=both; 
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO                    scope=both ;
ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE             scope=SPFILE;

image 39

Parando e Startando a base Primary

image 41

Configurar

listener.ora

ShellScript
[oracle@servidor1 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = servidor1.localdomain)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl11g.localdomain)
     # (GLOBAL_DBNAME = orcl_DGMGRL.localdomain)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = orcl11g)
    )
  )

ShellScript
lsnrctl start

Irá iniciar o listener no servidor Primary.

Startado o Listener no Primary

image 43

Configurando no Primary

tnsnames.ora

ShellScript
# Para Criar o standby

ORCL11G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = servidor1.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = orcl11g)
    )
  )

ORCL11GDG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = servidor2.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = orcl11g) (UR=A)
    )
  )

# Para fazer switchover

#ORCL11G =
#  (DESCRIPTION =
#    (ADDRESS = (PROTOCOL = TCP)(HOST = servidor1.localdomain)(PORT = 1521))
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME=orcl11g_DGMGRL.localdomain)(UR=A)
#    )
#  )
#
#ORCL11GDG =
#  (DESCRIPTION =
#    (ADDRESS = (PROTOCOL = TCP)(HOST = servidor2.localdomain)(PORT = 1521))
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME=orcl11gdg_DGMGRL.localdomain) (UR=A)
#    )
#  )

Servidor2

Configurando no Standby

listener.ora

ShellScript
[oracle@servidor2 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = servidor2.localdomain)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl11gdg.localdomain)
     # (GLOBAL_DBNAME = orcl11gdg_DGMGRL.localdomain)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = orcl11g)
    )
  )

ShellScript
lsnrctl start

Irá iniciar o listener no servidor Standby

image 45

tnsnames.ora

ShellScript
# Para Criar o standby

ORCL11G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = servidor1.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = orcl11g)
    )
  )

ORCL11GDG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = servidor2.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = orcl11g) (UR=A)
    )
  )

# Para fazer switchover

#ORCL11G =
#  (DESCRIPTION =
#    (ADDRESS = (PROTOCOL = TCP)(HOST = servidor1.localdomain)(PORT = 1521))
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME=orcl11g_DGMGRL.localdomain)(UR=A)
#    )
#  )
#
#ORCL11GDG =
#  (DESCRIPTION =
#    (ADDRESS = (PROTOCOL = TCP)(HOST = servidor2.localdomain)(PORT = 1521))
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME=orcl11gdg_DGMGRL.localdomain) (UR=A)
#    )
#  )

Servidor1

Copiando orapwd

ShellScript
scp $ORACLE_HOME/dbs/orapworcl11g oracle@servidor2:$ORACLE_HOME/dbs/

image 47

Servidor2

Verificando a cópia

ShellScript
ls -lrt $ORACLE_HOME/dbs/orapworcl11g

image 48

Servidor1

Criando um arquivo com copia do spfile;

ShellScript
create pfile='/home/oracle/sp-dataguard.txt' from spfile;

Verificar todos os diretórios que existem no arquivo, pois terá que criar os diretórios no servidor2.

ShellScript
*.audit_file_dest='/u01/app/oracle/admin/orcl11g/adump'
*.db_create_file_dest='/u02/oradata/'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.diagnostic_dest='/u01/app/oracle'

lsnrctl reload

Servidor2

Criando os diretórios.

ShellScript
mkdir -p /u01/app/oracle/fast_recovery_area
mkdir -p /u01/app/oracle/admin/orcl11g/adump

image 49

Criando um spfile apenas com db_name.

ShellScript
mkdir /home/oracle/dg
cd /home/oracle/dg
vi /home/oracle/dg/pfile_standby.ora
*.db_name='orcl11g'

Startando a base Standby no estado nomount.

Iniciando o ambiente para a criação do standby.

Neste momento, ele deve ser iniciado no modo NOMOUNT, pois os controfiles ainda não existem.

ShellScript
sqlplus / as sysdba
startup nomount pfile=’/home/oracle/dg/pfile_standby.ora’

image 51
ShellScript
lsnrctl reload

Criando um Script para criar o Dataguard.

ShellScript
cd /home/oracle/dg
vi duplica.sh

[oracle@servidor2 dg]$ cat duplica.sh
#!/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_BASE='/u01/app/oracle'
export ORACLE_BACKUP_TYPE=Dataguard
export ORACLE_DB_NAME=orcl11g
export RMAN_LOGFILE=/home/oracle/dg/logdataguard${ORACLE_BACKUP_TYPE}-`date +"%d-%m-%Y_%H.%M"`.log
export ORACLE_SID=orcl11g
$ORACLE_HOME/bin/rman <<FIM
        spool log to '${RMAN_LOGFILE}' append ;
        connect target sys/senha@orcl11g
        connect  auxiliary  sys/senha@orcl11gdg
#        CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
        set echo on;
        run {
               DUPLICATE TARGET DATABASE
               FOR STANDBY
               FROM ACTIVE DATABASE
                DORECOVER
                SPFILE
                    SET DB_UNIQUE_NAME='orcl11gdg'
                    SET log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCL11GDG'
                   # SET log_archive_dest_2='';
                    SET FAL_SERVER='ORCL11G'
                    SET FAL_CLIENT='ORCL11GDG'
                    SET DB_FILE_NAME_CONVERT ='ORCL11G','ORCL11GDG'
                    SET LOG_FILE_NAME_CONVERT='ORCL11G','ORCL11GDG'
                NOFILENAMECHECK;
        }

spool log off
FIM
sqlplus / as sysdba <<FIM
alter system set  log_archive_dest_2='SERVICE=ORCL11G NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCL11G' scope=spfile sid='*';
shutdown immediate
startup mount
FIM

chmod 755 duplica.sh

Teste tnsping nos 2 servidores

Servidor1

ShellScript
tnsping orcl11g
tnsping orcl11gd

Servidor2

ShellScript
tnsping orcl11g
tnsping orcl11gd

Mostrando a execução do tnsping

image 52
image 55

Tudo ok para duplicar

ShellScript
sh duplica.sh

Execução do script que criar o DATAGUARD.

image 57

No diretório /home/oracle/dg, você encontrará um arquivo de log essencial para análise, permitindo verificar se a configuração do Data Guard foi concluída com êxito ou se houve alguma falha durante o processo.

Ao final deste texto, disponibilizamos o log para sua consulta.

Se nenhum erro for identificado, significa que o Data Guard foi implementado com sucesso!

Servidor2

ShellScript
vi /etc/oratab
orcl11g:/u01/app/oracle/product/11.2.0/dbhome_1:N

Verificando os parâmetros no Servidor2 (Standby).

ShellScript
SHOW PARAMETER log_archive_config
SHOW PARAMETER log_archive_dest_1
SHOW PARAMETER log_archive_dest_2
SHOW PARAMETER  LOG_ARCHIVE_DEST_STATE_1
SHOW PARAMETER  LOG_ARCHIVE_DEST_STATE_2
SHOW PARAMETER  LOG_ARCHIVE_FORMAT
SHOW PARAMETER  LOG_ARCHIVE_MAX_PROCESSES
SHOW PARAMETER FAL_SERVER
SHOW PARAMETER FAL_CLIENT
SHOW PARAMETER FILE_NAME_CONVERT
SHOW PARAMETER STANDBY_FILE_MANAGEMENT
SHOW PARAMETER  REMOTE_LOGIN_PASSWORDFILE

Mostrando os valores dos parâmetros no Standby (servidor2)

image 58
image 61
image 63

Alguns comandos

SQL
select name, open_mode, database_role, instance_name from v$database,v$instance;

select process,status,sequence#,thread# from v$managed_standby where process like ‘MRP%’;

Para parar a replicação

SQL
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Para ativar a replicação

SQL
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

image 65

Usando os comandos

image 67

O Oracle Data Guard está configurado com sucesso, garantindo alta disponibilidade e recuperação de desastres para o ambiente. Embora o Active Data Guard exija uma licença adicional para a funcionalidade READ ONLY WITH APPLY, a solução implementada permite a aplicação contínua dos archivelogs no modo mount.

Se necessário, a replicação pode ser pausada para abrir o banco em modo read only, fornecendo relatórios baseados no momento da interrupção. Após a análise, basta reiniciar a replicação em  modo mount para garantir a continuidade da proteção dos dados.

Com isso, o Data Guard está operacional e pronto para garantir a segurança e integridade do ambiente!

Vamos para a Carga Nologging.

Ao lidar com uma carga massiva ou a exclusão de milhões de linhas em um ambiente com Data Guard, é essencial considerar o impacto na geração de archivelogs. Esse processo pode resultar em um grande volume de logs no banco primário, que serão transmitidos para o standby, aumentando o tempo de execução e exigindo espaço de armazenamento disponível.

Para mitigar esses desafios, realizei uma simulação em um ambiente de teste otimizado, garantindo que a operação ocorresse de forma eficiente, sem a geração excessiva de archivelogs. Essa abordagem permite validar o procedimento e minimizar impactos no ambiente de produção, assegurando um processamento mais ágil e seguro.

Para evitar a geração de archivelogs, é necessário que o banco esteja configurado no modo no force logging desativado e que a tabela esteja com a opção nologging habilitada.

Dessa forma, as operações de carga ou exclusão massiva de dados ocorrem de maneira otimizada, reduzindo o impacto no ambiente e minimizando o consumo de armazenamento. Essa estratégia garante maior eficiência no processamento sem comprometer a integridade do banco de dados principal e seu standby.

Servidor1 (Primary)

image 68

Servidor2 (Standby).

Fique atento na proxíma tela e às observações destacadas. Elas contêm informações essenciais para a correta execução do processo, garantindo que todas as etapas sejam realizadas de forma segura e eficiente.

image 71

Vamos deixar em modo mount e replicando.

Situação atual

Servidor1 (Primary)

image 73

Servidor2 (Standby)

SQL
select process,status,sequence#,thread#
from v$managed_standby
where process like ‘MRP%’;

image 74

Tudo funcionando!

Servidor1 (Primary)

Criando uma tablespace.

SQL
create tablespace ts_dados_nologging datafile size 10m autoextend on next 1m maxsize unlimited;

Primary

image 76

Utilizei os comandos abaixo para acelerar a replicação dos archivelogs, garantindo que a sincronização entre o banco primário e o standby ocorra de forma ágil e eficiente.

SQL
alter system switch logfile;
alter system checkpoint;

image 78

No Standby

image 79

ESSE É O PONTO MAIS IMPORTANTE PARA FUNCIONAR A CARGA NOLOGGING.

Neste momento, ambas as bases ainda estão configuradas com force logging. Para realizar a carga de forma eficiente, é necessário seguir os passos essenciais:

1️⃣ Configurar as duas bases para no force logging;
2️⃣ Garantir que o banco standby permaneça no modo mount durante o processo;
3️⃣ Executar a carga no banco primary.

Comandos para aplicação:

🔹 No Primary:

SQL
ALTER DATABASE NO FORCE LOGGING;

🔹 No Standby:

SQL
ALTER DATABASE NO FORCE LOGGING;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE CLOSE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

🔹 No Primary:

SQL
 insert /*+ APPEND*/ into HR.t1 select * from all_objects;
 commit;

Após a execução do commit, a replicação do Data Guard foi interrompida!

Com isso, o ambiente standby não está mais sincronizado com o primary.

SQL
col name format a60
set linesize 200
SELECT d.FILE#,d.NAME, d.UNRECOVERABLE_CHANGE#,f.tablespace_name
FROM V$DATAFILE d,dba_Data_files f
where d.file#=f.file_id;

image 82

Fazendo um backup usando Begin backup e End backup.

image 84

Primary

SQL
alter table DADOS_NOLOGGING begin backup;
!cp /u02/oradata/orcl11g/datafile/o1_mf_dados_no_mx253hnb_.dbf  /home/oracle
alter table DADOS_NOLOGGING end backup;

Standby

O select abaixo, pode ser executando quando o banco está em mount.

SQL
select a.name,b.name from v$datafile a,v$tablespace b where a.ts#=b.ts#;

image 86
ShellScript
Shutdown immediate

Faça um backup do datafile no standby.

ShellScript
cd /u02/oradata/ORCL11GDG/datafile/
cp o1_mf_dados_no_mx254oh9_.dbf  o1_mf_dados_no_mx254oh9_.dbf.bkp

Esse backup é por segurança, pois iremos sobreescrever o datafile o1_mf_dados_no_mx254oh9_.dbf.

Standby

Verificar a quantidade de linhas da tabela hr.t1;

image 87

Atualmente, a tabela está vazia, pois os dados não foram replicados devido à configuração nologging e ao force logging desabilitado(no force logging). Nosso objetivo agora é reativar o Data Guard, garantindo que o banco standby volte a estar sincronizado com o primary.

Para isso, precisamos alinhar as configurações entre as duas bases, garantindo a integridade e a continuidade da replicação. Vamos executar os ajustes necessários para restaurar o funcionamento do Data Guard!

🔹 No Primary:

Agora, vamos copiar o arquivo de backup realizado no primary utilizando BEGIN BACKUP e END BACKUP para o standby, garantindo que ele mantenha exatamente o mesmo nome. O objetivo é sobrescrevê-lo no standby sem qualquer alteração no nome do arquivo, preservando a consistência entre as bases. Esse passo é essencial para restaurar a replicação do Data Guard com segurança e precisão.

image 90
ShellScript
scp arquivo_backup_servidor1 oracle@servidor2:nome_do_arquivo_servidor2

scp /home/oracle/o1_mf_dados_no_mx253hnb_.dbf oracle@servidor2:/u02/oradata/ORCL11GDG/datafile/o1_mf_dados_no_mx254oh9_.dbf

Standby

Verificando novamente a quantidade de linhas da tabela hr.t1;

image 92

Mesma quantidade do Primary!

A cópia direta do datafile do backup, transferida do primary para o standby, foi realizada com total sucesso! Embora a replicação dos dados não tenha ocorrido via archivelogs, o processo se mostrou extremamente eficiente e ágil, assegurando a sincronização do ambiente sem a sobrecarga habitual da replicação tradicional.

O que precisamos fazer agora?

SQL
alter table hr.t1 logging;
alter database force logging;

Faça um backup incremental 0!

No meu ambiente de teste, não realizei esse procedimento, pois trata-se de um ambiente simples, com poucas tabelas. No entanto, para o ambiente de produção, recomendo que, antes de desativar o force logging (ALTER DATABASE NO FORCE LOGGING;), sejam feitas todas as alterações necessárias para garantir a integridade da replicação.

✅ Para ajustar tabelas:

SQL
select 'alter table '||owner||'.'||table_name||' logging;' from dba_tables  
where logging='NO';

✅ Para ajustar índices:

SQL
select 'alter INDEX '||owner||'.'||INDEX_name|| ' logging;' from dba_indexes
where LOGGING='NO';

Verificando Se funcionou

image 94

LOG gerado pelo duplica.sh

ShellScript
[oracle@servidor2 dg]$ cat logdataguardDataguard-12-03-2025_01.16.log

Spooling started in log file: /home/oracle/dg/logdataguardDataguard-12-03-2025_01.16.log

Recovery Manager11.2.0.4.0

RMAN>
connected to target database: ORCL11G (DBID=1297266466)

RMAN>
connected to auxiliary database: ORCL11G (not mounted)

RMAN> 2>
echo set on


RMAN>         run {
2>                DUPLICATE TARGET DATABASE
3>                FOR STANDBY
4>                FROM ACTIVE DATABASE
5>                 DORECOVER
6>                 SPFILE
7>                     SET DB_UNIQUE_NAME='orcl11gdg'
8>                     SET log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCL11GDG'
9>                    # SET log_archive_dest_2='';
10>                     SET FAL_SERVER='ORCL11G'
11>                     SET FAL_CLIENT='ORCL11GDG'
12>                     SET DB_FILE_NAME_CONVERT ='ORCL11G','ORCL11GDG'
13>                     SET LOG_FILE_NAME_CONVERT='ORCL11G','ORCL11GDG'
14>                 NOFILENAMECHECK;
15>         }
Starting Duplicate Db at 12-MAR-25
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=171 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=10 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=172 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=11 device type=DISK
allocated channel: ORA_AUX_DISK_5
channel ORA_AUX_DISK_5: SID=173 device type=DISK
allocated channel: ORA_AUX_DISK_6
channel ORA_AUX_DISK_6: SID=12 device type=DISK
allocated channel: ORA_AUX_DISK_7
channel ORA_AUX_DISK_7: SID=174 device type=DISK
allocated channel: ORA_AUX_DISK_8
channel ORA_AUX_DISK_8: SID=13 device type=DISK

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl11g' auxiliary format
 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl11g'   targetfile
 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl11g.ora' auxiliary format
 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl11g.ora'   ;
   sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl11g.ora''";
}
executing Memory Script

Starting backup at 12-MAR-25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=175 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=47 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=176 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=51 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=172 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=48 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=171 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=42 device type=DISK
Finished backup at 12-MAR-25

sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl11g.ora''

contents of Memory Script:
{
   sql clone "alter system set  db_unique_name =
 ''orcl11gdg'' comment=
 '''' scope=spfile";
   sql clone "alter system set  log_archive_dest_1 =
 ''LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCL11GDG'' comment=
 '''' scope=spfile";
   sql clone "alter system set  FAL_SERVER =
 ''ORCL11G'' comment=
 '''' scope=spfile";
   sql clone "alter system set  FAL_CLIENT =
 ''ORCL11GDG'' comment=
 '''' scope=spfile";
   sql clone "alter system set  db_file_name_convert =
 ''ORCL11G'', ''ORCL11GDG'' comment=
 '''' scope=spfile";
   sql clone "alter system set  LOG_FILE_NAME_CONVERT =
 ''ORCL11G'', ''ORCL11GDG'' comment=
 '''' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_unique_name =  ''orcl11gdg'' comment= '''' scope=spfile

sql statement: alter system set  log_archive_dest_1 =  ''LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCL11GDG'' comment= '''' scope=spfile

sql statement: alter system set  FAL_SERVER =  ''ORCL11G'' comment= '''' scope=spfile

sql statement: alter system set  FAL_CLIENT =  ''ORCL11GDG'' comment= '''' scope=spfile

sql statement: alter system set  db_file_name_convert =  ''ORCL11G'', ''ORCL11GDG'' comment= '''' scope=spfile

sql statement: alter system set  LOG_FILE_NAME_CONVERT =  ''ORCL11G'', ''ORCL11GDG'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    1536602112 bytes

Fixed Size                     2253504 bytes
Variable Size               1124076864 bytes
Database Buffers             402653184 bytes
Redo Buffers                   7618560 bytes

contents of Memory Script:
{
   backup as copy current controlfile for standby auxiliary format  '/u02/oradata/orcl11g/control01.ctl';
   restore clone controlfile to  '/u01/app/oracle/fast_recovery_area/orcl11g/control02.ctl' from
 '/u02/oradata/orcl11g/control01.ctl';
}
executing Memory Script

Starting backup at 12-MAR-25
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl11g.f tag=TAG20250312T011655 RECID=7 STAMP=1195521416
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 12-MAR-25

Starting restore at 12-MAR-25
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=133 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=10 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=135 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=11 device type=DISK
allocated channel: ORA_AUX_DISK_5
channel ORA_AUX_DISK_5: SID=136 device type=DISK
allocated channel: ORA_AUX_DISK_6
channel ORA_AUX_DISK_6: SID=12 device type=DISK
allocated channel: ORA_AUX_DISK_7
channel ORA_AUX_DISK_7: SID=137 device type=DISK
allocated channel: ORA_AUX_DISK_8
channel ORA_AUX_DISK_8: SID=13 device type=DISK

channel ORA_AUX_DISK_2: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_3: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_4: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_5: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_6: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_7: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_8: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 12-MAR-25

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database
Using previous duplicated file /u02/oradata/orcl11g/system01.dbf for datafile 1 with checkpoint SCN of 1012562
Using previous duplicated file /u02/oradata/orcl11g/sysaux01.dbf for datafile 2 with checkpoint SCN of 1012567
Using previous duplicated file /u02/oradata/orcl11g/undotbs01.dbf for datafile 3 with checkpoint SCN of 1012569
Using previous duplicated file /u02/oradata/orcl11g/users01.dbf for datafile 4 with checkpoint SCN of 1012571
Using previous duplicated file /u02/oradata/orcl11g/example01.dbf for datafile 5 with checkpoint SCN of 1012567

contents of Memory Script:
{
   set newname for tempfile  1 to
 "/u02/oradata/orcl11g/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to
 "/u02/oradata/orcl11g/system01.dbf";
   set newname for datafile  2 to
 "/u02/oradata/orcl11g/sysaux01.dbf";
   set newname for datafile  3 to
 "/u02/oradata/orcl11g/undotbs01.dbf";
   set newname for datafile  4 to
 "/u02/oradata/orcl11g/users01.dbf";
   set newname for datafile  5 to
 "/u02/oradata/orcl11g/example01.dbf";
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u02/oradata/orcl11g/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

sql statement: alter system archive log current

contents of Memory Script:
{
   backup as copy reuse
   archivelog like  "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_33_mx1yzgm6_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_33_%u_.arc"   archivelog like
 "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_39_mx227o7o_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_39_%u_.arc"   archivelog like
 "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_38_mx20x1x0_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_38_%u_.arc"   archivelog like
 "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_32_mx1ytg8z_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_32_%u_.arc"   archivelog like
 "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_37_mx20vxsf_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_37_%u_.arc"   archivelog like
 "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_35_mx20878o_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_35_%u_.arc"   archivelog like
 "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_36_mx20d3bs_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_36_%u_.arc"   archivelog like
 "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_34_mx2083tv_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_34_%u_.arc"   archivelog like
 "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_40_mx228pnl_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_40_%u_.arc"   archivelog like
 "/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2025_03_12/o1_mf_1_41_mx22pcox_.arc" auxiliary format
 "/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_41_%u_.arc"   ;
   catalog clone recovery area;
   catalog clone datafilecopy  "/u02/oradata/orcl11g/system01.dbf",
 "/u02/oradata/orcl11g/sysaux01.dbf",
 "/u02/oradata/orcl11g/undotbs01.dbf",
 "/u02/oradata/orcl11g/users01.dbf",
 "/u02/oradata/orcl11g/example01.dbf";
   switch clone datafile  1 to datafilecopy
 "/u02/oradata/orcl11g/system01.dbf";
   switch clone datafile  2 to datafilecopy
 "/u02/oradata/orcl11g/sysaux01.dbf";
   switch clone datafile  3 to datafilecopy
 "/u02/oradata/orcl11g/undotbs01.dbf";
   switch clone datafile  4 to datafilecopy
 "/u02/oradata/orcl11g/users01.dbf";
   switch clone datafile  5 to datafilecopy
 "/u02/oradata/orcl11g/example01.dbf";
}
executing Memory Script

Starting backup at 12-MAR-25
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=33 RECID=44 STAMP=1195517630
channel ORA_DISK_2: starting archived log copy
input archived log thread=1 sequence=39 RECID=53 STAMP=1195520965
channel ORA_DISK_3: starting archived log copy
input archived log thread=1 sequence=38 RECID=51 STAMP=1195519601
channel ORA_DISK_4: starting archived log copy
input archived log thread=1 sequence=32 RECID=42 STAMP=1195517470
channel ORA_DISK_5: starting archived log copy
input archived log thread=1 sequence=37 RECID=49 STAMP=1195519565
channel ORA_DISK_6: starting archived log copy
input archived log thread=1 sequence=35 RECID=47 STAMP=1195518935
channel ORA_DISK_7: starting archived log copy
input archived log thread=1 sequence=36 RECID=48 STAMP=1195519059
channel ORA_DISK_8: starting archived log copy
input archived log thread=1 sequence=34 RECID=46 STAMP=1195518931
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_33_0t3k4dcs_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:00
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=40 RECID=54 STAMP=1195520998
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_39_0u3k4dcs_.arc RECID=0 STAMP=0
channel ORA_DISK_2: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_2: starting archived log copy
input archived log thread=1 sequence=41 RECID=57 STAMP=1195521435
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_38_0v3k4dcs_.arc RECID=0 STAMP=0
channel ORA_DISK_3: archived log copy complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_32_103k4dcs_.arc RECID=0 STAMP=0
channel ORA_DISK_4: archived log copy complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_37_113k4dcs_.arc RECID=0 STAMP=0
channel ORA_DISK_5: archived log copy complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_35_123k4dcs_.arc RECID=0 STAMP=0
channel ORA_DISK_6: archived log copy complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_36_133k4dcs_.arc RECID=0 STAMP=0
channel ORA_DISK_7: archived log copy complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_40_153k4dct_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:00
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_41_163k4dct_.arc RECID=0 STAMP=0
channel ORA_DISK_2: archived log copy complete, elapsed time: 00:00:00
output file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_34_143k4dcs_.arc RECID=0 STAMP=0
channel ORA_DISK_8: archived log copy complete, elapsed time: 00:00:01
Finished backup at 12-MAR-25

searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_10/o1_mf_1_9_073k1ibh_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_10/o1_mf_1_10_083k1ibh_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_10/o1_mf_1_11_mwz7xgnv_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_12_0f3k1llk_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_13_0g3k1llk_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_14_mwzc0g5q_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_18_mx1t0fl4_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_19_mx1t0fpj_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_17_mx1t0fr3_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_16_mx1t0fsm_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_15_mx1t0g54_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_20_mx1t0hwp_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_21_mx1vsqnh_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_22_mx1vssd6_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_23_mx1x27hc_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_24_mx1x28vp_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_25_mx1x2bmy_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_32_mx1yzdbb_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_33_mx1z017t_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_37_mx20x070_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_38_mx20xmxd_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_39_mx228qrt_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_40_mx228r5y_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_33_0t3k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_39_0u3k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_38_0v3k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_32_103k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_37_113k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_35_123k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_36_133k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_34_143k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_40_153k4dct_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_41_163k4dct_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_101_mwz7o9vk_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_102_mwz7ofjx_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_103_mwz7ok8y_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_104_mwz7onxy_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_104_mx1yzhdz_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_101_mx1yzhfj_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_102_mx1yzv8v_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_103_mx1z01gy_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_104_mx20x30g_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_101_mx20x35x_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_102_mx20xggb_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_103_mx20xmyq_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_101_mx228rfx_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_104_mx228rm8_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_102_mx2293w6_.log
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_103_mx2299h5_.log
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_10/o1_mf_1_9_073k1ibh_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_10/o1_mf_1_10_083k1ibh_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_10/o1_mf_1_11_mwz7xgnv_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_12_0f3k1llk_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_13_0g3k1llk_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_14_mwzc0g5q_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_18_mx1t0fl4_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_19_mx1t0fpj_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_17_mx1t0fr3_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_16_mx1t0fsm_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_15_mx1t0g54_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_20_mx1t0hwp_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_21_mx1vsqnh_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_22_mx1vssd6_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_23_mx1x27hc_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_24_mx1x28vp_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_11/o1_mf_1_25_mx1x2bmy_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_32_mx1yzdbb_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_33_mx1z017t_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_37_mx20x070_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_38_mx20xmxd_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_39_mx228qrt_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_40_mx228r5y_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_33_0t3k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_39_0u3k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_38_0v3k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_32_103k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_37_113k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_35_123k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_36_133k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_34_143k4dcs_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_40_153k4dct_.arc
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_41_163k4dct_.arc

List of Files Which Where Not Cataloged
=======================================
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_101_mwz7o9vk_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_102_mwz7ofjx_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_103_mwz7ok8y_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_104_mwz7onxy_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_104_mx1yzhdz_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_101_mx1yzhfj_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_102_mx1yzv8v_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_103_mx1z01gy_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_104_mx20x30g_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_101_mx20x35x_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_102_mx20xggb_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_103_mx20xmyq_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_101_mx228rfx_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_104_mx228rm8_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_102_mx2293w6_.log
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: /u01/app/oracle/fast_recovery_area/ORCL11GDG/onlinelog/o1_mf_103_mx2299h5_.log
  RMAN-07529: Reason: catalog is not supported for this file type

cataloged datafile copy
datafile copy file name=/u02/oradata/orcl11g/system01.dbf RECID=7 STAMP=1195521441
cataloged datafile copy
datafile copy file name=/u02/oradata/orcl11g/sysaux01.dbf RECID=8 STAMP=1195521441
cataloged datafile copy
datafile copy file name=/u02/oradata/orcl11g/undotbs01.dbf RECID=9 STAMP=1195521442
cataloged datafile copy
datafile copy file name=/u02/oradata/orcl11g/users01.dbf RECID=10 STAMP=1195521442
cataloged datafile copy
datafile copy file name=/u02/oradata/orcl11g/example01.dbf RECID=11 STAMP=1195521442

datafile 1 switched to datafile copy
input datafile copy RECID=7 STAMP=1195521441 file name=/u02/oradata/orcl11g/system01.dbf

datafile 2 switched to datafile copy
input datafile copy RECID=8 STAMP=1195521441 file name=/u02/oradata/orcl11g/sysaux01.dbf

datafile 3 switched to datafile copy
input datafile copy RECID=9 STAMP=1195521442 file name=/u02/oradata/orcl11g/undotbs01.dbf

datafile 4 switched to datafile copy
input datafile copy RECID=10 STAMP=1195521442 file name=/u02/oradata/orcl11g/users01.dbf

datafile 5 switched to datafile copy
input datafile copy RECID=11 STAMP=1195521442 file name=/u02/oradata/orcl11g/example01.dbf

contents of Memory Script:
{
   set until scn  1017510;
   recover
   standby
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 12-MAR-25
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
using channel ORA_AUX_DISK_3
using channel ORA_AUX_DISK_4
using channel ORA_AUX_DISK_5
using channel ORA_AUX_DISK_6
using channel ORA_AUX_DISK_7
using channel ORA_AUX_DISK_8

starting media recovery

archived log for thread 1 with sequence 32 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_32_103k4dcs_.arc
archived log for thread 1 with sequence 33 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_33_mx1z017t_.arc
archived log for thread 1 with sequence 34 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_34_143k4dcs_.arc
archived log for thread 1 with sequence 35 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_35_123k4dcs_.arc
archived log for thread 1 with sequence 36 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_36_133k4dcs_.arc
archived log for thread 1 with sequence 37 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_37_113k4dcs_.arc
archived log for thread 1 with sequence 38 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_38_0v3k4dcs_.arc
archived log for thread 1 with sequence 39 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_39_0u3k4dcs_.arc
archived log for thread 1 with sequence 40 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_40_153k4dct_.arc
archived log for thread 1 with sequence 41 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_41_163k4dct_.arc
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_32_103k4dcs_.arc thread=1 sequence=32
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_33_mx1z017t_.arc thread=1 sequence=33
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_34_143k4dcs_.arc thread=1 sequence=34
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_35_123k4dcs_.arc thread=1 sequence=35
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_36_133k4dcs_.arc thread=1 sequence=36
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_37_113k4dcs_.arc thread=1 sequence=37
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_38_0v3k4dcs_.arc thread=1 sequence=38
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_39_0u3k4dcs_.arc thread=1 sequence=39
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_40_153k4dct_.arc thread=1 sequence=40
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11GDG/archivelog/2025_03_12/o1_mf_1_41_163k4dct_.arc thread=1 sequence=41
media recovery complete, elapsed time: 00:00:11
Finished recover at 12-MAR-25
Finished Duplicate Db at 12-MAR-25


RMAN>

RMAN> spool log off
[oracle@servidor2 dg]$

José Eskinazi

José Eskinazi

oca 10g, ocp 10g, ocp 11g e ocp19c

Prestigie o autor e deixe o seu comentário:

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Marcações:
plugins premium WordPress