Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you about how to specify backup to two directories when rman backup. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

A problem seen on itpub

1rman backup should be able to specify backup to two directories, right? So you don't have to copy it manually. How do you do that?

RMAN > CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

Old RMAN configuration parameters:

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

New RMAN configuration parameters:

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

New RMAN configuration parameters are successfully stored

Starting full resync of recovery catalog

Full resync complete

RMAN > CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT'd:\ backup\% Utopia:\ tools\% U'

Old RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT'd:\ backup\% Utility,'d:\ tools\% U'

New RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT'd:\ backup\% Utility,'d:\ tools\% U'

New RMAN configuration parameters are successfully stored

Starting full resync of recovery catalog

Full resync complete

Released channel: ORA_DISK_1

RMAN > show all

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION ON

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO'd:\ backup\% F'

CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT'd:\ backup\% U'

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT'd:\ backup\% Utility,'d:\ tools\% U'

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'D:\ ORACLE\ ORA92\ DATABASE\ SNCFPAUL.ORA'

# default

RMAN configuration has no stored or default parameters

RMAN > backup database format'd:\ backup\% Utopia:\ tools\% U'

Starting backup at 03-JAN-08

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=15 devtype=DISK

Channel ORA_DISK_1: starting full datafile backupset

Channel ORA_DISK_1: specifying datafile (s) in backupset

Input datafile fno=00001 name=D:\ ORACLE\ ORADATA\ PAUL\ SYSTEM01.DBF

Input datafile fno=00002 name=D:\ ORACLE\ ORADATA\ PAUL\ UNDOTBS01.DBF

Input datafile fno=00006 name=D:\ ORACLE\ ORADATA\ PAUL\ TS_TEST01.DBF

Input datafile fno=00003 name=D:\ ORACLE\ ORADATA\ PAUL\ INDX01.DBF

Input datafile fno=00005 name=D:\ ORACLE\ ORADATA\ PAUL\ USERS01.DBF

Input datafile fno=00004 name=D:\ ORACLE\ ORADATA\ PAUL\ TOOLS01.DBF

Channel ORA_DISK_1: starting piece 1 at 03-JAN-08

Channel ORA_DISK_1: finished piece 1 at 03-JAN-08 with 2 copies

Piece handle=D:\ BACKUP\ 4NJ57K6P_1_1 comment=NONE

Piece handle=D:\ TOOLS\ 4NJ57K6P_1_2 comment=NONE-backup files generated under two paths

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:57

Finished backup at 03-JAN-08

Starting Control File and SPFILE Autobackup at 03-JAN-08

Piece handle=D:\ BACKUP\ C Mel 1605165889-20080103-01 comment=NONE

Finished Control File and SPFILE Autobackup at 03-JAN-08

The above is how to specify the backup to two directories when the rman backup is shared by the editor. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.