Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • 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 GruwezOracle 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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