Re: Backup en Caliente

> SQl > STARTUP MOUNT
>
> SQL >RECOVER DATABASE USING BACKUP CONTROLFILE;
>
> ...The system request archive log files:
> ORA-00279: el cambio 618807 generado en 04/05/2006 08:19:34 es
> necesario para el thread 1
> ORA-00289: sugerencia: D:\ORACLE\ORADATA\RECORV\ARCHIVE\1_2.DBF
> ORA-00280: el cambio 618807 para el thread 1 está en la secuencia
> número 2
>
>
> Especificar log: {<RET>=sugerido | nombre_archivo | AUTO | CANCEL}
>
> I don`t know why. Can anyone tell me what I did wrong?
>
> Other question: If ,for example, I drop the database and I recreate it
> but
> (without users, tablespaces, etc.., only database).Is it possible
> recovery the original database from d:\backup\?.

Have you read the Backup and Recovery documentation? It shows you how to perform this type of recovery. Copies for Oracle 10g can be found here:

http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm

Each failure scenario has different recovery options. Losing a datafile, a disk, a control file, an online redo log...all have different recovery options. As does recovering the entire database from a failure. Sounds like a lot? Then consider using RMAN to help you manage both your backup and your recovery operations.

For your specific question, have you tried hitting RETURN at the prompt? It will automatically apply the suggest archived redo log for you. You can also reply AUTO to have Oracle automatically apply all archived redo logs it knows about as well. Once done applying recovery, you may have to open the database with RESETLOGS. Again...all of this is fully covered in the backup and recovery documentation. Plus, the Oracle Backup and Recovery Handbook by Velpuri and Adkoli on Oracle Press is pretty good about going through these different scenarios.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown