Bonjour,

La démarche de la restauration à été la suivante :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
orastop
cp backup_hier.dbf en_cours.dbf
orastart
Et depuis impossible de relancer Oracle pour utilisation.

Avec Oracle Enterprise Manager j'ai ce message :
Connexion de l'agent à l'instance
Statut
Echec
Détails ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)
J'ai essayé de restaurer en effectuant la démarche suivante sans succes :
SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 1828716544 bytes
Fixed Size 2021640 bytes
Variable Size 335546104 bytes
Database Buffers 1476395008 bytes
Redo Buffers 14753792 bytes
Database mounted.
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00279: change 54745248 generated at 08/25/2008 20:30:58 needed for thread 1
ORA-00289: suggestion : /home/oracle/product/10.2.0/db_1/flash_recovery_area/SAGE/archivelog/2008_08_27/o1_mf_1_3255_%u_.arc
ORA-00280: change 54745248 for thread 1 is in sequence #3255


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/home/oracle/product/10.2.0/db_1/flash_recovery_area/SAGE/archivelog/2008_08_27/o1_mf_1_3255_%u_.arc'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/home/oracle/product/10.2.0/oradata/sage/system01.dbf'


SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/home/oracle/product/10.2.0/oradata/sage/system01.dbf'
J'attends vos réponses, merci d'avance.