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

Report message to a moderator

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: 68650
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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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: 68650
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

Report message to a moderator

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??

Report message to a moderator

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: 68650
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 13 22:27:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.