Hi All;
SOURCE DB : hrms
CLONE DB : orcl
Using hot backup , i tried to clone a database.
But i cannot apply archivelogs for clone database because oracle is expecting .dbf format.
In FRA , existing archive logs are .arc format
but expected archive logs are .dbf format
>> STARTING CLONE DB
$ export ORACLE_SID=orcl
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 21 20:29:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SYS>startup nomount;
ORACLE instance started.
Total System Global Area 373293056 bytes
Fixed Size 1219496 bytes
Variable Size 113247320 bytes
Database Buffers 255852544 bytes
Redo Buffers 2973696 bytes
SYS>@/u01/trace.sql;
Control file created.
SYS>archive log list;
Database log mode Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
SYS> set logsource '/u01/app/oracle/flash_recovery_area/HRMS/archivelog/2014_10_21';
SYS>recover database using backup controlfile until cancel;
ORA-00279: change 520351 generated at 10/21/2014 20:12:17 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/HRMS/archivelog/2014_10_21/1_4_861549175.dbf
ORA-00280: change 520351 for thread 1 is in sequence #4
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/u01/app/oracle/flash_recovery_area/HRMS/archivelog/2014_10_21/1_4_861549175.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log
'/u01/app/oracle/flash_recovery_area/HRMS/archivelog/2014_10_21/1_4_861549175.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
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/orcl/system01.dbf'
>> ARCHIVE LOGS FOR SOURCE DATABASE in FRA
$ pwd
/u01/app/oracle/flash_recovery_area/HRMS/archivelog/2014_10_21
[oracle@oel5 2014_10_21]$ ls -l
total 12256
-rw-r----- 1 oracle oinstall 1024 Oct 21 20:36 o1_mf_1_10_b4dxncmq_.arc
-rw-r----- 1 oracle oinstall 1024 Oct 21 20:36 o1_mf_1_11_b4dxndvx_.arc
-rw-r----- 1 oracle oinstall 8578560 Oct 21 18:42 o1_mf_1_2_b4dpy6w6_.arc
-rw-r----- 1 oracle oinstall 3112960 Oct 21 20:07 o1_mf_1_3_b4dvxp2s_.arc
-rw-r----- 1 oracle oinstall 233472 Oct 21 20:20 o1_mf_1_4_b4dwo9vd_.arc
-rw-r----- 1 oracle oinstall 1024 Oct 21 20:21 o1_mf_1_5_b4dwq49p_.arc
-rw-r----- 1 oracle oinstall 2048 Oct 21 20:21 o1_mf_1_6_b4dwr5nn_.arc
-rw-r----- 1 oracle oinstall 568320 Oct 21 20:36 o1_mf_1_7_b4dxn4gq_.arc
-rw-r----- 1 oracle oinstall 1024 Oct 21 20:36 o1_mf_1_8_b4dxn5k9_.arc
-rw-r----- 1 oracle oinstall 1536 Oct 21 20:36 o1_mf_1_9_b4dxnbby_.arc
Thanks in advance.