Durante a execu\u00e7\u00e3o de um Tablespace Point-in-time Recovery, me deparei com o seguinte erro:<\/p>\n\n\n
\n[oracle@oel8 TSPITR]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Mon Aug 9 20:24:25 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN> RECOVER TABLESPACE USERS UNTIL TIME "to_date('2021-08-09:20:11:06','YYYY-MM-DD:HH24:MI:SS')" AUXILIARY DESTINATION '\/oracle\/TSPITR';\n \nStarting recover at 2021-08-09:20:24:45\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=119 device type=DISK\nRMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time\n \nList of tablespaces expected to have UNDO segments\nTablespace SYSTEM\nTablespace UNDOTBS1\n \nCreating automatic instance, with SID='lFEs'\n \ninitialization parameters used for automatic instance:\ndb_name=RMANDB\ndb_unique_name=lFEs_pitr_RMANDB\ncompatible=18.0.0\ndb_block_size=8192\ndb_files=200\ndiagnostic_dest=\/oracle\/18.0.0\/base\n_system_trig_enabled=FALSE\nsga_target=1536M\nprocesses=200\ndb_create_file_dest=\/oracle\/TSPITR\nlog_archive_dest_1='location=\/oracle\/TSPITR'\n#No auxiliary parameter file used\n \n \nstarting up automatic instance RMANDB\n \nOracle instance started\n \nTotal System Global Area 1610612016 bytes\n \nFixed Size 8658224 bytes\nVariable Size 402653184 bytes\nDatabase Buffers 1191182336 bytes\nRedo Buffers 8118272 bytes\nAutomatic instance created\nRunning TRANSPORT_SET_CHECK on recovery set tablespaces\nTRANSPORT_SET_CHECK completed successfully\n \ncontents of Memory Script:\n{\n# set requested point in time\nset until time "to_date('2021-08-09:20:11:06','YYYY-MM-DD:HH24:MI:SS')";\n# restore the controlfile\nrestore clone controlfile;\n \n# mount the controlfile\nsql clone 'alter database mount clone database';\n \n# archive current online log\nsql 'alter system archive log current';\n# avoid unnecessary autobackups for structural changes during TSPITR\nsql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';\n}\nexecuting Memory Script\n \nexecuting command: SET until clause\n \nStarting restore at 2021-08-09:20:25:06\nallocated channel: ORA_AUX_DISK_1\nchannel ORA_AUX_DISK_1: SID=38 device type=DISK\n \nchannel ORA_AUX_DISK_1: starting datafile backup set restore\nchannel ORA_AUX_DISK_1: restoring control file\nchannel ORA_AUX_DISK_1: reading from backup piece \/oracle\/fra\/RMANDB\/autobackup\/2021_08_09\/o1_mf_s_1080158883_jk3fbn9x_.bkp\nchannel ORA_AUX_DISK_1: piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_08_09\/o1_mf_s_1080158883_jk3fbn9x_.bkp tag=TAG20210809T200803\nchannel ORA_AUX_DISK_1: restored backup piece 1\nchannel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01\noutput file name=\/oracle\/TSPITR\/RMANDB\/controlfile\/o1_mf_jk3gbm5o_.ctl\nFinished restore at 2021-08-09:20:25:08\n \nsql statement: alter database mount clone database\n \nsql statement: alter system archive log current\n \nsql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;\n \ncontents of Memory Script:\n{\n# set requested point in time\nset until time "to_date('2021-08-09:20:11:06','YYYY-MM-DD:HH24:MI:SS')";\nplsql <<<--\ndeclare\n sqlstatement varchar2(512);\n pdbname varchar2(128);\n offline_not_needed exception;\n pragma exception_init(offline_not_needed, -01539);\nbegin\n pdbname := null; -- pdbname\n sqlstatement := 'alter tablespace '|| 'USERS' ||' offline immediate';\n krmicd.writeMsg(6162, sqlstatement);\n krmicd.execSql(sqlstatement, 0, pdbname);\nexception\n when offline_not_needed then\n null;\nend; >>>;\n# set destinations for recovery set and auxiliary set datafiles\nset newname for clone datafile 1 to new;\nset newname for clone datafile 4 to new;\nset newname for clone datafile 3 to new;\nset newname for clone tempfile 1 to new;\nset newname for datafile 7 to\n "\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf";\n# switch all tempfiles\nswitch clone tempfile all;\n# restore the tablespaces in the recovery set and the auxiliary set\nrestore clone datafile 1, 4, 3, 7;\n \nswitch clone datafile all;\n}\nexecuting Memory Script\n \nexecuting command: SET until clause\n \nsql statement: alter tablespace USERS offline immediate\n \nexecuting command: SET NEWNAME\n \nexecuting command: SET NEWNAME\n \nexecuting command: SET NEWNAME\n \nexecuting command: SET NEWNAME\n \nexecuting command: SET NEWNAME\n \nrenamed tempfile 1 to \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_temp_%u_.tmp in control file\n \nStarting restore at 2021-08-09:20:25:16\nusing channel ORA_AUX_DISK_1\n \nchannel ORA_AUX_DISK_1: starting datafile backup set restore\nchannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_AUX_DISK_1: restoring datafile 00001 to \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_system_%u_.dbf\nchannel ORA_AUX_DISK_1: restoring datafile 00004 to \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_undotbs1_%u_.dbf\nchannel ORA_AUX_DISK_1: restoring datafile 00003 to \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_sysaux_%u_.dbf\nchannel ORA_AUX_DISK_1: restoring datafile 00007 to \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_AUX_DISK_1: reading from backup piece \/oracle\/fra\/RMANDB\/backupset\/2021_08_09\/o1_mf_nnndf_TAG20210809T200618_jk3f7fbd_.bkp\nchannel ORA_AUX_DISK_1: piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_08_09\/o1_mf_nnndf_TAG20210809T200618_jk3f7fbd_.bkp tag=TAG20210809T200618\nchannel ORA_AUX_DISK_1: restored backup piece 1\nchannel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:45\nFinished restore at 2021-08-09:20:27:02\n \ndatafile 1 switched to datafile copy\ninput datafile copy RECID=49 STAMP=1080160022 file name=\/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_system_jk3gbx9l_.dbf\ndatafile 4 switched to datafile copy\ninput datafile copy RECID=50 STAMP=1080160022 file name=\/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_undotbs1_jk3gbxdz_.dbf\ndatafile 3 switched to datafile copy\ninput datafile copy RECID=51 STAMP=1080160022 file name=\/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_sysaux_jk3gbxds_.dbf\n \ncontents of Memory Script:\n{\n# set requested point in time\nset until time "to_date('2021-08-09:20:11:06','YYYY-MM-DD:HH24:MI:SS')";\n# online the datafiles restored or switched\nsql clone "alter database datafile 1 online";\nsql clone "alter database datafile 4 online";\nsql clone "alter database datafile 3 online";\nsql clone "alter database datafile 7 online";\n# recover and open resetlogs\nrecover clone database tablespace "USERS", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;\nalter clone database open resetlogs;\n}\nexecuting Memory Script\n \nexecuting command: SET until clause\n \nsql statement: alter database datafile 1 online\n \nsql statement: alter database datafile 4 online\n \nsql statement: alter database datafile 3 online\n \nsql statement: alter database datafile 7 online\n \nStarting recover at 2021-08-09:20:27:03\nusing channel ORA_AUX_DISK_1\n \nstarting media recovery\n \narchived log for thread 1 with sequence 1 is already on disk as file \/oracle\/archives\/1_1_1079643731.dbf\narchived log for thread 1 with sequence 2 is already on disk as file \/oracle\/archives\/1_2_1079643731.dbf\narchived log file name=\/oracle\/archives\/1_1_1079643731.dbf thread=1 sequence=1\narchived log file name=\/oracle\/archives\/1_2_1079643731.dbf thread=1 sequence=2\nmedia recovery complete, elapsed time: 00:00:01\nFinished recover at 2021-08-09:20:27:06\n \ndatabase opened\n \ncontents of Memory Script:\n{\n# make read only the tablespace that will be exported\nsql clone 'alter tablespace USERS read only';\n# create directory for datapump import\nsql "create or replace directory TSPITR_DIROBJ_DPDIR as ''\n\/oracle\/TSPITR''";\n# create directory for datapump export\nsql clone "create or replace directory TSPITR_DIROBJ_DPDIR as ''\n\/oracle\/TSPITR''";\n}\nexecuting Memory Script\n \nsql statement: alter tablespace USERS read only\n \nsql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''\/oracle\/TSPITR''\n \nsql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''\/oracle\/TSPITR''\n \nPerforming export of metadata...\n EXPDP> Starting "SYS"."TSPITR_EXP_lFEs_nkcE":\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/INDEX\/STATISTICS\/INDEX_STATISTICS\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/STATISTICS\/TABLE_STATISTICS\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/STATISTICS\/MARKER\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/PLUGTS_BLK\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/POST_INSTANCE\/PLUGTS_BLK\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/TABLE\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/INDEX\/INDEX\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/CONSTRAINT\/CONSTRAINT\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/COMMENT\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/CONSTRAINT\/REF_CONSTRAINT\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/TRIGGER\n EXPDP> Master table "SYS"."TSPITR_EXP_lFEs_nkcE" successfully loaded\/unloaded\n EXPDP> ******************************************************************************\n EXPDP> Dump file set for SYS.TSPITR_EXP_lFEs_nkcE is:\n EXPDP> \/oracle\/TSPITR\/tspitr_lFEs_68564.dmp\n EXPDP> ******************************************************************************\n EXPDP> Datafiles required for transportable tablespace USERS:\n EXPDP> \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n EXPDP> Job "SYS"."TSPITR_EXP_lFEs_nkcE" successfully completed at Mon Aug 9 20:28:25 2021 elapsed 0 00:00:47\nExport completed\n \n \ncontents of Memory Script:\n{\n# shutdown clone before import\nshutdown clone abort\n# drop target tablespaces before importing them back\nsql 'drop tablespace USERS including contents keep datafiles cascade constraints';\n}\nexecuting Memory Script\n \nOracle instance shut down\n \nsql statement: drop tablespace USERS including contents keep datafiles cascade constraints\n \nRemoving automatic instance\nAutomatic instance removed\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_temp_jk3ggwbs_.tmp deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/onlinelog\/o1_mf_3_jk3ggn2n_.log deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/onlinelog\/o1_mf_2_jk3ggd1o_.log deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/onlinelog\/o1_mf_1_jk3ggd0w_.log deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_sysaux_jk3gbxds_.dbf deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_undotbs1_jk3gbxdz_.dbf deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_system_jk3gbx9l_.dbf deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/controlfile\/o1_mf_jk3gbm5o_.ctl deleted\nauxiliary instance file tspitr_lFEs_68564.dmp deleted\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of recover command at 08\/09\/2021 20:28:28\nRMAN-03015: error occurred in stored script Memory Script\nRMAN-03009: failure of sql command on default channel at 08\/09\/2021 20:28:28\nRMAN-11003: failure during parse\/execution of SQL statement: drop tablespace USERS including contents keep datafiles cascade constraints\nORA-12919: Can not drop the default permanent tablespace\n<\/pre><\/div>\n\n\nA mensagem de erro j\u00e1 fala por si s\u00f3: na etapa de DROP da tablespace que \u00e9 realizada pelo RMAN, \u00e9 identificado que a tablespace em quest\u00e3o \u00e9 a “Default” do banco de dados. Podemos nos certificar disso com a consulta abaixo:<\/p>\n\n\n
\nRMAN> SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME = 'DEFAULT_PERMANENT_TABLESPACE';\n \n \n \nPROPERTY_VALUE\n--------------------------------------------------------------------------------\n \nUSERS\n<\/pre><\/div>\n\n\nPara resolver, basta alterarmos essa configura\u00e7\u00e3o para outra tablespace e disparar o processo novamente:<\/p>\n\n\n
\nRMAN> ALTER DATABASE DEFAULT TABLESPACE TS_CORTEX_CATALOG;\n \nStatement processed\n<\/pre><\/div>\n\n\nProcesso finalizado com sucesso:<\/p>\n\n\n
\n[oracle@oel8 TSPITR]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Mon Aug 9 20:40:06 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN> RECOVER TABLESPACE USERS UNTIL TIME "to_date('2021-08-09:20:11:06','YYYY-MM-DD:HH24:MI:SS')" AUXILIARY DESTINATION '\/oracle\/TSPITR';\n \nStarting recover at 2021-08-09:20:40:18\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=106 device type=DISK\nRMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time\n \nList of tablespaces expected to have UNDO segments\nTablespace SYSTEM\nTablespace UNDOTBS1\n \nCreating automatic instance, with SID='veas'\n \ninitialization parameters used for automatic instance:\ndb_name=RMANDB\ndb_unique_name=veas_pitr_RMANDB\ncompatible=18.0.0\ndb_block_size=8192\ndb_files=200\ndiagnostic_dest=\/oracle\/18.0.0\/base\n_system_trig_enabled=FALSE\nsga_target=1536M\nprocesses=200\ndb_create_file_dest=\/oracle\/TSPITR\nlog_archive_dest_1='location=\/oracle\/TSPITR'\n#No auxiliary parameter file used\n \n \nstarting up automatic instance RMANDB\n \nOracle instance started\n \nTotal System Global Area 1610612016 bytes\n \nFixed Size 8658224 bytes\nVariable Size 402653184 bytes\nDatabase Buffers 1191182336 bytes\nRedo Buffers 8118272 bytes\nAutomatic instance created\nRunning TRANSPORT_SET_CHECK on recovery set tablespaces\nTRANSPORT_SET_CHECK completed successfully\n \ncontents of Memory Script:\n{\n# set requested point in time\nset until time "to_date('2021-08-09:20:11:06','YYYY-MM-DD:HH24:MI:SS')";\n# restore the controlfile\nrestore clone controlfile;\n \n# mount the controlfile\nsql clone 'alter database mount clone database';\n \n# archive current online log\nsql 'alter system archive log current';\n# avoid unnecessary autobackups for structural changes during TSPITR\nsql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';\n}\nexecuting Memory Script\n \nexecuting command: SET until clause\n \nStarting restore at 2021-08-09:20:40:36\nallocated channel: ORA_AUX_DISK_1\nchannel ORA_AUX_DISK_1: SID=34 device type=DISK\n \nchannel ORA_AUX_DISK_1: starting datafile backup set restore\nchannel ORA_AUX_DISK_1: restoring control file\nchannel ORA_AUX_DISK_1: reading from backup piece \/oracle\/fra\/RMANDB\/autobackup\/2021_08_09\/o1_mf_s_1080158883_jk3fbn9x_.bkp\nchannel ORA_AUX_DISK_1: piece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_08_09\/o1_mf_s_1080158883_jk3fbn9x_.bkp tag=TAG20210809T200803\nchannel ORA_AUX_DISK_1: restored backup piece 1\nchannel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01\noutput file name=\/oracle\/TSPITR\/RMANDB\/controlfile\/o1_mf_jk3h7o4v_.ctl\nFinished restore at 2021-08-09:20:40:38\n \nsql statement: alter database mount clone database\n \nsql statement: alter system archive log current\n \nsql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;\n \ncontents of Memory Script:\n{\n# set requested point in time\nset until time "to_date('2021-08-09:20:11:06','YYYY-MM-DD:HH24:MI:SS')";\n# set destinations for recovery set and auxiliary set datafiles\nset newname for clone datafile 1 to new;\nset newname for clone datafile 4 to new;\nset newname for clone datafile 3 to new;\nset newname for clone tempfile 1 to new;\nset newname for datafile 7 to\n "\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf";\n# switch all tempfiles\nswitch clone tempfile all;\n# restore the tablespaces in the recovery set and the auxiliary set\nrestore clone datafile 1, 4, 3, 7;\n \nswitch clone datafile all;\n}\nexecuting Memory Script\n \nexecuting command: SET until clause\n \nexecuting command: SET NEWNAME\n \nexecuting command: SET NEWNAME\n \nexecuting command: SET NEWNAME\n \nexecuting command: SET NEWNAME\n \nexecuting command: SET NEWNAME\n \nrenamed tempfile 1 to \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_temp_%u_.tmp in control file\n \nStarting restore at 2021-08-09:20:40:43\nusing channel ORA_AUX_DISK_1\n \nchannel ORA_AUX_DISK_1: starting datafile backup set restore\nchannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set\nchannel ORA_AUX_DISK_1: restoring datafile 00001 to \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_system_%u_.dbf\nchannel ORA_AUX_DISK_1: restoring datafile 00004 to \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_undotbs1_%u_.dbf\nchannel ORA_AUX_DISK_1: restoring datafile 00003 to \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_sysaux_%u_.dbf\nchannel ORA_AUX_DISK_1: restoring datafile 00007 to \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_AUX_DISK_1: reading from backup piece \/oracle\/fra\/RMANDB\/backupset\/2021_08_09\/o1_mf_nnndf_TAG20210809T200618_jk3f7fbd_.bkp\nchannel ORA_AUX_DISK_1: piece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_08_09\/o1_mf_nnndf_TAG20210809T200618_jk3f7fbd_.bkp tag=TAG20210809T200618\nchannel ORA_AUX_DISK_1: restored backup piece 1\nchannel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:45\nFinished restore at 2021-08-09:20:43:28\n \ndatafile 1 switched to datafile copy\ninput datafile copy RECID=49 STAMP=1080161008 file name=\/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_system_jk3h7vm3_.dbf\ndatafile 4 switched to datafile copy\ninput datafile copy RECID=50 STAMP=1080161008 file name=\/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_undotbs1_jk3h7vos_.dbf\ndatafile 3 switched to datafile copy\ninput datafile copy RECID=51 STAMP=1080161008 file name=\/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_sysaux_jk3h7vop_.dbf\n \ncontents of Memory Script:\n{\n# set requested point in time\nset until time "to_date('2021-08-09:20:11:06','YYYY-MM-DD:HH24:MI:SS')";\n# online the datafiles restored or switched\nsql clone "alter database datafile 1 online";\nsql clone "alter database datafile 4 online";\nsql clone "alter database datafile 3 online";\nsql clone "alter database datafile 7 online";\n# recover and open resetlogs\nrecover clone database tablespace "USERS", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;\nalter clone database open resetlogs;\n}\nexecuting Memory Script\n \nexecuting command: SET until clause\n \nsql statement: alter database datafile 1 online\n \nsql statement: alter database datafile 4 online\n \nsql statement: alter database datafile 3 online\n \nsql statement: alter database datafile 7 online\n \nStarting recover at 2021-08-09:20:43:29\nusing channel ORA_AUX_DISK_1\n \nstarting media recovery\n \narchived log for thread 1 with sequence 1 is already on disk as file \/oracle\/archives\/1_1_1079643731.dbf\narchived log for thread 1 with sequence 2 is already on disk as file \/oracle\/archives\/1_2_1079643731.dbf\narchived log file name=\/oracle\/archives\/1_1_1079643731.dbf thread=1 sequence=1\narchived log file name=\/oracle\/archives\/1_2_1079643731.dbf thread=1 sequence=2\nmedia recovery complete, elapsed time: 00:00:00\nFinished recover at 2021-08-09:20:43:31\n \ndatabase opened\n \ncontents of Memory Script:\n{\n# make read only the tablespace that will be exported\nsql clone 'alter tablespace USERS read only';\n# create directory for datapump import\nsql "create or replace directory TSPITR_DIROBJ_DPDIR as ''\n\/oracle\/TSPITR''";\n# create directory for datapump export\nsql clone "create or replace directory TSPITR_DIROBJ_DPDIR as ''\n\/oracle\/TSPITR''";\n}\nexecuting Memory Script\n \nsql statement: alter tablespace USERS read only\n \nsql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''\/oracle\/TSPITR''\n \nsql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''\/oracle\/TSPITR''\n \nPerforming export of metadata...\n EXPDP> Starting "SYS"."TSPITR_EXP_veas_Fofq":\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/INDEX\/STATISTICS\/INDEX_STATISTICS\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/STATISTICS\/TABLE_STATISTICS\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/STATISTICS\/MARKER\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/PLUGTS_BLK\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/POST_INSTANCE\/PLUGTS_BLK\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/TABLE\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/INDEX\/INDEX\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/CONSTRAINT\/CONSTRAINT\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/COMMENT\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/CONSTRAINT\/REF_CONSTRAINT\n EXPDP> Processing object type TRANSPORTABLE_EXPORT\/TRIGGER\n EXPDP> Master table "SYS"."TSPITR_EXP_veas_Fofq" successfully loaded\/unloaded\n EXPDP> ******************************************************************************\n EXPDP> Dump file set for SYS.TSPITR_EXP_veas_Fofq is:\n EXPDP> \/oracle\/TSPITR\/tspitr_veas_10076.dmp\n EXPDP> ******************************************************************************\n EXPDP> Datafiles required for transportable tablespace USERS:\n EXPDP> \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n EXPDP> Job "SYS"."TSPITR_EXP_veas_Fofq" successfully completed at Mon Aug 9 20:44:40 2021 elapsed 0 00:00:46\nExport completed\n \n \ncontents of Memory Script:\n{\n# shutdown clone before import\nshutdown clone abort\n# drop target tablespaces before importing them back\nsql 'drop tablespace USERS including contents keep datafiles cascade constraints';\n}\nexecuting Memory Script\n \nOracle instance shut down\n \nsql statement: drop tablespace USERS including contents keep datafiles cascade constraints\n \nPerforming import of metadata...\n IMPDP> Master table "SYS"."TSPITR_IMP_veas_qlri" successfully loaded\/unloaded\n IMPDP> Starting "SYS"."TSPITR_IMP_veas_qlri":\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/PLUGTS_BLK\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/TABLE\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/INDEX\/INDEX\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/CONSTRAINT\/CONSTRAINT\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/INDEX\/STATISTICS\/INDEX_STATISTICS\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/COMMENT\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/CONSTRAINT\/REF_CONSTRAINT\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/TRIGGER\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/STATISTICS\/TABLE_STATISTICS\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/STATISTICS\/MARKER\n IMPDP> Processing object type TRANSPORTABLE_EXPORT\/POST_INSTANCE\/PLUGTS_BLK\n IMPDP> Job "SYS"."TSPITR_IMP_veas_qlri" successfully completed at Mon Aug 9 20:45:20 2021 elapsed 0 00:00:23\nImport completed\n \n \ncontents of Memory Script:\n{\n# make read write and offline the imported tablespaces\nsql 'alter tablespace USERS read write';\nsql 'alter tablespace USERS offline';\n# enable autobackups after TSPITR is finished\nsql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;';\n}\nexecuting Memory Script\n \nsql statement: alter tablespace USERS read write\n \nsql statement: alter tablespace USERS offline\n \nsql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;\n \nRemoving automatic instance\nAutomatic instance removed\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_temp_jk3hfms7_.tmp deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/onlinelog\/o1_mf_3_jk3hfcxs_.log deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/onlinelog\/o1_mf_2_jk3hf3qn_.log deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/onlinelog\/o1_mf_1_jk3hf3q1_.log deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_sysaux_jk3h7vop_.dbf deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_undotbs1_jk3h7vos_.dbf deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/datafile\/o1_mf_system_jk3h7vm3_.dbf deleted\nauxiliary instance file \/oracle\/TSPITR\/RMANDB\/controlfile\/o1_mf_jk3h7o4v_.ctl deleted\nauxiliary instance file tspitr_veas_10076.dmp deleted\nFinished recover at 2021-08-09:20:45:23\n \nRMAN>\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"Durante a execu\u00e7\u00e3o de um Tablespace Point-in-time Recovery, me deparei com o seguinte erro: A mensagem de erro j\u00e1 fala por si s\u00f3: na etapa de DROP da tablespace que \u00e9 realizada pelo RMAN, \u00e9 identificado que a tablespace em quest\u00e3o \u00e9 a “Default” do banco de dados. Podemos nos certificar disso com a consulta […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6128","post","type-post","status-publish","format-standard","hentry","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=6128"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6128\/revisions"}],"predecessor-version":[{"id":9066,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6128\/revisions\/9066"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=6128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=6128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=6128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}