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 scn 3329365;
# set destinations for recovery set and auxiliary set datafiles
set newname for clone datafile 1 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 3 to new;
set newname for clone tempfile 1 to new;
# switch all tempfiles
switch clone tempfile all;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile 1, 4, 3;
contents of Memory Script:
{
# set requested point in time
set until scn 3329365;
# online the datafiles restored or switched
sql clone "alter database datafile 1 online";
sql clone "alter database datafile 4 online";
sql clone "alter database datafile 3 online";
# recover and open database read only
recover clone database tablespace "SYSTEM", "UNDOTBS1", "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 4 online
sql statement: alter database datafile 3 online
Starting recover at 31-JUL-20
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 12 is already on disk as file /u01/app/oracle/fast_recovery_area/SZTECH/archivelog/2020_07_31/o1_mf_1_12_hl720g0x_.arc
archived log for thread 1 with sequence 13 is already on disk as file /u01/app/oracle/fast_recovery_area/SZTECH/archivelog/2020_07_31/o1_mf_1_13_hl724t8r_.arc
archived log file name=/u01/app/oracle/fast_recovery_area/SZTECH/archivelog/2020_07_31/o1_mf_1_12_hl720g0x_.arc thread=1 sequence=12
archived log file name=/u01/app/oracle/fast_recovery_area/SZTECH/archivelog/2020_07_31/o1_mf_1_13_hl724t8r_.arc thread=1 sequence=13
media recovery complete, elapsed time: 00:00:00
Finished recover at 31-JUL-20
sql statement: alter database 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 =
''/home/oracle/SZTECH/controlfile/o1_mf_hl725x70_.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
sql statement: alter database mount clone database
contents of Memory Script:
{
# set requested point in time
set until scn 3329365;
# set destinations for recovery set and auxiliary set datafiles
set newname for datafile 2 to new;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile 2;
contents of Memory Script:
{
# set requested point in time
set until scn 3329365;
# online the datafiles restored or switched
sql clone "alter database datafile 2 online";
# recover and open resetlogs
recover clone database tablespace "TBS_IDX", "SYSTEM", "UNDOTBS1", "SYSAUX" delete archivelog;
alter clone database open resetlogs;
}
executing Memory Script
executing command: SET until clause
sql statement: alter database datafile 2 online
Starting recover at 31-JUL-20
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 12 is already on disk as file /u01/app/oracle/fast_recovery_area/SZTECH/archivelog/2020_07_31/o1_mf_1_12_hl720g0x_.arc
archived log for thread 1 with sequence 13 is already on disk as file /u01/app/oracle/fast_recovery_area/SZTECH/archivelog/2020_07_31/o1_mf_1_13_hl724t8r_.arc
archived log file name=/u01/app/oracle/fast_recovery_area/SZTECH/archivelog/2020_07_31/o1_mf_1_12_hl720g0x_.arc thread=1 sequence=12
archived log file name=/u01/app/oracle/fast_recovery_area/SZTECH/archivelog/2020_07_31/o1_mf_1_13_hl724t8r_.arc thread=1 sequence=13
media recovery complete, elapsed time: 00:00:00
Finished recover at 31-JUL-20
database opened
contents of Memory Script:
{
# create directory for datapump import
sql "create or replace directory TSPITR_DIROBJ_DPDIR as ''
/home/oracle''";
# create directory for datapump export
sql clone "create or replace directory TSPITR_DIROBJ_DPDIR as ''
/home/oracle''";
}
executing Memory Script
sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/home/oracle''
sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as ''/home/oracle''
Performing export of tables...
EXPDP> Starting "SYS"."TSPITR_EXP_ftvd_ugeh":
EXPDP> Estimate in progress using BLOCKS method...
EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
EXPDP> Total estimation using BLOCKS method: 64 KB
EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
EXPDP> ORA-39127: unexpected error from call to export_string :=SYS.DBMS_TRANSFORM_EXIMP.INSTANCE_INFO_EXP('AQ$_ORDERS_QUEUETABLE_S','IX',1,1,'12.01.00.02.00',newblock)
ORA-00376: file 5 cannot be read at this time
ORA-01110: data file 5: '/u01/app/oracle/oradata/sztech/SZTECH/datafile/example01.dbf'
ORA-06512: at "SYS.DBMS_TRANSFORM_EXIMP", line 197
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 10261
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_TRANSFORM_EXIMP.INSTANCE_INFO_EXP('AQ$_STREAMS_QUEUE_TABLE_S','IX',1,1,'12.01.00.02.00',newblock)
ORA-00376: file 5 cannot be read at this time
ORA-01110: data file 5: '/u01/app/oracle/oradata/sztech/SZTECH/datafile/example01.dbf'
ORA-06512: at "SYS.DBMS_TRANSFORM_EXIMP", line 197
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 10261
EXPDP> . . exported "HR"."EMP" 17.08 KB 107 rows
EXPDP> Master table "SYS"."TSPITR_EXP_ftvd_ugeh" successfully loaded/unloaded
EXPDP> ******************************************************************************
EXPDP> Dump file set for SYS.TSPITR_EXP_ftvd_ugeh is:
EXPDP> /home/oracle/tspitr_ftvd_57525.dmp
EXPDP> Job "SYS"."TSPITR_EXP_ftvd_ugeh" completed with 2 error(s) at Fri Jul 31 10:59:19 2020 elapsed 0 00:00:10
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_ftvd_fqdd" successfully loaded/unloaded
IMPDP> Starting "SYS"."TSPITR_IMP_ftvd_fqdd":
IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
IMPDP> . . imported "HR"."EMP" 17.08 KB 107 rows
IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
IMPDP> Job "SYS"."TSPITR_IMP_ftvd_fqdd" successfully completed at Fri Jul 31 10:59:33 2020 elapsed 0 00:00:11
Import completed
