Alterando o local do banco de dados com SWITCH DATAFILE TO COPY

A vantagem deste método é que não há a fase de RESTORE, que deixaria o banco de dados indisponível por um bom tempo.

Você meio que fala “Banco, passe a usar o Backup como se fosse o Banco…”, mas o backup precisa ser do tipo COPY.

Aí então é só fazer o RECOVER, e o tempo será proporcional à quantidade de ARCHIVED REDO LOGs gerados desde o início do BACKUP.

Também podem ser utilizadas as variáveis de FORMAT no nome dos DATAFILEs, o que poupa o trabalho (e risco) de fazer um monte de SET NEWNAME.

Este método também pode ser utilizado com ASM, para troca de Disk Groups, ou troca de ASM para Filesystem, ou vice-versa.

[oracle@Baltazar ~]$ rlwrap rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Tue May 8 10:33:09 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1502087631)

RMAN> BACKUP AS COPY DATABASE FORMAT '/u01/oradata/ORCL/%N_%f.dbf';

Starting backup at 08/05/2018 10:37:19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1168 CASTELOice type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00045 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wt_.dbf
output file name=/u01/oradata/ORCL/DADOS_45.dbf tag=TAG20180508T103720 RECID=4 STAMP=975580744
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00043 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_undotbs1_fg9vq9wq_.dbf
output file name=/u01/oradata/ORCL/UNDOTBS1_43.dbf tag=TAG20180508T103720 RECID=5 STAMP=975580842
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00046 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wv_.dbf
output file name=/u01/oradata/ORCL/DADOS_46.dbf tag=TAG20180508T103720 RECID=6 STAMP=975580948
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00048 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wx_.dbf
output file name=/u01/oradata/ORCL/DADOS_48.dbf tag=TAG20180508T103720 RECID=7 STAMP=975581054
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00047 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9ww_.dbf
output file name=/u01/oradata/ORCL/DADOS_47.dbf tag=TAG20180508T103720 RECID=8 STAMP=975581160
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00050 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9x0_.dbf
output file name=/u01/oradata/ORCL/DADOS_50.dbf tag=TAG20180508T103720 RECID=9 STAMP=975581266
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00049 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wz_.dbf
output file name=/u01/oradata/ORCL/DADOS_49.dbf tag=TAG20180508T103720 RECID=10 STAMP=975581372
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00051 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x1_.dbf
output file name=/u01/oradata/ORCL/INDICES_51.dbf tag=TAG20180508T103720 RECID=11 STAMP=975581432
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00052 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x2_.dbf
output file name=/u01/oradata/ORCL/INDICES_52.dbf tag=TAG20180508T103720 RECID=12 STAMP=975581489
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00053 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x3_.dbf
output file name=/u01/oradata/ORCL/INDICES_53.dbf tag=TAG20180508T103720 RECID=13 STAMP=975581541
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00055 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x6_.dbf
output file name=/u01/oradata/ORCL/INDICES_55.dbf tag=TAG20180508T103720 RECID=14 STAMP=975581586
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00054 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x5_.dbf
output file name=/u01/oradata/ORCL/INDICES_54.dbf tag=TAG20180508T103720 RECID=15 STAMP=975581629
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00056 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x7_.dbf
output file name=/u01/oradata/ORCL/INDICES_56.dbf tag=TAG20180508T103720 RECID=16 STAMP=975581675
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00060 name=/u01/oradata/ORCL/datafile/o1_mf_soe_fgsg9qyv_.dbf
output file name=/u01/oradata/ORCL/SOE_60.dbf tag=TAG20180508T103720 RECID=17 STAMP=975581716
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u03/oradata/ORCL/datafile/o1_mf_sysaux_fg8n536j_.dbf
output file name=/u01/oradata/ORCL/SYSAUX_3.dbf tag=TAG20180508T103720 RECID=18 STAMP=975581732
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u03/oradata/ORCL/datafile/o1_mf_system_fg8n535t_.dbf
output file name=/u01/oradata/ORCL/SYSTEM_1.dbf tag=TAG20180508T103720 RECID=19 STAMP=975581747
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00059 name=/u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_undotbs1_fgsbnvw0_.dbf
output file name=/u01/oradata/ORCL/UNDOTBS1_59.dbf tag=TAG20180508T103720 RECID=20 STAMP=975581767
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00042 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_sysaux_fg9vq9wp_.dbf
output file name=/u01/oradata/ORCL/SYSAUX_42.dbf tag=TAG20180508T103720 RECID=21 STAMP=975581776
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00058 name=/u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_sysaux_fgsbnvvy_.dbf
output file name=/u01/oradata/ORCL/SYSAUX_58.dbf tag=TAG20180508T103720 RECID=22 STAMP=975581792
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_sysaux_fg8joz7s_.dbf
output file name=/u01/oradata/ORCL/SYSAUX_6.dbf tag=TAG20180508T103720 RECID=23 STAMP=975581803
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00041 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_system_fg9vq9wn_.dbf
output file name=/u01/oradata/ORCL/SYSTEM_41.dbf tag=TAG20180508T103720 RECID=24 STAMP=975581810
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00057 name=/u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_system_fgsbnvtr_.dbf
output file name=/u01/oradata/ORCL/SYSTEM_57.dbf tag=TAG20180508T103720 RECID=25 STAMP=975581817
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_system_fg8joz8k_.dbf
output file name=/u01/oradata/ORCL/SYSTEM_5.dbf tag=TAG20180508T103720 RECID=26 STAMP=975581824
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u03/oradata/ORCL/datafile/o1_mf_undotbs1_fg8n5371_.dbf
output file name=/u01/oradata/ORCL/UNDOTBS1_4.dbf tag=TAG20180508T103720 RECID=27 STAMP=975581830
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_undotbs1_fg8joz92_.dbf
output file name=/u01/oradata/ORCL/UNDOTBS1_8.dbf tag=TAG20180508T103720 RECID=28 STAMP=975581832
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00044 name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_users_fg9vq9ws_.dbf
output file name=/u01/oradata/ORCL/USERS_44.dbf tag=TAG20180508T103720 RECID=29 STAMP=975581835
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u03/oradata/ORCL/datafile/o1_mf_users_fg8n5376_.dbf
output file name=/u01/oradata/ORCL/USERS_7.dbf tag=TAG20180508T103720 RECID=30 STAMP=975581837
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 08/05/2018 10:57:18

