OraFAQ Forum: Backup & Recovery » Autobackup location

Home » RDBMS Server » Backup & Recovery » Autobackup location (Oracle 10.2.0.3 Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Autobackup location [message #449135]

Sat, 27 March 2010 03:32

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

Report message to a moderator

Re: Autobackup location [message #450345 is a reply to message #449135]

Tue, 06 April 2010 09:34

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 20:31:11 CST 2024