Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN writing to $ORACLE_HOME/dbs Directory

jarymoJan 5 2015 — edited Jan 27 2015

Hi,

Rman is writing what looks like backupsets for archive logs to $ORACLE_HOME/dbs.  \

This is a 2 node rac and the archvie logs are not on a shared file system so I have 2 channels configured as connect* to the other node.  per dochttp://docs.oracle.com/cd/B28359_01/rac.111/b28254/rman.htm#RACAD7199

I can see where this would not be an issue if it were writing to tape, as it would just write to tape, but it's writing to disk and I want it to write to disk. We do not have tape.


Rman thinks those channels are default so it's writing the ORACLE_HOME/dbs . How do I get it to write those channels to my backup location?

The datafiles and archive log backups are going to the correct file system backup location listed in channel 3 and 4.

Why is it writing to  $ORACLE_HOME/dbs? If it's because the channel 1 & channel 2 don't specify a location, how do I specify a location on those to disk.

If I don't have the channels configured using "connect", rman fails on crosschecking the archive logs.

Configuration:

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name EBS1 are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 9 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/ebs1/cf_%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO COMPRESSED BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';

CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';

CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT   '/mnt//ebs_backupset_%U' MAXPIECESIZE 2 G;

CONFIGURE CHANNEL 4 DEVICE TYPE DISK FORMAT   '/mnt//ebs/ebs_backupset_%U' MAXPIECESIZE 2 G;

CONFIGURE MAXSETSIZE TO UNLIMITED;

CONFIGURE ENCRYPTION FOR DATABASE OFF;

CONFIGURE ENCRYPTION ALGORITHM 'AES128';

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 3 TIMES TO DISK;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/ebs1/ebs1db/11.2.0/dbs/scf/snapcf_ebs1.f';

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2015
Added on Jan 5 2015
13 comments
4,891 views