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

backup-l

When we backup the database the backup will go to the default location..?

how we will change the default location..
0
dev_dba
Asked:
dev_dba
1 Solution
 
Geert GOracle dbaCommented:
it depends how you backup
if you run rman with "backup database" it will go to the default location

logging into rman command line:
(change orcl with the sid of your oracle database)
set oracle_sid=orcl
rman target /

Open in new window

you can see the default device config with this:

rman>show default device type;

Open in new window

%F is the default format option for disk (see below for link)

you can change the default device configuration in rman to backup to a different default location
to place the backups in folder 'd:\oracle_backups\orcl'

configure default device type to disk format 'd:\oracle_backups\%F';

Open in new window


if you want other options for the format:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsubcl010.htm#BABBCDDA
0
 
DavidSenior Oracle Database AdministratorCommented:
Or are you using a tool other than RMAN?
0
 
dev_dbaAuthor Commented:
Thank you under stood the command for backup location other default location..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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