Starting Control File and SPFILE Autobackup at 08/05/2018 10:57:18
piece handle=/u01/FRA/ORCL/autobackup/2018_05_08/o1_mf_s_975581838_fh3c60l1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 08/05/2018 10:57:21

RMAN> SHUTDOWN IMMEDIATE;

database closed
database dismounted
Oracle instance shut down

RMAN> STARTUP MOUNT;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area   10737418240 bytes

Fixed Size                     8804088 bytes
Variable Size               1979713800 bytes
Database Buffers            8724152320 bytes
Redo Buffers                  24748032 bytes

RMAN> SWITCH DATABASE TO COPY;

datafile 1 switched to datafile copy "/u01/oradata/ORCL/SYSTEM_1.dbf"
datafile 3 switched to datafile copy "/u01/oradata/ORCL/SYSAUX_3.dbf"
datafile 4 switched to datafile copy "/u01/oradata/ORCL/UNDOTBS1_4.dbf"
datafile 5 switched to datafile copy "/u01/oradata/ORCL/SYSTEM_5.dbf"
datafile 6 switched to datafile copy "/u01/oradata/ORCL/SYSAUX_6.dbf"
datafile 7 switched to datafile copy "/u01/oradata/ORCL/USERS_7.dbf"
datafile 8 switched to datafile copy "/u01/oradata/ORCL/UNDOTBS1_8.dbf"
datafile 41 switched to datafile copy "/u01/oradata/ORCL/SYSTEM_41.dbf"
datafile 42 switched to datafile copy "/u01/oradata/ORCL/SYSAUX_42.dbf"
datafile 43 switched to datafile copy "/u01/oradata/ORCL/UNDOTBS1_43.dbf"
datafile 44 switched to datafile copy "/u01/oradata/ORCL/USERS_44.dbf"
datafile 45 switched to datafile copy "/u01/oradata/ORCL/DADOS_45.dbf"
datafile 46 switched to datafile copy "/u01/oradata/ORCL/DADOS_46.dbf"
datafile 47 switched to datafile copy "/u01/oradata/ORCL/DADOS_47.dbf"
datafile 48 switched to datafile copy "/u01/oradata/ORCL/DADOS_48.dbf"
datafile 49 switched to datafile copy "/u01/oradata/ORCL/DADOS_49.dbf"
datafile 50 switched to datafile copy "/u01/oradata/ORCL/DADOS_50.dbf"
datafile 51 switched to datafile copy "/u01/oradata/ORCL/INDICES_51.dbf"
datafile 52 switched to datafile copy "/u01/oradata/ORCL/INDICES_52.dbf"
datafile 53 switched to datafile copy "/u01/oradata/ORCL/INDICES_53.dbf"
datafile 54 switched to datafile copy "/u01/oradata/ORCL/INDICES_54.dbf"
datafile 55 switched to datafile copy "/u01/oradata/ORCL/INDICES_55.dbf"
datafile 56 switched to datafile copy "/u01/oradata/ORCL/INDICES_56.dbf"
datafile 57 switched to datafile copy "/u01/oradata/ORCL/SYSTEM_57.dbf"
datafile 58 switched to datafile copy "/u01/oradata/ORCL/SYSAUX_58.dbf"
datafile 59 switched to datafile copy "/u01/oradata/ORCL/UNDOTBS1_59.dbf"
datafile 60 switched to datafile copy "/u01/oradata/ORCL/SOE_60.dbf"

