Manage Oracle Archivelogs

[BERTHOLD Jean]

Hi,   I need to apply archivelogs on a standby database using perl script Can you help me to find the correct syntax to execute the following sql command using the DBD::Oracle module ?     sqlplus /nolog connect / as sysdba ; RECOVER STANDBY DATABASE AUTO exit ;     I need to validate the "AUTO" parameter  with the  RETURN  key and finally exit sqlplus programm.   Is it possible to do that using DBI and DBD Perl modules ?   I tried by using Here document but unsuccessfully ...   Another Tool could be "Expect" module but I cannot find how to use it with DBI/DBD modules ...   Below the sqlplus output when I apply archivelogs manually. I cannot use automatic recovery because I use Oracle Standard Edition   Thanks for your help and have a nice day !   Jean Berthold     [EMAIL PROTECTED] [PWJA] # sqlplus /nolog SQL*Plus: Release 9.2.0.4.0 - Production on Sun Jun 20 12:20:33 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect / as sysdba Connected. SQL> RECOVER STANDBY DATABASE ; ORA-00279: change 7735497 generated at 06/16/2004 23:03:42 needed for thread 1 ORA-00289: suggestion : /u01/oracle/admin/PWJA/arch/arch_PWJA_582.arc ORA-00280: change 7735497 for thread 1 is in sequence #582 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} AUTO ... ... ...   ORA-00279: change 7941174 generated at 06/19/2004 23:07:07 needed for thread 1 ORA-00289: suggestion : /u01/oracle/admin/PWJA/arch/arch_PWJA_726.arc ORA-00280: change 7941174 for thread 1 is in sequence #726 ORA-00278: log file '/u01/oracle/admin/PWJA/arch/arch_PWJA_725.arc' no longer needed for this recovery ... ... ... SQL>                 EOS Holding Jean Berthold Administrateur Unix & Oracle Unité Gestion de l'infrastructure Team Systèmes Ch. de Mornex 10 Tél. +41(0)21 341 24 58 Fax +41(0)21 341 20 49 jean.berthold@eosholding.ch

<<tech.gif>>