FAQ
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


oracle@udaipur [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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupbeginners @
categoriesperl
postedJun 20, '04 at 10:51a
activeJun 20, '04 at 10:51a
posts1
users1
websiteperl.org

1 user in discussion

BERTHOLD Jean: 1 post

People

Translate

site design / logo © 2021 Grokbase