RMAN> RECOVER DATABASE;

Starting recover at 08/05/2018 11:08:38
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=771 CASTELOice type=DISK

starting media recovery
media recovery complete, elapsed time: 00:00:10

Finished recover at 08/05/2018 11:08:50

RMAN> ALTER DATABASE OPEN;

Statement processed

RMAN> REPORT SCHEMA;

Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    830      SYSTEM               YES     /u01/oradata/ORCL/SYSTEM_1.dbf
3    880      SYSAUX               NO      /u01/oradata/ORCL/SYSAUX_3.dbf
4    210      UNDOTBS1             YES     /u01/oradata/ORCL/UNDOTBS1_4.dbf
5    250      PDB$SEED:SYSTEM      NO      /u01/oradata/ORCL/SYSTEM_5.dbf
6    410      PDB$SEED:SYSAUX      NO      /u01/oradata/ORCL/SYSAUX_6.dbf
7    5        USERS                NO      /u01/oradata/ORCL/USERS_7.dbf
8    100      PDB$SEED:UNDOTBS1    NO      /u01/oradata/ORCL/UNDOTBS1_8.dbf
41   390      CASTELO:SYSTEM       NO      /u01/oradata/ORCL/SYSTEM_41.dbf
42   660      CASTELO:SYSAUX       NO      /u01/oradata/ORCL/SYSAUX_42.dbf
43   12820    CASTELO:UNDOTBS1     NO      /u01/oradata/ORCL/UNDOTBS1_43.dbf
44   100      CASTELO:USERS        NO      /u01/oradata/ORCL/USERS_44.dbf
45   13824    CASTELO:DADOS        NO      /u01/oradata/ORCL/DADOS_45.dbf
46   12624    CASTELO:DADOS        NO      /u01/oradata/ORCL/DADOS_46.dbf
47   12424    CASTELO:DADOS        NO      /u01/oradata/ORCL/DADOS_47.dbf
48   12624    CASTELO:DADOS        NO      /u01/oradata/ORCL/DADOS_48.dbf
49   12124    CASTELO:DADOS        NO      /u01/oradata/ORCL/DADOS_49.dbf
50   12324    CASTELO:DADOS        NO      /u01/oradata/ORCL/DADOS_50.dbf
51   6624     CASTELO:INDICES      NO      /u01/oradata/ORCL/INDICES_51.dbf
52   5524     CASTELO:INDICES      NO      /u01/oradata/ORCL/INDICES_52.dbf
53   5124     CASTELO:INDICES      NO      /u01/oradata/ORCL/INDICES_53.dbf
54   4924     CASTELO:INDICES      NO      /u01/oradata/ORCL/INDICES_54.dbf
55   5124     CASTELO:INDICES      NO      /u01/oradata/ORCL/INDICES_55.dbf
56   4924     CASTELO:INDICES      NO      /u01/oradata/ORCL/INDICES_56.dbf
57   270      PROD:SYSTEM          YES     /u01/oradata/ORCL/SYSTEM_57.dbf
58   510      PROD:SYSAUX          NO      /u01/oradata/ORCL/SYSAUX_58.dbf
59   705      PROD:UNDOTBS1        YES     /u01/oradata/ORCL/UNDOTBS1_59.dbf
60   2100     PROD:SOE             NO      /u01/oradata/ORCL/SOE_60.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u03/oradata/ORCL/datafile/o1_mf_temp_fg8q49j8_.tmp
2    64       PDB$SEED:TEMP        32767       /u03/oradata/ORCL/datafile/temp012018-04-24_16-49-07-722-PM.dbf
3    64       PROD:TEMP            32767       /u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_temp_fgsbnvw1_.dbf
5    2969     CASTELO:TEMP         32767       /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_temp_fg9vq9wr_.dbf

