OraFAQ Forum: Backup & Recovery » what happen in hot backup mode, forgot put end bacup mode in oracle 11g R2

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what happen in hot backup mode, forgot put end bacup mode in oracle 11g R2 [message #555524]

Thu, 24 May 2012 12:59

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 67946
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 20 16:13:30 CDT 2021