Home » RDBMS Server » Backup & Recovery » clone database using hot backup on windows (oracle 10g, windows)
clone database using hot backup on windows [message #308649] Tue, 25 March 2008 02:30 Go to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
Hi Experts,
i am in the process of cloning the database from prod to test on windows. we are netapps backup. in the scripts
the scripts look like this:
alter database backup control file to o:\...\..\*.bak
after this have to start up the database in mount stage and then we have to issue a command
recover database until cancel using backup controlfile;
but i am getting an error.
ORA-01195:online backup of file 1 needs more recoery to be consistent
ORA-01110:data file 1:'U:\ORACLE\ORADATA\SPACES\SYSTEM01.DBF'

could anybody please help me out.

Thanks,
Sheldon
Re: clone database using hot backup on windows [message #308655 is a reply to message #308649] Tue, 25 March 2008 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Continue to recover, don't cancel it
2/ Did you close the database or put it in backup mode during backup?

Regards
Michel
Re: clone database using hot backup on windows [message #308667 is a reply to message #308655] Tue, 25 March 2008 02:57 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
yes during backup i put the database in backup mode
Re: clone database using hot backup on windows [message #308668 is a reply to message #308667] Tue, 25 March 2008 02:58 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
when i issue the recover command
it asked me for auto cancel
i fired auto
then i got this error
Re: clone database using hot backup on windows [message #308676 is a reply to message #308668] Tue, 25 March 2008 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste your session.
Don't forget to format it as speficied in OraFAQ Forum Guide, "How to format your post?" section.

Regards
Michel
Re: clone database using hot backup on windows [message #308679 is a reply to message #308676] Tue, 25 March 2008 03:38 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
what is the wrong with this post??
Re: clone database using hot backup on windows [message #308688 is a reply to message #308679] Tue, 25 March 2008 03:57 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing, just copy and paste your session and when you will do this format it.

Regards
Michel
Previous Topic: RMAN restore validate
Next Topic: Restoration throuh Rman
Goto Forum:
  


Current Time: Sat Dec 03 18:29:19 CST 2016

Total time taken to generate the page: 0.08759 seconds