Performing “Hot” Backups in Oracle

Basically you have two ways to perform backups. 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 the 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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s