How to Recover a Table from Oracle 12c via RMAN Backup ?
on same server . Table recovery failed with RMAN-05057: Table OWNER.TABLE_NAME not found (Doc ID 2764271.1)table being recovered resides in a pluggable database, include the keywords "OF PLUGGABLE DATABASE <pdb_name>" in the script/command as below: RECOVER TABLE OWNER.TABLE_NAME UNTIL TIME "to_date('08032021 1540', 'ddmmyyyy hh24mi')" AUXILIARY DESTINATION '/<path>' REMAP TABLE OWNER.<table name>:<new table name>; ========= RMAN> RECOVER TABLE VIHAANX.TEST_RESTORE05 OF PLUGGABLE DATABASE PDB9 UNTIL TIME "to_date('05/10/2022 07:15:40','dd/mm/yyyy hh24:mi:ss')" AUXILIARY DESTINATION '/u01/app/oracle/aux' REMAP TABLE 'VIHAANX'.'TEST_RESTORE05':'TEST_RESTORE55'; Starting recover at 05-10-2022 08:34:46 using channel ORA_DISK_1 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 PDB9:SYSTEM Tablespace UNDOTBS1 Tablespace PDB9:UNDOTBS1 Tablespace UNDOTBS2 Tablespace PDB9:PDB9_UNDOTBS1 Creating automatic instance, with SID='wlan' initialization parameters used for automatic instance: db_name=VIHCDBD8 db_unique_name=wlan_pitr_PDB9_VIHCDBD8 compatible=12.2.0 db_block_size=8192 db_files=200 diagnostic_dest=/u01/app/oracle _system_trig_enabled=FALSE sga_target=21696M processes=200 db_create_file_dest=/u01/app/oracle/aux log_archive_dest_1='location=/u01/app/oracle/aux' enable_pluggable_database=true _clone_one_pdb_recovery=true #No auxiliary parameter file used starting up automatic instance VIHCDBD8 Oracle instance started Total System Global Area 22749904896 bytes Fixed Size 19421832 bytes Variable Size 3019900280 bytes Database Buffers 19662897152 bytes Redo Buffers 47685632 bytes Automatic instance created contents of Memory Script: { # set requested point in time set until time "to_date('05/10/2022 07:15:40','dd/mm/yyyy hh24:mi:ss')"; # restore the controlfile restore clone controlfile; # mount the controlfile sql clone 'alter database mount clone database'; # archive current online log sql 'alter system archive log current'; } executing Memory Script executing command: SET until clause Starting restore at 05-10-2022 08:35:57 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=318 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: reading from backup piece /u01/app/oracle/VIHAAN8/cf_c-3962735431-20221005-00 channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/VIHAAN8/cf_c-3962735431-20221005-00 tag=TAG20221005T071537 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/u01/app/oracle/aux/VIHCDBD8/controlfile/o1_mf_kmtykgqc_.ctl Finished restore at 05-10-2022 08:35:59 sql statement: alter database mount clone database sql statement: alter system archive log current contents of Memory Script: { # set requested point in time set until time "to_date('05/10/2022 07:15:40','dd/mm/yyyy hh24:mi:ss')"; # set destinations for recovery set and auxiliary set datafiles set newname for clone datafile 1 to new; set newname for clone datafile 5 to new; set newname for clone datafile 4 to new; set newname for clone datafile 8 to new; set newname for clone datafile 13 to new; set newname for clone datafile 21 to new; set newname for clone datafile 3 to new; set newname for clone datafile 6 to new; set newname for clone tempfile 1 to new; set newname for clone tempfile 6 to new; set newname for clone tempfile 8 to new; # switch all tempfiles switch clone tempfile all; # restore the tablespaces in the recovery set and the auxiliary set restore clone datafile 1, 5, 4, 8, 13, 21, 3, 6; switch clone datafile all; } executing Memory Script executing command: SET until clause executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 1 to /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_temp_tes_%u_.tmp in control file renamed tempfile 6 to /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_temp_%u_.tmp in control file renamed tempfile 8 to /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_temp_%u_.tmp in control file Starting restore at 05-10-2022 08:36:06 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 00005 to /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_system_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00008 to /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_undotbs1_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00021 to /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_pdb9_und_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_sysaux_%u_.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/VIHAAN8/20221004_vihcdbd8_2493_1_1117186896 channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/VIHAAN8/20221004_vihcdbd8_2493_1_1117186896 tag=TAG20221004T094135 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:11:15 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/aux/VIHCDBD8/datafile/o1_mf_system_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_undotbs1_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00013 to /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_undotbs2_%u_.dbf channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_sysaux_%u_.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/VIHAAN8/20221004_vihcdbd8_2496_1_1117189672 channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/VIHAAN8/20221004_vihcdbd8_2496_1_1117189672 tag=TAG20221004T094135 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:35 Finished restore at 05-10-2022 08:50:05 datafile 1 switched to datafile copy input datafile copy RECID=144 STAMP=1117270205 file name=/u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_system_kmtz72fj_.dbf datafile 5 switched to datafile copy input datafile copy RECID=145 STAMP=1117270205 file name=/u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_system_kmtykz50_.dbf datafile 4 switched to datafile copy input datafile copy RECID=146 STAMP=1117270206 file name=/u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_undotbs1_kmtz72jl_.dbf datafile 8 switched to datafile copy input datafile copy RECID=147 STAMP=1117270206 file name=/u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_undotbs1_kmtykz5y_.dbf datafile 13 switched to datafile copy input datafile copy RECID=148 STAMP=1117270206 file name=/u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_undotbs2_kmtz72gq_.dbf datafile 21 switched to datafile copy input datafile copy RECID=149 STAMP=1117270206 file name=/u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_pdb9_und_kmtykz4l_.dbf datafile 3 switched to datafile copy input datafile copy RECID=150 STAMP=1117270207 file name=/u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_sysaux_kmtz72ck_.dbf datafile 6 switched to datafile copy input datafile copy RECID=151 STAMP=1117270207 file name=/u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_sysaux_kmtykz6w_.dbf contents of Memory Script: { # set requested point in time set until time "to_date('05/10/2022 07:15:40','dd/mm/yyyy hh24:mi:ss')"; # online the datafiles restored or switched sql clone "alter database datafile 1 online"; sql clone 'PDB9' "alter database datafile 5 online"; sql clone "alter database datafile 4 online"; sql clone 'PDB9' "alter database datafile 8 online"; sql clone "alter database datafile 13 online"; sql clone 'PDB9' "alter database datafile 21 online"; sql clone "alter database datafile 3 online"; sql clone 'PDB9' "alter database datafile 6 online"; # recover and open database read only recover clone database tablespace "SYSTEM", "PDB9":"SYSTEM", "UNDOTBS1", "PDB9":"UNDOTBS1", "UNDOTBS2", "PDB9":"PDB9_UNDOTBS1", "SYSAUX", "PDB9":"SYSAUX"; sql clone 'alter database open read only'; } executing Memory Script executing command: SET until clause sql statement: alter database datafile 1 online sql statement: alter database datafile 5 online sql statement: alter database datafile 4 online sql statement: alter database datafile 8 online sql statement: alter database datafile 13 online sql statement: alter database datafile 21 online sql statement: alter database datafile 3 online sql statement: alter database datafile 6 online Starting recover at 05-10-2022 08:50:14 using channel ORA_AUX_DISK_1 starting media recovery archived log for thread 1 with sequence 2964 is already on disk as file +DATA/VIHCDBD8/ARCHIVELOG/2022_10_05/thread_1_seq_2964.4150.1117264719 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2953 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2954 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2955 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2956 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2957 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2958 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2959 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2960 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2961 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2962 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2963 channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/VIHAAN8/20221005_vihcdbd8_2503_1_1117264491 channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/VIHAAN8/20221005_vihcdbd8_2503_1_1117264491 tag=TAG20221005T071451 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:55 archived log file name=/u01/app/oracle/aux/1_2953_1085481127.dbf thread=1 sequence=2953 archived log file name=/u01/app/oracle/aux/1_2954_1085481127.dbf thread=1 sequence=2954 archived log file name=/u01/app/oracle/aux/1_2955_1085481127.dbf thread=1 sequence=2955 archived log file name=/u01/app/oracle/aux/1_2956_1085481127.dbf thread=1 sequence=2956 archived log file name=/u01/app/oracle/aux/1_2957_1085481127.dbf thread=1 sequence=2957 archived log file name=/u01/app/oracle/aux/1_2958_1085481127.dbf thread=1 sequence=2958 archived log file name=/u01/app/oracle/aux/1_2959_1085481127.dbf thread=1 sequence=2959 archived log file name=/u01/app/oracle/aux/1_2960_1085481127.dbf thread=1 sequence=2960 archived log file name=/u01/app/oracle/aux/1_2961_1085481127.dbf thread=1 sequence=2961 archived log file name=/u01/app/oracle/aux/1_2962_1085481127.dbf thread=1 sequence=2962 archived log file name=/u01/app/oracle/aux/1_2963_1085481127.dbf thread=1 sequence=2963 archived log file name=+DATA/VIHCDBD8/ARCHIVELOG/2022_10_05/thread_1_seq_2964.4150.1117264719 thread=1 sequence=2964 media recovery complete, elapsed time: 00:06:22 Finished recover at 05-10-2022 08:57:42 sql statement: alter database open read only contents of Memory Script: { sql clone 'alter pluggable database PDB9 open read only'; } executing Memory Script sql statement: alter pluggable database PDB9 open read only contents of Memory Script: { sql clone "create spfile from memory"; shutdown clone immediate; startup clone nomount; sql clone "alter system set control_files = ''/u01/app/oracle/aux/VIHCDBD8/controlfile/o1_mf_kmtykgqc_.ctl'' comment= ''RMAN set'' scope=spfile"; shutdown clone immediate; startup clone nomount; # mount database sql clone 'alter database mount clone database'; } 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 Total System Global Area 22749904896 bytes Fixed Size 19421832 bytes Variable Size 3019900280 bytes Database Buffers 19662897152 bytes Redo Buffers 47685632 bytes sql statement: alter system set control_files = ''/u01/app/oracle/aux/VIHCDBD8/controlfile/o1_mf_kmtykgqc_.ctl'' comment= ''RMAN set'' scope=spfile Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 22749904896 bytes Fixed Size 19421832 bytes Variable Size 3019900280 bytes Database Buffers 19662897152 bytes Redo Buffers 47685632 bytes sql statement: alter database mount clone database contents of Memory Script: { # set requested point in time set until time "to_date('05/10/2022 07:15:40','dd/mm/yyyy hh24:mi:ss')"; # set destinations for recovery set and auxiliary set datafiles set newname for datafile 73 to new; # restore the tablespaces in the recovery set and the auxiliary set restore clone datafile 73; switch clone datafile all; } executing Memory Script executing command: SET until clause executing command: SET NEWNAME Starting restore at 05-10-2022 08:59:39 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=190 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 channel ORA_AUX_DISK_1: restoring datafile 00073 to /u01/app/oracle/aux/WLAN_PITR_PDB9_VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_testx_%u_.dbf channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/VIHAAN8/20221004_vihcdbd8_2493_1_1117186896 channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/VIHAAN8/20221004_vihcdbd8_2493_1_1117186896 tag=TAG20221004T094135 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25 Finished restore at 05-10-2022 09:00:07 datafile 73 switched to datafile copy input datafile copy RECID=153 STAMP=1117270808 file name=/u01/app/oracle/aux/WLAN_PITR_PDB9_VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_testx_kmtzxyso_.dbf contents of Memory Script: { # set requested point in time set until time "to_date('05/10/2022 07:15:40','dd/mm/yyyy hh24:mi:ss')"; # online the datafiles restored or switched sql clone 'PDB9' "alter database datafile 73 online"; # recover and open resetlogs recover clone database tablespace "PDB9":"TESTX", "SYSTEM", "PDB9":"SYSTEM", "UNDOTBS1", "PDB9":"UNDOTBS1", "UNDOTBS2", "PDB9":"PDB9_UNDOTBS1", "SYSAUX", "PDB9":"SYSAUX" delete archivelog; alter clone database open resetlogs; } executing Memory Script executing command: SET until clause sql statement: alter database datafile 73 online Starting recover at 05-10-2022 09:00:08 using channel ORA_AUX_DISK_1 starting media recovery archived log for thread 1 with sequence 2964 is already on disk as file +DATA/VIHCDBD8/ARCHIVELOG/2022_10_05/thread_1_seq_2964.4150.1117264719 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2953 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2954 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2955 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2956 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2957 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2958 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2959 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2960 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2961 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2962 channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=2963 channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/VIHAAN8/20221005_vihcdbd8_2503_1_1117264491 channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/VIHAAN8/20221005_vihcdbd8_2503_1_1117264491 tag=TAG20221005T071451 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:56 archived log file name=/u01/app/oracle/aux/1_2953_1085481127.dbf thread=1 sequence=2953 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2953_1085481127.dbf RECID=4550 STAMP=1117270831 archived log file name=/u01/app/oracle/aux/1_2954_1085481127.dbf thread=1 sequence=2954 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2954_1085481127.dbf RECID=4558 STAMP=1117270870 archived log file name=/u01/app/oracle/aux/1_2955_1085481127.dbf thread=1 sequence=2955 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2955_1085481127.dbf RECID=4555 STAMP=1117270866 archived log file name=/u01/app/oracle/aux/1_2956_1085481127.dbf thread=1 sequence=2956 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2956_1085481127.dbf RECID=4559 STAMP=1117270871 archived log file name=/u01/app/oracle/aux/1_2957_1085481127.dbf thread=1 sequence=2957 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2957_1085481127.dbf RECID=4557 STAMP=1117270869 archived log file name=/u01/app/oracle/aux/1_2958_1085481127.dbf thread=1 sequence=2958 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2958_1085481127.dbf RECID=4556 STAMP=1117270869 archived log file name=/u01/app/oracle/aux/1_2959_1085481127.dbf thread=1 sequence=2959 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2959_1085481127.dbf RECID=4549 STAMP=1117270828 archived log file name=/u01/app/oracle/aux/1_2960_1085481127.dbf thread=1 sequence=2960 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2960_1085481127.dbf RECID=4554 STAMP=1117270865 archived log file name=/u01/app/oracle/aux/1_2961_1085481127.dbf thread=1 sequence=2961 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2961_1085481127.dbf RECID=4551 STAMP=1117270838 archived log file name=/u01/app/oracle/aux/1_2962_1085481127.dbf thread=1 sequence=2962 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2962_1085481127.dbf RECID=4553 STAMP=1117270839 archived log file name=/u01/app/oracle/aux/1_2963_1085481127.dbf thread=1 sequence=2963 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/aux/1_2963_1085481127.dbf RECID=4552 STAMP=1117270838 archived log file name=+DATA/VIHCDBD8/ARCHIVELOG/2022_10_05/thread_1_seq_2964.4150.1117264719 thread=1 sequence=2964 media recovery complete, elapsed time: 00:00:05 Finished recover at 05-10-2022 09:01:23 database opened contents of Memory Script: { sql clone 'alter pluggable database PDB9 open'; } executing Memory Script sql statement: alter pluggable database PDB9 open contents of Memory Script: { # create directory for datapump import sql 'PDB9' "create or replace directory TSPITR_DIROBJ_DPDIR as '' /u01/app/oracle/aux''"; # create directory for datapump export sql clone 'PDB9' "create or replace directory TSPITR_DIROBJ_DPDIR as '' /u01/app/oracle/aux''"; } executing Memory Script sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/aux'' sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/u01/app/oracle/aux'' Performing export of tables... EXPDP> Starting "SYS"."TSPITR_EXP_wlan_Aguy": 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/TABLE EXPDP> . . exported "VIHAANX"."TEST_RESTORE05" 5.062 KB 1 rows EXPDP> Master table "SYS"."TSPITR_EXP_wlan_Aguy" successfully loaded/unloaded EXPDP> ****************************************************************************** EXPDP> Dump file set for SYS.TSPITR_EXP_wlan_Aguy is: EXPDP> /u01/app/oracle/aux/tspitr_wlan_64020.dmp EXPDP> Job "SYS"."TSPITR_EXP_wlan_Aguy" successfully completed at Wed Oct 5 09:05:47 2022 elapsed 0 00:00:45 Export completed contents of Memory Script: { # shutdown clone before import shutdown clone abort } executing Memory Script Oracle instance shut down Performing import of tables... IMPDP> Master table "SYS"."TSPITR_IMP_wlan_viim" successfully loaded/unloaded IMPDP> Starting "SYS"."TSPITR_IMP_wlan_viim": IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA IMPDP> . . imported "VIHAANX"."TEST_RESTORE55" 5.062 KB 1 rows IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS IMPDP> Job "SYS"."TSPITR_IMP_wlan_viim" successfully completed at Wed Oct 5 09:06:08 2022 elapsed 0 00:00:11 Import completed Removing automatic instance Automatic instance removed auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_temp_kmtztktj_.tmp deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_temp_kmtzt8dm_.tmp deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_temp_tes_kmtzt8np_.tmp deleted auxiliary instance file /u01/app/oracle/aux/WLAN_PITR_PDB9_VIHCDBD8/onlinelog/o1_mf_6_kmv0143r_.log deleted auxiliary instance file /u01/app/oracle/aux/WLAN_PITR_PDB9_VIHCDBD8/onlinelog/o1_mf_5_kmv01430_.log deleted auxiliary instance file /u01/app/oracle/aux/WLAN_PITR_PDB9_VIHCDBD8/onlinelog/o1_mf_4_kmv0142y_.log deleted auxiliary instance file /u01/app/oracle/aux/WLAN_PITR_PDB9_VIHCDBD8/onlinelog/o1_mf_1_kmv01422_.log deleted auxiliary instance file /u01/app/oracle/aux/WLAN_PITR_PDB9_VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_testx_kmtzxyso_.dbf deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_sysaux_kmtykz6w_.dbf deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_sysaux_kmtz72ck_.dbf deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_pdb9_und_kmtykz4l_.dbf deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_undotbs2_kmtz72gq_.dbf deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_undotbs1_kmtykz5y_.dbf deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_undotbs1_kmtz72jl_.dbf deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/A3144982890B1187E05324F56A40A1C1/datafile/o1_mf_system_kmtykz50_.dbf deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/datafile/o1_mf_system_kmtz72fj_.dbf deleted auxiliary instance file /u01/app/oracle/aux/VIHCDBD8/controlfile/o1_mf_kmtykgqc_.ctl deleted auxiliary instance file tspitr_wlan_64020.dmp deleted Finished recover at 05-10-2022 09:06:11 ==== alter session set container=PDB9 ; Session altered. select count(*) from VIHAANX.TEST_RESTORE55 ; COUNT(*) ---------- 1
Wednesday 5 October 2022
How to Recover a Table from Oracle 12c via RMAN Backup ?
How to Recover a Table from an Oracle 12c RMAN Backup
Subscribe to:
Posts (Atom)
