Hello, all.
I got the following task: restore database(tablespace) from user managed HOT backup.
So I got the following:
*2 node RAC ASM 12c
*Single Instance 12c
On RAC ASM:
I performed USER managed HOT backup:
1. SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;(number of logs)
2. SQL> ALTER DATABASE BEGIN BACKUP;
3. Copied SYSTEM, UNDOTBS1, TEST datafiles(cause I need to restore schema belonging to TEST tablespace) to file system using asmcmd:
ASMCMD [+data2/orcl/datafile] > cp SYSTEM.258.925569853 /u01/BACKUP/HOT/system.dbf
.....
4. SQL> ALTER DATABASE END BACKUP;
5. ALTER SYSTEM ARCHIVE LOG CURRENT;(number of logs)
6. Copied all ARCHIVE logs to backup directory using asmcmd.
On Single Instance:
1. Created pfile with the following:
.....
diagnostic_dest='/u01/app/oracle/admin'
compatible='12.1.0.2.0'
control_files='/u01/app/oracle/oradata/control01.ctl'
db_block_size=8192
db_name='TEMP'
cluster_database=false
log_archive_dest='/u01/app/oracle/admin/arch'
log_archive_format=%t_%s_%r.dbf
pga_aggregate_target=406m
pga_aggregate_limit=1024m
processes=300
sga_target=1218m
undo_tablespace='undotbs1'
undo_management=auto
_no_recovery_through_resetlogs=true
2. Created create_controlfile.sql script with the following:
CREATE CONTROLFILE SET DATABASE "TEMP" RESETLOGS ARCHIVELOG
MAXLOGFILES 4
MAXLOGMEMBERS 4
MAXDATAFILES 20
MAXINSTANCES 1
MAXLOGHISTORY 337
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/redo01' size 50m,
GROUP 2 '/u01/app/oracle/oradata/redo02' size 50m,
DATAFILE
'/u01/app/oracle/oradata/system.dbf',
'/u01/app/oracle/oradata/test.dbf',
'/u01/app/oracle/oradata/undotbs1.dbf'
CHARACTER SET AL32UTF8;
Then I copied files from HOT backup location on RAC server to Single Instance Server(system.dbf, test.dbf, undotbs.dbf, and all archive logs) on appropriate directories.
On Single Instance Server I do the following:
1.SQL > startup nomount pfile='/u01/app/oracle/product/12.1.0.2/db_1/dbs/inittemp.ora';
2. SQL>@/u01/app/oracle/create_controlfile.sql.sql;
3. SQL> recover database until time '2016-12-21:17:30:00' using backup controlfile;
When I did so I got the following message:
ERROR at line 1:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/system.dbf'
What I did wrong?
Please help me to resolve this issue...