jump to navigation

Backup Oracle Database using RMAN Mei 10, 2007

Posted by Tyo in Oracle.
trackback

connecting to RMAN via command line :rman TARGET SYS/target_pwd@target_strexample : rman target /


Configuring RMAN Environment :CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE RETENTION POLICY TO REDUNDANCY 3; CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘d:\orclbackupora_df%t_s%s_s%p’;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP

FORMAT FOR DEVICE TYPE DISK TO ‘d:\orclbackupora_cf%F’;

CONFIGURE BACKUP OPTIMIZATION ON;


to view the configuration that has been made : Show all


to Backup Database : BACKUP DATABASE PLUS ARCHIVELOG;


if finish with RMAN to close the dialog type : EXIT


hope this will help.

Komentar»

1. Kourosh - Juni 5, 2007

Hi
It is quite useful but what are the steps to restore these exact backups?

actually, i create this just for reminder for myself the command for backup database using RMAN. for recovering if a lot of people want it i can write down. because it is a lot, and depend on the problem. thank you.