Discussion :

[agdid04]

Bonjour,
J'ai restoré une base 10.2.0.4 sur une autre machine (même OS AIX 5L):
- Restoration spfile OK.
- Restoration controlfiles OK.
- Restoration datafiles OK.
- Par contre après le recover, la base ne s'ouvre pas :

RMAN> recover database ;

Starting recover at 15-JUL-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=536 device type=DISK

starting media recovery

archived log for thread 1 with sequence 4631 is already on disk as file /oradata/base/TEST/redo02.log
archived log for thread 1 with sequence 4632 is already on disk as file /oradata/base/TEST/redo03.log
archived log for thread 1 with sequence 4633 is already on disk as file /oradata/base/TEST/redo01.log
archived log file name=/oradata/base/TEST/redo02.log thread=1 sequence=4631
archived log file name=/oradata/base/TEST/redo03.log thread=1 sequence=4632
archived log file name=/oradata/base/TEST/redo01.log thread=1 sequence=4633
media recovery complete, elapsed time: 00:00:14
Finished recover at 15-JUL-09

RMAN> sql 'alter database open RESETLOGS' ;

sql statement: alter database open RESETLOGS
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
ORA-03114: not connected to ORACLE
RMAN-03009: failure of sql command on default channel at 07/15/2009 14:46:34
RMAN-11003: failure during parse/execution of SQL statement: alter database open RESETLOGS
ORA-01092: ORACLE instance terminated. Disconnection forced

- J'ai essyé également de partir à partir de controlfile:

SQL> alter database recover using backup controlfile until cancel ;
alter database recover using backup controlfile until cancel
*

ERROR at line 1:

ORA-00279: change 184485599 generated at 07/15/2009 12:04:18 needed for thread
1
ORA-00289: suggestion :
/oradata/base/backup/archivelog/TEST/arch/1_4631_673126592.arc
ORA-00280: change 184485599 for thread 1 is in sequence #4631

La séquene #4631 n'a pas été encore généré au moment de la restore( dernière archive générée: #4630).

sql 'alter database open' n'a pas fonctionné non plus.

Est ce que j'aurais raté une marche ?

Merci de votre aide.
Crdlt,

[pifor]

Le but est-il de créer une copie de la base source ou de remplacer la base source ?
Vous avez utilisé RMAN DUPLICATE ?
Vous avez restauré manuellement les redo logs ?
Il faudrait poster les commandes de restauration et le contenu de l'alert.log depuis le début de la restauration.