Home » RDBMS Server » Backup & Recovery » HOT backup Question
HOT backup Question [message #192864] Thu, 14 September 2006 00:16 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Wht happens if any update happen during hot backup of database.Will it write the update info only to redologs?Are all datafiles are completely locked from any changes?

Report message to a moderator

Re: HOT backup Question [message #192877 is a reply to message #192864] Thu, 14 September 2006 01:15 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
it is supposed to write update information to redo-logs.

the datafile header is frozen.

u need not worry if any update/delete/insert/select takes place during hot-backups.

infact that is the actual purpose of hot-backups.

alter tablespace <tbs> begin backup;

hopefully u are refering to above command.

unless u have a different meaning to the word HOT

Smile

Report message to a moderator

Re: HOT backup Question [message #192878 is a reply to message #192864] Thu, 14 September 2006 01:20 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
So once after we issue command END BACKUP,all infor in redo logs will write to datafiles automatically,right ?
and how about archiver,wil it archive the log very immediately?

Report message to a moderator

Re: HOT backup Question [message #192929 is a reply to message #192877] Thu, 14 September 2006 04:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
alter tablespace <tbs> begin backup;
hopefully u are refering to above command.
unless u have a different meaning to the word HOT

Said method is old. It has a lot of drawbacks.
Use RMAN. No need put the tablespaces in begin backup/end backup mode.

Report message to a moderator

Re: HOT backup Question [message #192930 is a reply to message #192878] Thu, 14 September 2006 04:52 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Wht happens if any update happen during hot backup ....
http://www.orafaq.com/forum/m/149622/42800/?srch=Tim+Gorman#msg_149622

Report message to a moderator

Previous Topic: Datafile Missing...not able to connect
Next Topic: Recovery Scenarios
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 03:27:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.