RMAN> recover tablespace TBS1 until time "to_date('2018:10:03 00:18:00','YYYY:MM:DD:HH24:MI:SS')" auxiliary destination '/u03/rmanbkp/';
Starting recover at 2018:10:03 00:32:56
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=42 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 UNDOTBS1
Creating automatic instance, with SID='kvfn'
initialization parameters used for automatic instance:
db_name=HRMS
db_unique_name=kvfn_pitr_HRMS
compatible=12.1.0.2.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_system_trig_enabled=FALSE
sga_target=800M
processes=200
db_create_file_dest=/u03/rmanbkp/
log_archive_dest_1='location=/u03/rmanbkp/'
#No auxiliary parameter file used
starting up automatic instance HRMS
Oracle instance started
Total System Global Area 838860800 bytes
Fixed Size 2929936 bytes
Variable Size 230689520 bytes
Database Buffers 599785472 bytes
Redo Buffers 5455872 bytes
Automatic instance created
List of tablespaces that have been dropped from the target database:
Tablespace TBS1
contents of Memory Script:
{
# set requested point in time
set until time "to_date('2018:10:03 00:18:00','YYYY:MM:DD: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';
# avoid unnecessary autobackups for structural changes during TSPITR
sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
}
executing Memory Script
executing command: SET until clause
Starting restore at 2018:10:03 00:33:20
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=22 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 /u02/app/oracle/fast_recovery_area/HRMS/backupset/2018_10_02/o1_mf_ncsn0_TAG20181002T224740_fv6tcg7v_.bkp
channel ORA_AUX_DISK_1: piece handle=/u02/app/oracle/fast_recovery_area/HRMS/backupset/2018_10_02/o1_mf_ncsn0_TAG20181002T224740_fv6tcg7v_.bkp tag=TAG20181002T224740
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u03/rmanbkp/HRMS/controlfile/o1_mf_fv70flbt_.ctl
Finished restore at 2018:10:03 00:33:23
sql statement: alter database mount clone database
sql statement: alter system archive log current
sql statement: begin dbms_backup_restore.AutoBackupFlag(FALSE); end;
contents of Memory Script:
{
# set requested point in time
set until time "to_date('2018:10:03 00:18:00','YYYY:MM:DD: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 4 to new;
set newname for clone datafile 3 to new;
set newname for clone tempfile 1 to new;
set newname for datafile 2 to
"/u02/app/oracle/oradata/hrms/tbs01.dbf";
# switch all tempfiles
switch clone tempfile all;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile 1, 4, 3, 2;
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
renamed tempfile 1 to /u03/rmanbkp/HRMS/datafile/o1_mf_temp_%u_.tmp in control file
Starting restore at 2018:10:03 00:33:33
using channel ORA_AUX_DISK_1
One or more auxiliary set of datafiles could not be removed
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
auxiliary instance file /u03/rmanbkp/HRMS/controlfile/o1_mf_fv70flbt_.ctl deleted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/03/2018 00:33:35
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 3 found to restore