Home » RDBMS Server » Backup & Recovery » configuration can't be chaned for BACKUP or STANDBY control file (Oracle 11.2.0.2 Linux 5 x86-64)
configuration can't be chaned for BACKUP or STANDBY control file [message #566701] Tue, 18 September 2012 13:40 Go to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
On my stand by DB when I run the following command I get this error:

Can somebody explain why this is happening?
Is this line really needed based on my run block?

Thanks to all who answer.

run
{
sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE';

allocate channel t1 type 'SBT_TAPE'
tag="20120918_lvl2_tue_dly" as compressed
backupset database plus archivelog delete input;
backup (current controlfile);
backup spfile;

release channel t1;
}

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 09/18/2012 13:17:39
RMAN-05021: this configuration cannot be changed for a BACKUP or STANDBY control
file
Re: configuration can't be chaned for BACKUP or STANDBY control file [message #566704 is a reply to message #566701] Tue, 18 September 2012 13:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Please copy and paste the RMAN session (in text, no image), the COMPLETE session.
Check each statement one by one to know which one fails (which we should know if you poates the complete RMAN session).

Regards
Michel
Re: configuration can't be chaned for BACKUP or STANDBY control file [message #566715 is a reply to message #566704] Tue, 18 September 2012 15:12 Go to previous messageGo to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
Micheal,

The problem is with this statemnt on the backup of my stand by DB.


CONFIGURE RETENTION POLICY TO RECOVERY WINDOW of 30 DAYS



I saw some posts regarding this but I am still unsure why this is an issue?
Can somebody please explain.

Thanks
Re: configuration can't be chaned for BACKUP or STANDBY control file [message #566716 is a reply to message #566715] Tue, 18 September 2012 15:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Can you post where you found this information.
You ask, you ask but you do not provide anything, no information, no help, nothing.

Regards
Michel
Re: configuration can't be chaned for BACKUP or STANDBY control file [message #566717 is a reply to message #566716] Tue, 18 September 2012 15:44 Go to previous message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
This is what I found.


http://asanga-pradeep.blogspot.com/2011/07/changing-backup-policy-on-standby-db.html

Previous Topic: RMAN not removing backups
Next Topic: Migrate 10gR2 on SPARC 5.9 to SunOS 5.10 x86_64
Goto Forum:
  


Current Time: Thu Nov 21 12:07:47 CST 2024