RMAN>

E os DATAFILEs que antes faziam parte do banco de dados? Eles ainda estão onde estavam antes, mas agora eles que são BACKUPs COPY, que podem ser removidos.

RMAN> LIST COPY;

using target database control file instead of recovery catalog
specification does not match any control file copy in the repository
List of Datafile Copies
=======================

Key     File S Completion Time     Ckp SCN    Ckp Time            Sparse
------- ---- - ------------------- ---------- ------------------- ------
31      1    A 08/05/2018 11:08:31 6926590    08/05/2018 11:07:49 NO
        Name: /u03/oradata/ORCL/datafile/o1_mf_system_fg8n535t_.dbf

32      3    A 08/05/2018 11:08:31 6926590    08/05/2018 11:07:49 NO
        Name: /u03/oradata/ORCL/datafile/o1_mf_sysaux_fg8n536j_.dbf

33      4    A 08/05/2018 11:08:32 6926590    08/05/2018 11:07:49 NO
        Name: /u03/oradata/ORCL/datafile/o1_mf_undotbs1_fg8n5371_.dbf

34      5    A 08/05/2018 11:08:32 3670618    26/04/2018 10:47:01 NO
        Name: /u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_system_fg8joz8k_.dbf
        Container ID: 2, PDB Name: PDB$SEED

35      6    A 08/05/2018 11:08:32 3670618    26/04/2018 10:47:01 NO
        Name: /u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_sysaux_fg8joz7s_.dbf
        Container ID: 2, PDB Name: PDB$SEED

36      7    A 08/05/2018 11:08:32 6926590    08/05/2018 11:07:49 NO
        Name: /u03/oradata/ORCL/datafile/o1_mf_users_fg8n5376_.dbf

37      8    A 08/05/2018 11:08:32 3670618    26/04/2018 10:47:01 NO
        Name: /u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_undotbs1_fg8joz92_.dbf
        Container ID: 2, PDB Name: PDB$SEED

38      41   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_system_fg9vq9wn_.dbf
        Container ID: 5, PDB Name: CASTELO

39      42   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_sysaux_fg9vq9wp_.dbf
        Container ID: 5, PDB Name: CASTELO

40      43   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_undotbs1_fg9vq9wq_.dbf
        Container ID: 5, PDB Name: CASTELO

41      44   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_users_fg9vq9ws_.dbf
        Container ID: 5, PDB Name: CASTELO

42      45   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wt_.dbf
        Container ID: 5, PDB Name: CASTELO

43      46   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wv_.dbf
        Container ID: 5, PDB Name: CASTELO

44      47   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9ww_.dbf
        Container ID: 5, PDB Name: CASTELO

45      48   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wx_.dbf
        Container ID: 5, PDB Name: CASTELO

46      49   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wz_.dbf
        Container ID: 5, PDB Name: CASTELO

47      50   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9x0_.dbf
        Container ID: 5, PDB Name: CASTELO

48      51   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x1_.dbf
        Container ID: 5, PDB Name: CASTELO

49      52   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x2_.dbf
        Container ID: 5, PDB Name: CASTELO

50      53   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x3_.dbf
        Container ID: 5, PDB Name: CASTELO

51      54   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x5_.dbf
        Container ID: 5, PDB Name: CASTELO

52      55   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x6_.dbf
        Container ID: 5, PDB Name: CASTELO

53      56   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x7_.dbf
        Container ID: 5, PDB Name: CASTELO

