Home » RDBMS Server » Server Administration » Problem to copy database from the hot backup
Problem to copy database from the hot backup [message #195592] Fri, 29 September 2006 10:16 Go to next message
alexre2005
Messages: 7
Registered: March 2005
Location: Montreal,Canada
Junior Member
Oracle9i Enterprise Edition Release 9.2.0.4.0
SunOS 5.8

Hi all,

I wrote the UNIX script to copy the production Oracle 9i database from the hot backup to the Oracle 9i development database. I already did it manually without any problems using Metalink document Note:18070.1

The script stops after the command

recover database until cancel using backup controlfile ,

because I have to apply all archived logs manually.

How is it possible to get rid of this problem and automatically apply archived logs?

Thank you in advance for your help.

Alex
P.S. We are not authorized to use RMAN.


Re: Problem to copy database from the hot backup [message #195614 is a reply to message #195592] Fri, 29 September 2006 12:36 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
on sqlplus

"set autorecovery on"

and rerun recover command

Sandeep
Previous Topic: FIND SCM
Next Topic: ORA-12750 - Cannot access NLS data files or invalid environment specified
Goto Forum:
  


Current Time: Fri Sep 20 06:51:33 CDT 2024