Home » RDBMS Server » Backup & Recovery » Autobackup location (Oracle 10.2.0.3 Windows 2003)
Autobackup location [message #449135] Sat, 27 March 2010 03:32 Go to next message
oraclenuke
Messages: 2
Registered: March 2010
Location: Romania
Junior Member
Why the controlfile and spfile autobackup goes to $ORACLE_HOME\database folder instead of flash_recovery_area\prod\AUTOBACKUP folder.

This is my rman env:

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 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 MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:\ORACLE\FLASH_RECOVERY_AREA\PROD\AUTOBACKUP\SNCFPROD.ORA';

Thanks
icon6.gif  Re: Autobackup location [message #450345 is a reply to message #449135] Tue, 06 April 2010 09:34 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
oraclenuke wrote on Sat, 27 March 2010 04:32
Why the controlfile and spfile autobackup goes to $ORACLE_HOME\database folder instead of flash_recovery_area\prod\AUTOBACKUP folder.

Because that is the default, If you want it to go elsewhere, configure it kinda like this:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\flash_recovery_area\prod\AUTOBACKUP\%F'; 

PS: Code the correct full path/location.

[Updated on: Tue, 06 April 2010 11:17] by Moderator

Report message to a moderator

Re: Autobackup location [message #450437 is a reply to message #450345] Wed, 07 April 2010 04:34 Go to previous message
oraclenuke
Messages: 2
Registered: March 2010
Location: Romania
Junior Member
Thanks for the input.
I don't understand why this has changed by itself.

I'm pretty sure that the default was in AUTOBACKUP folder with the same structure like for backupsets and archivelogs (separate daily folders).

If I do what you said, the autobackup goes in the right place, but without the folder structure.

Is that due to some upgrade, or patch?

Oracle Home : d:\oracle\db10gr2
Central Inventory : C:\Program Files (x86)\Oracle\Inventory
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : d:\oracle\db10gr2\oui

Oracle Database 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 10.2.0.3.0
There are 2 products installed in this Oracle Home.

Patch 5556081 : applied on Mon Sep 22
Bugs fixed:
5556081

Patch 5557962 : applied on Mon Sep 22
Bugs fixed:
4269423, 5557962, 5528974

Thanks
Previous Topic: Recover Data base from previos database
Next Topic: Full Restore after reset logs
Goto Forum:
  


Current Time: Sat Oct 01 04:15:38 CDT 2016

Total time taken to generate the page: 0.09540 seconds