OraFAQ Forum: Backup & Recovery » User Managed Backups

Home » RDBMS Server » Backup & Recovery » User Managed Backups

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

User Managed Backups [message #236199]

Wed, 09 May 2007 04:59

balaji1010
Messages: 35
Registered: March 2006
Location: London

Member

Hi everyone,

I am working on user managed backups.

I am still skeptical about what exactly happens when a datafile or database is placed in begin backup mode.

I know that excessive redo is generated and datafiles header is freezed to avoid SCN changing.

Can anyone tell me what exactly is written to the datafile.

Since i have to start a new thread i am posting the question again.

Please cooperate

thanx

Report message to a moderator

Re: User Managed Backups [message #236203 is a reply to message #236199]

Wed, 09 May 2007 05:13

sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM

Member

Hi

Oracle will do a datafile checkpoint just when the tablespace is in hotbackup mode.While hotbackup is in progress Oracle locks the file headers so that SCN/checkpoint details are not written during the hot backup.
This is to ensure that Oracle knows from which time to apply redo logs when the hot backup is restored (ie. from the point of time that the file was placed in backup mode).

All the updates and inserts happen as normal ie changing the data blocks.

Thanks

Report message to a moderator

Re: User Managed Backups [message #236205 is a reply to message #236203]

Wed, 09 May 2007 05:15

balaji1010
Messages: 35
Registered: March 2006
Location: London

Member

Thanx sriram

I got it

thanx a lot

Report message to a moderator

Re: User Managed Backups [message #239347 is a reply to message #236203]

Tue, 22 May 2007 01:37

atif_arl
Messages: 15
Registered: May 2007

Junior Member

Please tell me that after taking backups of control, data and redo file including password and spfile ,
what i have to done to restore them.

Report message to a moderator

Re: User Managed Backups [message #239349 is a reply to message #239347]

Tue, 22 May 2007 01:45

balaji1010
Messages: 35
Registered: March 2006
Location: London

Member

Well, it depends on the situation.

first point is, what kind of backups you have ? User managed or RMAN

if you have user managed backups, then it depends on what file you lost.

for example : if you have lost datafile 4 for instance then you need to put the datafile in offline mode and go for restoration.

Restoration means : in user managed you need to simply restore using copy command, implies, copy the datafile 4 from backup location to target database location.

Then perform recovery in target database.

Recover datafile 4;

then bring the datafile online.

But let me know what is the scenario.

hope this helps

thanx

Report message to a moderator

Re: User Managed Backups [message #239360 is a reply to message #239349]

Tue, 22 May 2007 02:27

atif_arl
Messages: 15
Registered: May 2007

Junior Member

Thanks for Information,
Friend,
Basically i am trying to prepare same copy of database on another machine.
Suppose i have 2 machines AA and BB.
If i take cold backup of database from AA,
i want to create a copy of database on BB using these files.
How is it possible ?
on which location on BB, i will copy these files and what more after copying these files, i have to do ?

Waiting for Reply,

Thanks & Regards,
Atif Mahmood

Report message to a moderator

Re: User Managed Backups [message #239361 is a reply to message #239360]

Tue, 22 May 2007 02:29

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

http://dbataj.blogspot.com/2007/03/shiftoracleserverfromonemachinetoanothe.html

Report message to a moderator

Previous Topic:	IMP-00017 problem
Next Topic:	Loss due to media failure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 17:14:29 CST 2024