Oracle 11.2.0.3.9
Solaris 10
I have a standby database that I would like to copy and turn the copy into another standalone disaster recovery database. I took a "backup as copy" of the standby and generated a controlfile from the primary with "alter database backup controlfile to trace ...".
I edited the controlfile, but am now running in to issues with my recover. I would like to recover to 11AM, but I am getting an ORA-600 error at the end of the recover and the datafiles have a checkpoint_time of 10:40:46AM. Here is the problem:
hood>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 8 11:35:47 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> recover database using backup controlfile until time '2014-10-08:11:00:00';
ORA-00279: change 90406997774 generated at 10/08/2014 10:40:46 needed for
thread 1
ORA-00289: suggestion : /oracle/logs/NFDR/arch_598887_1_527943760.dbf
ORA-00280: change 90406997774 for thread 1 is in sequence #598887
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00600: internal error code, arguments: [2619], [598887], [], [], [], [],
[], [], [], [], [], []
SQL> select file#, to_char(checkpoint_time, 'YYYYMMDD HH24:MI:SS' ) from v$datafile_header order by 2;
FILE# TO_CHAR(CHECKPOIN
---------- -----------------
1 20141008 10:40:46
2 20141008 10:40:46
...
I have provided all the archivelogs (plus more) to the new database. On the primary:
SELECT name, sequence#, first_time, next_time FROM V$ARCHIVED_LOG WHERE SEQUENCE# <= 598889 AND name != 'nfpo_stby' ORDER BY SEQUENCE# DESC;
| /archive01/NFPO/arch_598889_1_527943760.dbf | 598889 | 10/8/2014 11:34:05 AM | 10/8/2014 11:55:26 AM |
| /archive01/NFPO/arch_598888_1_527943760.dbf | 598888 | 10/8/2014 11:09:44 AM | 10/8/2014 11:34:05 AM |
| /archive01/NFPO/arch_598887_1_527943760.dbf | 598887 | 10/8/2014 10:40:46 AM | 10/8/2014 11:09:44 AM |
| /archive01/NFPO/arch_598886_1_527943760.dbf | 598886 | 10/8/2014 9:57:15 AM | 10/8/2014 10:40:46 AM |
| /archive01/NFPO/arch_598885_1_527943760.dbf | 598885 | 10/8/2014 9:03:03 AM | 10/8/2014 9:57:15 AM |
| /archive01/NFPO/arch_598884_1_527943760.dbf | 598884 | 10/8/2014 8:30:11 AM | 10/8/2014 9:03:03 AM |
| /archive01/NFPO/arch_598883_1_527943760.dbf | 598883 | 10/8/2014 8:07:23 AM | 10/8/2014 8:30:11 AM |
| /archive01/NFPO/arch_598882_1_527943760.dbf | 598882 | 10/8/2014 8:05:53 AM | 10/8/2014 8:07:23 AM |
| /archive01/NFPO/arch_598881_1_527943760.dbf | 598881 | 10/8/2014 7:33:29 AM | 10/8/2014 8:05:53 AM |
SQL> show parameter log_archive_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string LOCATION=/oracle/logs/NFDR
...
hood>cd /oracle/logs/NFDR
hood>ls -lah
total 3170612
drwxr-xr-x 2 oracle dba 512 Oct 8 11:35 .
drwxr-xr-x 4 oracle dba 512 Oct 8 09:01 ..
-rw-r----- 1 oracle dba 173M Oct 8 11:03 arch_598881_1_527943760.dbf
-rw-r----- 1 oracle dba 174M Oct 8 11:04 arch_598882_1_527943760.dbf
-rw-r----- 1 oracle dba 175M Oct 8 11:04 arch_598883_1_527943760.dbf
-rw-r----- 1 oracle dba 169M Oct 8 11:04 arch_598884_1_527943760.dbf
-rw-r----- 1 oracle dba 168M Oct 8 11:04 arch_598885_1_527943760.dbf
-rw-r----- 1 oracle dba 168M Oct 8 11:04 arch_598886_1_527943760.dbf
-rw-r----- 1 oracle dba 200M Oct 8 11:04 arch_598887_1_527943760.dbf
-rw-r----- 1 oracle dba 121M Oct 8 11:34 arch_598888_1_527943760.dbf
-rw-r----- 1 oracle dba 200M Oct 8 11:35 arch_598889_1_527943760.dbf
Why is my database only recovering to 10:40AM, not 11AM?