• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

location

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'I:\Ora-Backup\DB001\BKP_%U';
RMAN> run
2> {
3> backup database;
4> backup archivelog all;
5> }


When we give this command

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'I:\Ora-Backup\DB001\BKP_%U';


All the backup will go to that location

full datbaase and archivelog..
0
tonydba
Asked:
tonydba
2 Solutions
 
Wasim Akram ShaikCommented:
Yes, back up will go to the location specified in the channel, but there can be more than one channel configured

 If you have multiple channels allocated, then check what all are configured in RMAN  by typing this command

RMAN > show all;

this will list you out all the parameters where in you can check how many channels are configured,

check output of show all command after you run your command and check for these words

CONFIGURE CHANNEL DEVICE TYPE, you can verify the output going to the location after setting the parameter
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
We can also override these setting by manually allocating the channels  and defining the new locations in the backup script as show below

RUN
{
  ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT = '/backup/BKP_%U';
  backup database plus archivelog delete input;

}
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now