Hi
Oracle 11.2.0.4.0
Anyone have idea, why this thing happens.
My source database uses single diskgroup +DATA. I want to restore it from full backup to a new host, diskgroup +DATA_TEMP.
Database, where I want to restore it, I have started (MOUNT) this db with pfile, where *.db_create_file_dest='+DATA_TEMP' (this should control, where the datafiiles should be stored)
(there is none of the convert_file.. parameters set in pfile)
But funny thing happens, while I restore it with command (3 channels):
RMAN> RUN
{
set until scn 2263395974237;
SET ARCHIVELOG DESTINATION TO '+DATA_TEMP';
RESTORE DATABASE;
RECOVER DATABASE;
}
Then, most of the channels datafiles are created to the spcified diskgroup +DATA_TEMP, but channels 1,2, contains datafiles that are created in +DATA diskgroup (total 5 files), which is very strange.
For example channel 2 looks like this:
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00003 to +DATA_TEMP/etoim/datafile/undotbs1.652.966969785
channel ORA_DISK_2: restoring datafile 00004 to +DATA_TEMP/etoim/datafile/undotbs2.655.966969837
channel ORA_DISK_2: restoring datafile 00006 to +DATA_TEMP/etoim/datafile/etoimik.641.966963059
channel ORA_DISK_2: restoring datafile 00010 to +DATA_TEMP/etoim/datafile/logi_old.648.966964307
channel ORA_DISK_2: restoring datafile 00011 to +DATA_TEMP/etoim/datafile/logi_old.661.966974365
channel ORA_DISK_2: restoring datafile 00012 to +DATA_TEMP/etoim/datafile/etoimik.643.966963073
channel ORA_DISK_2: restoring datafile 00013 to +DATA_TEMP/etoim/datafile/logi_old.650.966966799
channel ORA_DISK_2: restoring datafile 00014 to +DATA_TEMP/etoim/datafile/logi_old.651.966968271
channel ORA_DISK_2: restoring datafile 00015 to +DATA_TEMP/etoim/datafile/logi_old.646.966964231
channel ORA_DISK_2: restoring datafile 00016 to +DATA_TEMP/etoim/datafile/logi_old.647.966964305
channel ORA_DISK_2: restoring datafile 00020 to +DATA_TEMP/etoim/datafile/logi_old.640.966963059
channel ORA_DISK_2: restoring datafile 00022 to +DATA_TEMP/etoim/datafile/logi_old.645.966964231
channel ORA_DISK_2: restoring datafile 00024 to +DATA_TEMP/etoim/datafile/logi_old.649.966965501
channel ORA_DISK_2: restoring datafile 00026 to +DATA_TEMP/etoim/datafile/logi_old.642.966963059
channel ORA_DISK_2: restoring datafile 00027 to +DATA/etoim/osa/osa01.dbf
channel ORA_DISK_2: restoring datafile 00031 to +DATA_TEMP/etoim/datafile/logi_old.644.966963079
channel ORA_DISK_2: restoring datafile 00046 to +DATA_TEMP/etoim/datafile/dummy.654.966970049
channel ORA_DISK_2: restoring datafile 00052 to +DATA_TEMP/etoim/datafile/etoimik.591.966953801
channel ORA_DISK_2: restoring datafile 00055 to +DATA_TEMP/etoim/datafile/etoimik.594.966953811
channel ORA_DISK_2: restoring datafile 00058 to +DATA/etoim/datafile/etoimik.306.946765381
channel ORA_DISK_2: restoring datafile 00060 to +DATA/etoim/datafile/etoimik.371.946765575
channel ORA_DISK_2: restoring datafile 00063 to +DATA/etoim/datafile/etoimik.367.955274057
channel ORA_DISK_2: restoring datafile 00071 to +DATA_TEMP/etoim/datafile/arhiiv.600.966953831
channel ORA_DISK_2: restoring datafile 00072 to +DATA_TEMP/etoim/datafile/arhiiv.597.966953821
channel ORA_DISK_2: restoring datafile 00076 to +DATA_TEMP/etoim/datafile/logipart0.657.966971645
channel ORA_DISK_2: restoring datafile 00077 to +DATA_TEMP/etoim/datafile/logipart1.653.966971495
channel ORA_DISK_2: restoring datafile 00079 to +DATA_TEMP/etoim/datafile/logipart1.656.966971507
channel ORA_DISK_2: restoring datafile 00082 to +DATA_TEMP/etoim/datafile/logi.659.966974283
channel ORA_DISK_2: restoring datafile 00085 to +DATA_TEMP/etoim/datafile/logi.658.966971807
channel ORA_DISK_2: restoring datafile 00088 to +DATA_TEMP/etoim/datafile/logi.660.966974331
channel ORA_DISK_2: reading from backup piece xxxxxxx/xxxxxxxxx/ETOIM/full/incr0_20180124_s63686_p1_66sph1f4_1_1
DG +DATA_TEMP has also 1.2TB free space, and database, which I am restoring, is at max 700GB
Anyone have idea..?
Thanks in advance..
Regards
Raul