Home » RDBMS Server » Backup & Recovery » Clone database continues to give me this error
Clone database continues to give me this error [message #210606] Thu, 21 December 2006 08:59 Go to next message
bogey
Messages: 53
Registered: February 2006
Member
We are attempting to use the Enterprise Manager Grid Control to clone one of our databases. Twice now we've received this error.


SQL> Connected.
SQL> ORACLE instance started.

Total System Global Area 524288000 bytes
Fixed Size 790028 bytes
Variable Size 463729140 bytes
Database Buffers 58720256 bytes
Redo Buffers 1048576 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER AUTOMATIC FROM 'E:\oracle\product\10.1.0\Db_1\database\clone2_59' DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database


SQL> alter database recover cancel
*
ERROR at line 1:
ORA-01112: media recovery not started


SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options
Re: Clone database continues to give me this error [message #210607 is a reply to message #210606] Thu, 21 December 2006 09:03 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That appears to be a bug (4628253). You can try to turn off the flashback feature of the target database and then try the clone again.
Re: Clone database continues to give me this error [message #210613 is a reply to message #210607] Thu, 21 December 2006 09:27 Go to previous messageGo to next message
bogey
Messages: 53
Registered: February 2006
Member
Is this something that I can do when I'm setting up the clone job through EM GC?
Re: Clone database continues to give me this error [message #210617 is a reply to message #210613] Thu, 21 December 2006 09:37 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Not that I am aware of.
Previous Topic: exporting database
Next Topic: How long to keep archive logs on the server
Goto Forum:
  


Current Time: Tue Apr 30 01:15:26 CDT 2024