54      57   A 08/05/2018 11:08:34 6926185    08/05/2018 11:07:46 NO
        Name: /u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_system_fgsbnvtr_.dbf
        Container ID: 3, PDB Name: PROD

55      58   A 08/05/2018 11:08:34 6926185    08/05/2018 11:07:46 NO
        Name: /u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_sysaux_fgsbnvvy_.dbf
        Container ID: 3, PDB Name: PROD

56      59   A 08/05/2018 11:08:34 6926185    08/05/2018 11:07:46 NO
        Name: /u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_undotbs1_fgsbnvw0_.dbf
        Container ID: 3, PDB Name: PROD

57      60   A 08/05/2018 11:08:34 6926185    08/05/2018 11:07:46 NO
        Name: /u01/oradata/ORCL/datafile/o1_mf_soe_fgsg9qyv_.dbf
        Container ID: 3, PDB Name: PROD

List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - -------------------
273     1    113     A 02/05/2018 08:07:01
        Name: /u01/FRA/ORCL/archivelog/2018_05_04/o1_mf_1_113_fgs836dk_.arc

274     1    114     A 04/05/2018 15:03:18
        Name: /u01/FRA/ORCL/archivelog/2018_05_04/o1_mf_1_114_fgscddcb_.arc

275     1    115     A 04/05/2018 15:59:24
        Name: /u01/FRA/ORCL/archivelog/2018_05_04/o1_mf_1_115_fgskj9ms_.arc

276     1    116     A 04/05/2018 17:43:53
        Name: /u01/FRA/ORCL/archivelog/2018_05_04/o1_mf_1_116_fgskwdoj_.arc

277     1    117     A 04/05/2018 17:50:20
        Name: /u01/FRA/ORCL/archivelog/2018_05_06/o1_mf_1_117_fgxbzj5m_.arc


RMAN> DELETE COPY OF DATABASE;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=771 device type=DISK
List of Datafile Copies
=======================

Key     File S Completion Time     Ckp SCN    Ckp Time            Sparse
------- ---- - ------------------- ---------- ------------------- ------
31      1    A 08/05/2018 11:08:31 6926590    08/05/2018 11:07:49 NO
        Name: /u03/oradata/ORCL/datafile/o1_mf_system_fg8n535t_.dbf

32      3    A 08/05/2018 11:08:31 6926590    08/05/2018 11:07:49 NO
        Name: /u03/oradata/ORCL/datafile/o1_mf_sysaux_fg8n536j_.dbf

33      4    A 08/05/2018 11:08:32 6926590    08/05/2018 11:07:49 NO
        Name: /u03/oradata/ORCL/datafile/o1_mf_undotbs1_fg8n5371_.dbf

34      5    A 08/05/2018 11:08:32 3670618    26/04/2018 10:47:01 NO
        Name: /u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_system_fg8joz8k_.dbf
        Container ID: 2, PDB Name: PDB$SEED

35      6    A 08/05/2018 11:08:32 3670618    26/04/2018 10:47:01 NO
        Name: /u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_sysaux_fg8joz7s_.dbf
        Container ID: 2, PDB Name: PDB$SEED

36      7    A 08/05/2018 11:08:32 6926590    08/05/2018 11:07:49 NO
        Name: /u03/oradata/ORCL/datafile/o1_mf_users_fg8n5376_.dbf

37      8    A 08/05/2018 11:08:32 3670618    26/04/2018 10:47:01 NO
        Name: /u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_undotbs1_fg8joz92_.dbf
        Container ID: 2, PDB Name: PDB$SEED

38      41   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_system_fg9vq9wn_.dbf
        Container ID: 5, PDB Name: CASTELO

39      42   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_sysaux_fg9vq9wp_.dbf
        Container ID: 5, PDB Name: CASTELO

40      43   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_undotbs1_fg9vq9wq_.dbf
        Container ID: 5, PDB Name: CASTELO

41      44   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_users_fg9vq9ws_.dbf
        Container ID: 5, PDB Name: CASTELO

42      45   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wt_.dbf
        Container ID: 5, PDB Name: CASTELO

43      46   A 08/05/2018 11:08:32 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wv_.dbf
        Container ID: 5, PDB Name: CASTELO

44      47   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9ww_.dbf
        Container ID: 5, PDB Name: CASTELO

45      48   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wx_.dbf
        Container ID: 5, PDB Name: CASTELO

