Newbie DBA
DB: Oracle 10 g OS: windows
I have 2 databases A(production) and B(Standby- DR) . I am manually copying the archive log files from A to B and applying it .
SQL> recover standby database;
ORA-00279: change 23515270208 generated at 10/13/2010 10:59:39 needed for
thread 1
ORA-00289: suggestion :
H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74498_0665930822_001.ARC
ORA-00280: change 23515270208 for thread 1 is in sequence #74498
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 23515555165 generated at 10/13/2010 11:43:46 needed for
thread 1
ORA-00289: suggestion :
H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74499_0665930822_001.ARC
ORA-00280: change 23515555165 for thread 1 is in sequence #74499
ORA-00278: log file 'H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74498_0665930822_001.ARC'
no longer needed for this recovery
ORA-00279: change 23515638382 generated at 10/13/2010 12:18:50 needed for
thread 1
ORA-00289: suggestion :
H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74500_0665930822_001.ARC
ORA-00280: change 23515638382 for thread 1 is in sequence #74500
ORA-00278: log file 'H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74499_0665930822_001.ARC'
no longer needed for this recovery
ORA-00279: change 23515659690 generated at 10/13/2010 12:18:55 needed for
thread 1
ORA-00289: suggestion :
H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74501_0665930822_001.ARC
ORA-00280: change 23515659690 for thread 1 is in sequence #74501
ORA-00278: log file 'H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74500_0665930822_001.ARC'
no longer needed for this recovery
ORA-00279: change 23516026341 generated at 10/13/2010 12:19:25 needed for
thread 1
ORA-00289: suggestion :
H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74502_0665930822_001.ARC
ORA-00280: change 23516026341 for thread 1 is in sequence #74502
ORA-00278: log file 'H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74501_0665930822_001.ARC'
no longer needed for this recovery
ORA-00279: change 23516535747 generated at 10/13/2010 12:20:02 needed for
thread 1
ORA-00289: suggestion :
H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74503_0665930822_001.ARC
ORA-00280: change 23516535747 for thread 1 is in sequence #74503
ORA-00278: log file 'H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74502_0665930822_001.ARC'
no longer needed for this recovery
ORA-00279: change 23516855012 generated at 10/13/2010 12:20:30 needed for
thread 1
ORA-00289: suggestion :
H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74504_0665930822_001.ARC
ORA-00280: change 23516855012 for thread 1 is in sequence #74504
ORA-00278: log file 'H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74503_0665930822_001.ARC'
no longer needed for this recovery
ORA-00279: change 23516876618 generated at 10/13/2010 12:20:42 needed for
thread 1
ORA-00289: suggestion :
H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74505_0665930822_001.ARC
ORA-00280: change 23516876618 for thread 1 is in sequence #74505
ORA-00278: log file 'H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74504_0665930822_001.ARC'
no longer needed for this recovery
ORA-00308: cannot open archived log
'H:\ORACLE\ORA10G\DPM\ARCHP\DPMLOG74505_0665930822_001.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>
Please tell me if there is anything wrong ?
Edited by: Renjith Madhavan on Oct 13, 2010 3:00 PM