Home » RDBMS Server » Backup & Recovery » what happen in hot backup mode, forgot put end bacup mode in oracle 11g R2 (oracle 11g R2 windows server 2008 R2)
what happen in hot backup mode, forgot put end bacup mode in oracle 11g R2 [message #555524] Thu, 24 May 2012 12:59 Go to next message
vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member
Hi all,

I have a scenario like while taking the hot backup i forgot put end backup mode,at the same time one of user u1 updating some lacks of records
into the T1 table.at some time he wants rollback.and my redolog file size is very less.is it possible to rollback? if yes how?

Thanks,
Vij
Re: what happen in hot backup mode, forgot put end bacup mode in oracle 11g R2 [message #555525 is a reply to message #555524] Thu, 24 May 2012 13:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
REDO is irrelevant to ROLLBACK; all that matters is UNDO.

You should be using RMAN for backups.
You should really Read The Fine Manual below.

http://docs.oracle.com/cd/E11882_01/server.112/e25789/toc.htm
Re: what happen in hot backup mode, forgot put end bacup mode in oracle 11g R2 [message #555566 is a reply to message #555525] Fri, 25 May 2012 02:29 Go to previous messageGo to next message
vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member
hi

My client wants manual backup only for QA environment.I need to take hot backup only,then what should i do?

Thanks,
Vij
Re: what happen in hot backup mode, forgot put end bacup mode in oracle 11g R2 [message #555572 is a reply to message #555566] Fri, 25 May 2012 03:01 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put the tablespace on backup mode, copy the tablespace files, put back the tablespace in normal mode.
Loop on all tablespaces.

Regards
Michel
Previous Topic: Ugrade from 10g to 11g (splitted from "what happen in hot backup mode, forgot put end bacup mode..."
Next Topic: recover truncate table data
Goto Forum:
  


Current Time: Thu Mar 28 05:04:35 CDT 2024