Backup path in RMAN

How can you specify the path of backup file in RMAN?
Let's say if you want to back up files to F:\backup folder, how can  you tell RMAN?
jung1975Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
you have to configure the channel, for example:
ALLOCATE CHANNEL dev1 DEVICE TYPE DISK FORMAT 'F:\backup\%U';
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
mohammadzahidCommented:
Here you go.

Please goto this site and try out RMAN backup examples/demo

http://www.psoug.org/reference/rman.html
0
FayyazCommented:

Here is the script to take level 0 backup
 
run
 {
  shutdown immediate ;
  startup mount ;
  allocate channel d1 type disk format 'd:\da_%d_s%s_U%U';
  allocate channel d2 type disk format 'd:\backup\da_%d_s%s_U%U';
  allocate channel d3 type disk format 'c:\da_%d_s%s_U%U';
  allocate channel d4 type disk format 'c:\backup\da_%d_s%s_U%U';
  backup INCREMENTAL LEVEL = 0 database;
  alter database open ;
  release channel d1 ;
  release channel d2 ;
  release channel d3 ;
  release channel d4 ;
}

if you want to take full backup then replace below line
backup INCREMENTAL LEVEL = 0 database;
with
backup database;

0
gattu007Commented:
You can also configure the default channels as below

CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 10000 M MAXOPENFILES 4 FORMAT   '/orabackup/ora_backup_dest/LCDXPRD/RMAN/LCDXPRD_CH1_df%t_s%s_s%p';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK MAXPIECESIZE 10000 M MAXOPENFILES 4 FORMAT   '/orabackup/ora_backup_dest/LCDXPRD/RMAN/LCDXPRD_CH2_df%t_s%s_s%p';
CONFIGURE CHANNEL 3 DEVICE TYPE DISK MAXPIECESIZE 10000 M MAXOPENFILES 4 FORMAT   '/orabackup/ora_backup_dest/LCDXPRD/RMAN/LCDXPRD_CH3_df%t_s%s_s%p';
CONFIGURE CHANNEL 4 DEVICE TYPE DISK MAXPIECESIZE 10000 M MAXOPENFILES 4 FORMAT   '/orabackup/ora_backup_dest/LCDXPRD/RMAN/LCDXPRD_CH4_df%t_s%s_s%p';
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.