x

How can a Full Backup be performed when the database is open ?

I want to take a backup of my database when it is opened. Can anyone help me pls.

more ▼

asked Dec 19, 2009 at 12:13 AM in Default

OraLearner gravatar image

OraLearner
1.3k 79 86 88

You want to research a 'hot backup'. As you can imagine, not every database can be shutdown for maint activities, so it's a pretty common requirement to do backups with the database open.
Dec 19, 2009 at 07:04 AM HillbillyToad
Thank you for your answer. Hot mode backup worked for me.
Dec 21, 2009 at 08:14 AM OraLearner
If you are using Hot Backup and a SAN or NAS you may be able to speed up your backup time by using their Snapshot feature. We used to perform hot backups by going into hot backup mode and then copying the datafiles to another device. Very resource intensive. Our NetApp filers allow us to take a 'Snapshot' of files on disk and revert to them at any time so we started using that feature instead of copying files. Our hot backups now take only a few minutes and most of that time is switching in and out of Hot Backup mode within the Oracle database.
Jan 04, 2010 at 11:49 AM dmann
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Here's Oracle's explanation of what's available to you in 11g:

DB Backup Techniques at Oracle

And you probably want to read up on RMAN, the Recovery Manager, which automates backup and recovery:

RMAN at Oracle

If you have an older version, things may be different for you. I don't believe RMAN is new to 11 but I am not sure.

more ▼

answered Dec 19, 2009 at 12:45 AM

KillerDBA gravatar image

KillerDBA
1.5k 8 9 10

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x244
x194

asked: Dec 19, 2009 at 12:13 AM

Seen: 917 times

Last Updated: Jan 28, 2010 at 11:22 AM