{"id":15,"date":"2023-07-18T11:01:00","date_gmt":"2023-07-18T11:01:00","guid":{"rendered":"https:\/\/oracleconraul.wordpress.com\/?p=10"},"modified":"2023-07-20T15:54:26","modified_gmt":"2023-07-20T15:54:26","slug":"restore-table-with-rman","status":"publish","type":"post","link":"https:\/\/oracleconraul.com\/index.php\/2023\/07\/18\/restore-table-with-rman\/","title":{"rendered":"Restaurar una tabla con RMAN"},"content":{"rendered":"\n

En la versi\u00f3n 12c, se introdujeron muchas y muy \u00fatiles nuevas funcionalidades. Entre ellas, la posibilidad de recuperar una tabla con RMAN. Esta caracter\u00edstica se aplica tanto a arquitecturas Multitenant como no Multitenant, permiti\u00e9ndote recuperar una tabla de una PDB si ese fuera el caso.

En el siguiente enlace podemos encontrar la nota oficial:<\/p>\n\n\n\n

RMAN Recover Table Feature in Oracle Database 12c and Higher (Doc ID 1521524.1)<\/strong><\/p>\n\n\n\n

En este ejemplo de prueba vamos a recuperar una tabla creada en el esquema raul de la PDB \u201cORCLPDB1\u201d dentro de la base de datos, cuya CDB es \u201cORCLCDB\u201d<\/p>\n\n\n\n

SQL> show con_name
CON_NAME
\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014
ORCLPDB1<\/p>\n\n\n\n

SQL> show con_id
CON_ID
\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014
3<\/p>\n\n\n\n

Para ello, vamos a crear una tabla simple, e insertamos 5 valores:<\/p>\n\n\n\n

SQL> create table uno (dni number);
Table created.
SQL>insert into uno values (1);
SQL>insert into uno values (2);
SQL>insert into uno values (3);
SQL>insert into uno values (4);
SQL>insert into uno values (5);
SQL> commit;<\/p>\n\n\n\n


SQL>  select * from uno
       DNI
\u2014\u2014\u2014\u2014\u2013
1
2
3
4
5<\/p>\n\n\n\n

Realizamos el backup de la base de datos con el que recuperaremos la tabla posteriormente.<\/p>\n\n\n\n

Conectados a la CDB, realizaremos un backup completo de la base de datos y los archives:<\/p>\n\n\n\n

[oracle@oracle21c ~]$ rman
Recovery Manager: Release 19.0.0.0.0 \u2013 Production on Thu Nov 3 17:43:08 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.
RMAN> connect target \/
connected to target database: ORCLCDB (DBID=2778750799)
RMAN> backup database plus archivelog;<\/strong>
Starting backup at 2022-11-03:17:43:30
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=293 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=19 RECID=1 STAMP=1104223655t
.
.
input archived log thread=1 sequence=26 RECID=8 STAMP=1119807810
channel ORA_DISK_1: starting piece 1 at 2022-11-03:17:43:31
channel ORA_DISK_1: finished piece 1 at 2022-11-03:17:43:34
.
.
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=\/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb1\/sysaux01.dbf
input datafile file number=00012 name=\/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb1\/users01.dbf
.
.
channel ORA_DISK_1: starting piece 1 at 2022-11-03:17:44:11
channel ORA_DISK_1: finished piece 1 at 2022-11-03:17:44:12
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCLCDB\/backupset\/2022_11_03\/o1_mf_annnn_TAG20221103T174411_kp7zhcyq_.bkp tag=TAG20221103T174411 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2022-11-03:17:44:12
Starting Control File and SPFILE Autobackup at 2022-11-03:17:44:13
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCLCDB\/autobackup\/2022_11_03\/o1_mf_s_1119807853_kp7zhfc2_.bkp comment=NONE
.
Finished Control File and SPFILE Autobackup at 2022-11-03:17:44:14
RMAN><\/p>\n\n\n\n

Para verificar que hemos realizado correctamente la copia de nuestra base de datos (PDB) y del tablespace donde tenemos albergada nuestra tabla, en nuestro caso ORCLPDB1:USERS<\/strong>, podemos ejecutar el comando \u00abreport schema\u00bb.<\/p>\n\n\n\n

RMAN> connect target \/
connected to target database: ORCLCDB (DBID=2778750799)
using target database control file instead of recovery catalog
RMAN>
RMAN> report schema;

Report of database schema for database with db_unique_name ORCLCDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
\u2014- \u2014\u2014\u2013 \u2014\u2014\u2014\u2014\u2014\u2014\u2013 \u2014\u2014- \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014
1    920      SYSTEM               YES     \/u01\/app\/oracle\/oradata\/ORCLCDB\/system01.dbf
3    850      SYSAUX               NO      \/u01\/app\/oracle\/oradata\/ORCLCDB\/sysaux01.dbf
4    330      UNDOTBS1             YES     \/u01\/app\/oracle\/oradata\/ORCLCDB\/undotbs01.dbf
5    270      PDB$SEED:SYSTEM      NO      \/u01\/app\/oracle\/oradata\/ORCLCDB\/pdbseed\/system01.dbf
6    330      PDB$SEED:SYSAUX      NO      \/u01\/app\/oracle\/oradata\/ORCLCDB\/pdbseed\/sysaux01.dbf
7    5        USERS                NO      \/u01\/app\/oracle\/oradata\/ORCLCDB\/users01.dbf
8    100      PDB$SEED:UNDOTBS1    NO      \/u01\/app\/oracle\/oradata\/ORCLCDB\/pdbseed\/undotbs01.dbf
9    280      ORCLPDB1:SYSTEM      YES     \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb1\/system01.dbf
10   370      ORCLPDB1:SYSAUX      NO      \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb1\/sysaux01.dbf
11   100      ORCLPDB1:UNDOTBS1    YES     \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb1\/undotbs01.dbf
12   342      ORCLPDB1:USERS       NO      \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb1\/users01.dbf<\/strong>
13   280      ORCLPDB2:SYSTEM      YES     \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb2\/system01.dbf
14   370      ORCLPDB2:SYSAUX      NO      \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb2\/sysaux01.dbf
15   100      ORCLPDB2:UNDOTBS1    YES     \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb2\/undotbs01.dbf
16   342      ORCLPDB2:USERS       NO      \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb2\/users01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
\u2014- \u2014\u2014\u2013 \u2014\u2014\u2014\u2014\u2014\u2014\u2013 \u2014\u2014\u2014\u2013 \u2014\u2014\u2014\u2014\u2014\u2014\u2013
1    131      TEMP                 32767       \/u01\/app\/oracle\/oradata\/ORCLCDB\/temp01.dbf
2    36       PDB$SEED:TEMP        32767       \/u01\/app\/oracle\/oradata\/ORCLCDB\/pdbseed\/temp012019-05-08_01-48-43-006-AM.dbf
3    36       ORCLPDB1:TEMP        32767       \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb1\/temp01.dbf
4    36       ORCLPDB2:TEMP        32767       \/u01\/app\/oracle\/oradata\/ORCLCDB\/orclpdb2\/temp01.dbf<\/p>\n\n\n\n

<\/p>\n\n\n\n

Recuperaci\u00f3n de la tabla.<\/strong><\/p>\n\n\n\n

Es bastante importante definir un formato de fecha, especialmente en RMAN a la hora de recuperar la tabla, ya que este ser\u00e1 el formato que usar\u00e1 la herramienta para recuperar la tabla.

En este ejemplo vamos a realizar el borrado de la tabla para luego recuperarla.<\/p>\n\n\n\n

SQL> alter session set nls_date_format = \u2018dd\/mm\/yyyy hh24:mi:ss\u2019;
Session altered.

SQL> select sysdate from dual;
SYSDATE
\u2014\u2014\u2014\u2014-
03\/11\/2022 22:14:14

SQL> drop table uno;<\/p>\n\n\n\n

Lanzamos el restore. Ejecutamos el script recover_table.bck, donde se indica que queremos restaurar la tabla UNO justo a la fecha y hora antes del borrado de la tabla. Como se puede observar, lo que hace RMAN una vez restaurado el backup de RMAN, es exportar e importar a trav\u00e9s de un import los datos de la tabla borrada.<\/p>\n\n\n\n

RMAN> connect target \/
connected to target database: ORCLCDB (DBID=2778750799)
RMAN> @recover_table.bck<\/strong>
RMAN> run{<\/strong>
2> recover table \u00abRAUL\u00bb.\u00bbUNO\u00bb OF PLUGGABLE DATABASE ORCLPDB1<\/strong>
3> until time \u00abto_date(\u201903\/11\/2022 22:14:14\u2032,\u2019dd\/mm\/yyyy hh24:mi:ss\u2019)\u00bb<\/strong>
4> AUXILIARY DESTINATION \u2018\/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\u2019;<\/strong>
5> }<\/strong>
Starting recover at 2022-11-03:23:10:23
using target database control file instead of recovery catalog
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=303 device type=DISK
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace ORCLPDB1:SYSTEM
Tablespace UNDOTBS1
db_name=ORCLCDB
db_unique_name=wdum_pitr_ORCLPDB1_ORCLCDB
compatible=19.0.0
db_create_file_dest=\/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE
log_archive_dest_1=\u2019location=\/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\u2019
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance ORCLCDB
Oracle instance started
contents of Memory Script:
{
# set requested point in time
set until  time \u00abto_date(\u201903\/11\/2022 22:14:14\u2032,\u2019dd\/mm\/yyyy hh24:mi:ss\u2019)\u00bb;
# restore the controlfile
channel ORA_AUX_DISK_1: reading from backup piece \/u01\/app\/oracle\/fast_recovery_area\/ORCLCDB\/autobackup\/2022_11_03\/o1_mf_s_1119807853_kp7zhfc2_.bkp
channel ORA_AUX_DISK_1: reading from backup piece \/u01\/app\/oracle\/fast_recovery_area\/ORCLCDB\/autobackup\/2022_11_03\/o1_mf_s_1119807853_kp7zhfc2_.bkp
.
.
channel ORA_AUX_DISK_1: piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCLCDB\/autobackup\/2022_11_03\/o1_mf_s_1119807853_kp7zhfc2_.bkp tag=TAG20221103T174413
.
.
{
# set requested point in time
set until  time \u00abto_date(\u201903\/11\/2022 22:14:14\u2032,\u2019dd\/mm\/yyyy hh24:mi:ss\u2019)\u00bb;
# set destinations for recovery set and auxiliary set datafiles
.
.
set newname for clone tempfile  3 to new;
# switch all tempfiles
switch clone tempfile all;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile  1, 9, 4, 11, 3, 10;
switch clone datafile all;
}
executing Memory Script
.
.
renamed tempfile 1 to \/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\/ORCLCDB\/datafile\/o1_mf_temp_%u_.tmp in control file
renamed tempfile 3 to \/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\/ORCLCDB\/8857B36632797E5CE0536210ED0ADAC7\/datafile\/o1_mf_temp_%u_.tmp in control file
Starting restore at 2022-11-03:23:10:48

using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to \/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\/ORCLCDB\/datafile\/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to \/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\/ORCLCDB\/datafile\/o1_mf_undotbs1_%u_.dbf
.
.
channel ORA_AUX_DISK_1: restoring datafile 00010 to \/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\/ORCLCDB\/8857B36632797E5CE0536210ED0ADAC7\/datafile\/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece
\/u01\/app\/oracle\/fast_recovery_area\/ORCLCDB\/8857B36632797E5CE0536210ED0ADAC7\/backupset\/2022_11_03\/o1_mf_nnndf_TAG20221103T174334_kp7zgp9h_.bkp
channel ORA_AUX_DISK_1: piece
handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCLCDB\/8857B36632797E5CE0536210ED0ADAC7\/backupset\/2022_11_03\/o1_mf_nnndf_TAG20221103T174334_kp7zgp9h_.bkp
tag=TAG20221103T174334
channel ORA_AUX_DISK_1: restored backup piece 1
.
.
contents of Memory Script:
{
# set requested point in time
.
.
# recover and open database read only
recover clone database tablespace  \u00abSYSTEM\u00bb, \u00abORCLPDB1\u2033:\u00bbSYSTEM\u00bb, \u00abUNDOTBS1\u00bb, \u00abORCLPDB1\u2033:\u00bbUNDOTBS1\u00bb, \u00abSYSAUX\u00bb, \u00abORCLPDB1\u2033:\u00bbSYSAUX\u00bb;
sql clone \u2018alter database open read only\u2019;
}
executing Memory Script
executing command: SET until clause
.
.
using channel ORA_AUX_DISK_1
starting media recovery
.
.
media recovery complete, elapsed time: 00:00:04
Finished recover at 2022-11-03:23:11:17
sql statement: alter database open read only
contents of Memory Script:
{
sql clone \u2018alter pluggable database  ORCLPDB1 open read only\u2019;
}
executing Memory Script
sql statement: alter pluggable database  ORCLPDB1 open read only
contents of Memory Script:
{
sql clone \u00abcreate spfile from memory\u00bb;
shutdown clone immediate;
startup clone nomount;
.
.
shutdown clone immediate;
 startup clone nomount;
# mount database
sql clone \u2018alter database mount clone database\u2019;
}
executing Memory Script
sql statement: create spfile from memory
database closed
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
.
.
# set requested point in time
set until  time \u00abto_date(\u201903\/11\/2022 22:14:14\u2032,\u2019dd\/mm\/yyyy hh24:mi:ss\u2019)\u00bb;
.
:
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
Starting restore at 2022-11-03:23:12:30
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=182 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
.
.
.
set until  time \u00abto_date(\u201903\/11\/2022 22:14:14\u2032,\u2019dd\/mm\/yyyy hh24:mi:ss\u2019)\u00bb;
# online the datafiles restored or switched
sql clone \u2018ORCLPDB1\u2019 \u00abalter database datafile
 12 online\u00bb;
# recover and open resetlogs
recover clone database tablespace  \u00abORCLPDB1\u2033:\u00bbUSERS\u00bb, \u00abSYSTEM\u00bb, \u00abORCLPDB1\u2033:\u00bbSYSTEM\u00bb, \u00abUNDOTBS1\u00bb, \u00abORCLPDB1\u2033:\u00bbUNDOTBS1\u00bb, \u00abSYSAUX\u00bb, \u00abORCLPDB1\u2033:\u00bbSYSAUX\u00bb delete
archivelog;
alter clone database open resetlogs;
}
executing Memory Script
executing command: SET until clause
sql statement: alter database datafile  12 online
Starting recover at 2022-11-03:23:12:34
using channel ORA_AUX_DISK_1
starting media recovery
.
.
archived log file name=\/u01\/app\/oracle\/fast_recovery_area\/ORCLCDB\/archivelog\/2022_11_03\/o1_mf_1_27_kp7zhcqx_.arc thread=1 sequence=27
archived log file name=\/u01\/app\/oracle\/fast_recovery_area\/ORCLCDB\/archivelog\/2022_11_03\/o1_mf_1_28_kp8llzrd_.arc thread=1 sequence=28
media recovery complete, elapsed time: 00:00:01
Finished recover at 2022-11-03:23:12:36
database opened
contents of Memory Script:
{
sql clone \u2018alter pluggable database  ORCLPDB1 open\u2019;
}
executing Memory Script
sql statement: alter pluggable database  ORCLPDB1 open
contents of Memory Script:
{
# create directory for datapump import
sql \u2018ORCLPDB1\u2019 \u00abcreate or replace directory
TSPITR_DIROBJ_DPDIR as \u00bb
\/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\u00bb\u00bb;
# create directory for datapump export
sql clone \u2018ORCLPDB1\u2019 \u00abcreate or replace directory
TSPITR_DIROBJ_DPDIR as \u00bb
\/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\u00bb\u00bb;
}
executing Memory Script
sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as \u00bb\/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\u00bb
sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as \u00bb\/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\u00bb
Performing export of tables\u2026
   EXPDP<\/strong>> Starting \u00abSYS\u00bb.\u00bbTSPITR_EXP_wdum_ssEn\u00bb: 
   EXPDP> Processing object type TABLE_EXPORT\/TABLE\/TABLE_DATA
   EXPDP> Processing object type TABLE_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS
EXPDP> Processing object type TABLE_EXPORT\/TABLE\/STATISTICS\/MARKER
EXPDP> Processing object type TABLE_EXPORT\/TABLE\/TABLE
EXPDP> . . exported \u00abRAUL\u00bb.\u00bbUNO\u00bb                                5.078 KB       5 rows<\/strong>
EXPDP> Master table \u00abSYS\u00bb.\u00bbTSPITR_EXP_wdum_ssEn\u00bb successfully loaded\/unloaded
  EXPDP> ******************************************************************************
   EXPDP> Dump file set for SYS.TSPITR_EXP_wdum_ssEn is:
   EXPDP>   \/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\/tspitr_wdum_34186.dmp
Export completed
contents of Memory Script:
{
# shutdown clone before import
shutdown clone abort
}
executing Memory Script
Oracle instance shut down
Performing import of tables\u2026
IMPDP<\/strong>> Master table \u00abSYS\u00bb.\u00bbTSPITR_IMP_wdum_sDFr\u00bb successfully loaded\/unloaded
IMPDP><\/strong> Starting \u00abSYS\u00bb.\u00bbTSPITR_IMP_wdum_sDFr\u00bb: 
IMPDP> Processing object type TABLE_EXPORT\/TABLE\/TABLE
IMPDP> Processing object type TABLE_EXPORT\/TABLE\/TABLE_DATA
IMPDP> . . imported \u00abRAUL\u00bb.\u00bbUNO\u00bb                                5.078 KB       5 rows<\/strong>
IMPDP> Processing object type TABLE_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS
MPDP> Job \u00abSYS\u00bb.\u00bbTSPITR_IMP_wdum_sDFr\u00bb successfully completed at Thu Nov 3 23:14:00 2022 elapsed 0 00:00:27
import completed
Removing automatic instance
auxiliary instance file \/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\/ORCLCDB\/8857B36632797E5CE0536210ED0ADAC7\/datafile\/o1_mf_undotbs1_kp8ln8dn_.dbf deleted
auxiliary instance file \/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\/ORCLCDB\/datafile\/o1_mf_undotbs1_kp8lmsb6_.dbf deleted
Finished recover at 2022-11-03:23:14:04
<\/p>\n\n\n\n

 <\/p>\n\n\n\n

<\/p>\n\n\n\n

Comprobamos que la tabla ha sido restaurada:<\/p>\n\n\n\n

oracle@oracle21c ~]$ sqlplus raul\/***@ORCLPDB1
SQL*Plus: Release 19.0.0.0.0 \u2013 Production on Thu Nov 3 23:26:37 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Last Successful login time: Thu Nov 03 2022 22:26:01 +00:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 \u2013 Production
Version 19.3.0.0.0
SQL> SELECT * FROM UNO;
DNI
\u2014\u2014-
1
2
3
4
5<\/p>\n\n\n\n

RESTAURAR LA TABLA CON OTRO NOMBRE DIFERENTE<\/strong><\/p>\n\n\n\n

Existe otra opci\u00f3n muy \u00fatil para restaurar la tabla borrada, es restaurarla con otro nombre o \u201cremap\u201d de tabla.<\/p>\n\n\n\n

RMAN> connect target \/
connected to target database: ORCLCDB (DBID=2778750799)
RMAN> @recover_table_remap.bck<\/strong>
RMAN> run{<\/strong>
2> recover table \u00abRAUL\u00bb.\u00bbUNO\u00bb OF PLUGGABLE DATABASE ORCLPDB1<\/strong>
3> until time \u00abto_date(\u201903\/11\/2022 22:14:14\u2032,\u2019dd\/mm\/yyyy hh24:mi:ss\u2019)\u00bb<\/strong>
4> AUXILIARY DESTINATION \u2018\/u01\/app\/oracle\/oradata\/ORCLCDBRESTORE\u2019<\/strong>
5> REMAP TABLE \u00abRAUL\u00bb.\u00bbUNO\u00bb:\u00bbRAUL\u00bb.\u00bbUNORESTORE\u00bb;<\/strong>
6> }<\/strong>
Starting recover at 2022-11-03:23:40:08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=293 device type=DISK
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace ORCLPDB1:SYSTEM
{
sql clone \u2018alter database mount clone database\u2019;
# archive current online log
sql \u2018alter system archive log current\u2019;
}
executing Memory Script
executing command: SET until clause
Starting restore at 2022-11-03:23:40:26
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=4 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 2022-11-03:23:40:51

datafile 1 switched to datafile copy
{
.
.
Finished restore at 2022-11-03:23:42:17
Performing export of tables\u2026
Oracle instance shut down
Performing import of tables\u2026
IMPDP> Master table \u00abSYS\u00bb.\u00bbTSPITR_IMP_elEq_vqzl\u00bb successfully loaded\/unloaded
IMPDP> Starting \u00abSYS\u00bb.\u00bbTSPITR_IMP_elEq_vqzl\u00bb: 
IMPDP> . . imported \u00abRAUL\u00bb.\u00bbUNORESTORE\u00bb                         5.078 KB       5 rows<\/strong>
.
.
Import completed<\/p>\n\n\n\n

  <\/p>\n\n\n\n

\n\n\n\n

En resumen con esta nueva funcionalidad, evitamos crear una base de datos auxiliary o dummy, exportar la tabla e importarla en la base de datos operativa y luego borrar la base de datos restaurada para este fin. Con este comando, todos los pasos que antiguamente realiz\u00e1bamos a mano, se pueden realizar de forma autom\u00e1tica.<\/p>\n","protected":false},"excerpt":{"rendered":"

En la versi\u00f3n 12c, se introdujeron muchas y muy \u00fatiles nuevas funcionalidades. Entre ellas, la posibilidad de recuperar una tabla con RMAN. Esta caracter\u00edstica se aplica tanto a arquitecturas Multitenant como no Multitenant, permiti\u00e9ndote recuperar una tabla de una PDB si ese fuera el caso. En el siguiente enlace podemos encontrar la nota oficial: RMAN<\/p>\n

\n\t\t\t\t Read More <\/span> <\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"wpupg_custom_link":[],"wpupg_custom_link_behaviour":[],"wpupg_custom_link_nofollow":[],"wpupg_custom_image":[],"wpupg_custom_image_id":[],"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[14],"tags":[25],"class_list":["post-15","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-restore-backup"],"_links":{"self":[{"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/posts\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":82,"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/posts\/15\/revisions"}],"predecessor-version":[{"id":4005,"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/posts\/15\/revisions\/4005"}],"wp:attachment":[{"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/categories?post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracleconraul.com\/index.php\/wp-json\/wp\/v2\/tags?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}