Q

Hot backup when Oracle Database is up

An Oracle user asks Database Backup and Recovery expert Brian Peasland the following question: "What is the procedure for doing a hot backup when the database is up?"

What is the procedure for doing a hot backup when the database is up?
There are two ways. The preferred way with Oracle's databases today is to use RMAN. The following will perform a hot backup using RMAN:

rman target /
run {
   allocate channel t1 type disk format '/dir/%d_FULL_%U ';
   backup database;
}

Alternatively, you can place a tablespace in hot backup mode by the following:

ALTER TABLESPACE ts_name BEGIN BACKUP;

Once a tablespace is in backup mode, you can use any OS utility to copy the tablespace's datafiles to the backup location. Once the tablespace backup is done, end the tablespace backup:

ALTER TABLESPACE ts_name END BACKUP;

Repeat for each tablespace.

Read more about hot backups and other backup and recovery issues in our Database storage management All-in-One Guide.

This was first published in June 2008

Dig deeper on Oracle database administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close