Home » RDBMS Server » Backup & Recovery » Restore database problem (Oracle 10gR2, Red Hat AS 4)
icon5.gif  Restore database problem [message #318270] Tue, 06 May 2008 05:32 Go to next message
mafc73
Messages: 38
Registered: November 2006
Member
Hi,

I want to copy a database that it's in production environment to another host. The steps that I follow are :

- Mark all tablespaces in begin backup mode.
- Copy all datafiles, controlfiles, redo logs, spfile to the new host.
- In the new host I have created the directory structure for trace files,...
- I get the create controlfile command with ALTER DATABASE BACKUP CONTROLFILE TO TRACE.

- Now in the new host:

- STARTUP NOMOUNT;
- Execute the script for the create controlfile
- After that I execute the recover database and I get an ORA-1110.


- RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

....

Especificar log: {<RET>=sugerido | nombre_archivo | AUTO | CANCEL}

ORA-00279: el cambio 613840 generado en 04/17/2008 14:04:50 es necesario para
el thread 1
ORA-00289: sugerencia: /oradata/TITAN/arch/TITAN_1_36_651664379.dbf
ORA-00280: el cambio 613840 para el thread 1 esta en la secuencia numero 36
ORA-00278: el archivo log '/oradata/TITAN/arch/TITAN_1_35_651664379.dbf' ya no
es necesario para esta recuperacion


Especificar log: {<RET>=sugerido | nombre_archivo | AUTO | CANCEL}
CANCEL
ORA-01547: advertencia: RECOVER ha funcionado correctamente pero OPEN RESETLOGS
obtendria el siguiente error
ORA-01195: la copia de seguridad online del archivo 1 necesita mas recuperacion
para ser consistente
ORA-01110: archivo de datos 1: '/oradata/TITAN/system01.dbf'



- If I try to open I get the error.

SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR en línea 1:
ORA-01195: la copia de seguridad online del archivo 1 necesita mas recuperacion
para ser consistente
ORA-01110: archivo de datos 1: '/oradata/TITAN/system01.dbf'




I don't know what is the problem.


Thanks.




Re: Restore database problem [message #318411 is a reply to message #318270] Tue, 06 May 2008 16:03 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you take the tablespaces out of backup mode?
Re: Restore database problem [message #318636 is a reply to message #318270] Wed, 07 May 2008 06:44 Go to previous message
mafc73
Messages: 38
Registered: November 2006
Member
It was the problem, the tablespaces in the database origin were in BEGIN BACKUP mode.

Thanks.

Previous Topic: error in tns connection
Next Topic: ORA-01190 on alter database open resetlogs after restore
Goto Forum:
  


Current Time: Sun Dec 04 10:46:28 CST 2016

Total time taken to generate the page: 0.07361 seconds