Hi,
I am using oracle database 11g (11.2.0.1.0) in OEL (Oracle enterprise linux).I am trying to take backup of the database with backup location to nfs shared location.
THE RMAN CONFIGURATION OF DB IS SHOWN BELOW
=====================================================
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORADB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/bkp/CONTROL_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/bkp/snapcf_ORADB.f';
Using the below script i fire the backup in the database.
BACKUP DATABASE plus archivelog FORMAT='/u01/bkp/Full_plus_arch_%U' ;
I have mentioned /u01/bkp/ montpoint location in the above script which is a nfs share locatioand control file auto backup also set to this location only.But still i can see my backup is going to $ORACLE_HOME/dbs .
LIST BACKUP OF DB IS SHOWN BELOW
=======================================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
39 Full 962.32M DISK 00:01:13 22-DEC-14
BP Key: 39 Status: AVAILABLE Compressed: NO Tag: TAG20141222T171531
Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/1kpqqndk_1_1
List of Datafiles in backup set 39
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 7435446 22-DEC-14 +DATA/oradb/datafile/system.256.788911005
2 Full 7435446 22-DEC-14 +DATA/oradb/datafile/sysaux.257.788911005
3 Full 7435446 22-DEC-14 +DATA/oradb/datafile/undotbs1.258.788911005
4 Full 7435446 22-DEC-14 +DATA/oradb/datafile/users.259.788911005
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
40 46.50K DISK 00:00:00 22-DEC-14
BP Key: 40 Status: AVAILABLE Compressed: NO Tag: TAG20141222T171649
Piece Name: /u01/bkp/Full_plus_arch_1lpqqng2_1_1
List of Archived Logs in backup set 40
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 269 7435415 22-DEC-14 7435519 22-DEC-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
41 Full 9.95M DISK 00:00:04 22-DEC-14
BP Key: 41 Status: AVAILABLE Compressed: NO Tag: TAG20141222T171651
Piece Name: /u01/bkp/CONTROL_c-2542175921-20141222-00
SPFILE Included: Modification time: 22-DEC-14
SPFILE db_unique_name: ORADB
Control File Included: Ckp SCN: 7435529 Ckp time: 22-DEC-14
Even though i mentioned backup location in my backup database script and auto backup also to the same location the backup piece is going to $ORACLE_HOME/dbs location
BP Key: 39 Status: AVAILABLE Compressed: NO Tag: TAG20141222T171531
Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/1kpqqndk_1_1
How to avoid this???
I want all the backups to go to my NFS shared mountpoint (/u01/bkp)
Regards,
007