46      49   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wz_.dbf
        Container ID: 5, PDB Name: CASTELO

47      50   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9x0_.dbf
        Container ID: 5, PDB Name: CASTELO

48      51   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x1_.dbf
        Container ID: 5, PDB Name: CASTELO

49      52   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x2_.dbf
        Container ID: 5, PDB Name: CASTELO

50      53   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x3_.dbf
        Container ID: 5, PDB Name: CASTELO

51      54   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x5_.dbf
        Container ID: 5, PDB Name: CASTELO

52      55   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x6_.dbf
        Container ID: 5, PDB Name: CASTELO

53      56   A 08/05/2018 11:08:33 6926186    08/05/2018 11:07:46 NO
        Name: /u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x7_.dbf
        Container ID: 5, PDB Name: CASTELO

54      57   A 08/05/2018 11:08:34 6926185    08/05/2018 11:07:46 NO
        Name: /u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_system_fgsbnvtr_.dbf
        Container ID: 3, PDB Name: PROD

55      58   A 08/05/2018 11:08:34 6926185    08/05/2018 11:07:46 NO
        Name: /u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_sysaux_fgsbnvvy_.dbf
        Container ID: 3, PDB Name: PROD

56      59   A 08/05/2018 11:08:34 6926185    08/05/2018 11:07:46 NO
        Name: /u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_undotbs1_fgsbnvw0_.dbf
        Container ID: 3, PDB Name: PROD

57      60   A 08/05/2018 11:08:34 6926185    08/05/2018 11:07:46 NO
        Name: /u01/oradata/ORCL/datafile/o1_mf_soe_fgsg9qyv_.dbf
        Container ID: 3, PDB Name: PROD


Do you really want to delete the above objects (enter YES or NO)? YES
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/datafile/o1_mf_system_fg8n535t_.dbf RECID=31 STAMP=975582511
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/datafile/o1_mf_sysaux_fg8n536j_.dbf RECID=32 STAMP=975582511
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/datafile/o1_mf_undotbs1_fg8n5371_.dbf RECID=33 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_system_fg8joz8k_.dbf RECID=34 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_sysaux_fg8joz7s_.dbf RECID=35 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/datafile/o1_mf_users_fg8n5376_.dbf RECID=36 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6A9E728C97044869E053020FA8C0D7DF/datafile/o1_mf_undotbs1_fg8joz92_.dbf RECID=37 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_system_fg9vq9wn_.dbf RECID=38 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_sysaux_fg9vq9wp_.dbf RECID=39 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_undotbs1_fg9vq9wq_.dbf RECID=40 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_users_fg9vq9ws_.dbf RECID=41 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wt_.dbf RECID=42 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wv_.dbf RECID=43 STAMP=975582512
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9ww_.dbf RECID=44 STAMP=975582513
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wx_.dbf RECID=45 STAMP=975582513
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9wz_.dbf RECID=46 STAMP=975582513
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_dados_fg9vq9x0_.dbf RECID=47 STAMP=975582513
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x1_.dbf RECID=48 STAMP=975582513
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x2_.dbf RECID=49 STAMP=975582513
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x3_.dbf RECID=50 STAMP=975582513
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x5_.dbf RECID=51 STAMP=975582513
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x6_.dbf RECID=52 STAMP=975582513
deleted datafile copy
datafile copy file name=/u03/oradata/ORCL/6AF0BE73B3D678C9E053020FA8C04D36/datafile/o1_mf_indices_fg9vq9x7_.dbf RECID=53 STAMP=975582513
deleted datafile copy
datafile copy file name=/u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_system_fgsbnvtr_.dbf RECID=54 STAMP=975582514
deleted datafile copy
datafile copy file name=/u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_sysaux_fgsbnvvy_.dbf RECID=55 STAMP=975582514
deleted datafile copy
datafile copy file name=/u01/oradata/ORCL/6B66BE3E66E05EABE053020FA8C0C836/datafile/o1_mf_undotbs1_fgsbnvw0_.dbf RECID=56 STAMP=975582514
deleted datafile copy
datafile copy file name=/u01/oradata/ORCL/datafile/o1_mf_soe_fgsg9qyv_.dbf RECID=57 STAMP=975582514
Deleted 27 objects


RMAN>

Leave a Reply

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