Home » RDBMS Server » Backup & Recovery » User Managed Backups
User Managed Backups [message #236199] Wed, 09 May 2007 04:59 Go to next message
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

Re: User Managed Backups [message #236203 is a reply to message #236199] Wed, 09 May 2007 05:13 Go to previous messageGo to next message
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
Re: User Managed Backups [message #236205 is a reply to message #236203] Wed, 09 May 2007 05:15 Go to previous messageGo to next message
balaji1010
Messages: 35
Registered: March 2006
Location: London
Member

Thanx sriram

I got it

thanx a lot
Re: User Managed Backups [message #239347 is a reply to message #236203] Tue, 22 May 2007 01:37 Go to previous messageGo to next message
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.
Re: User Managed Backups [message #239349 is a reply to message #239347] Tue, 22 May 2007 01:45 Go to previous messageGo to next message
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

Re: User Managed Backups [message #239360 is a reply to message #239349] Tue, 22 May 2007 02:27 Go to previous messageGo to next message
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
Re: User Managed Backups [message #239361 is a reply to message #239360] Tue, 22 May 2007 02:29 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

http://dbataj.blogspot.com/2007/03/shiftoracleserverfromonemachinetoanothe.html
Previous Topic: IMP-00017 problem
Next Topic: Loss due to media failure
Goto Forum:
  


Current Time: Wed Dec 07 16:21:33 CST 2016

Total time taken to generate the page: 0.09335 seconds