• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » Snapshot controlfile feature with RMAN and ORA-00245

Snapshot controlfile feature with RMAN and ORA-00245

December 31, 2015 by techgoeasy 1 Comment

Table of Contents

  • What is Snapshot Control file in Oracle?
  • Location for Snapshot Control file
  • ORA-00245: control file backup failed; target is likely on a local file system
  • Restoration from Snapshot controlfile

What is Snapshot Control file in Oracle?

When RMAN needs to re-synchronize from a read-consistent version of the control file, it creates a temporary snapshot control file. RMAN needs a snapshot control file only when re-synchronizing with the recovery catalog or when making a backup of the current control file.

If you are not using recovery catalog in the your environment ,you will not see the snapshot control file  unless you make a backup of current control file

Location for Snapshot Control file

The default value for the snapshot control file is platform-specific and depends on the Oracle home.

For example, the default filename on some UNIX platforms in Oracle Database 10g is

$ORACLE_HOME/dbs/[email protected]

Note that if you have a flash recovery area configured, the default location for the snapshot control file is not the flash recovery area.

As of Oracle 11.2 (11.2.0.2 to more precise) the snapshot control file must be on a location shared by all RAC nodes in a cluster (it must be accessible by all nodes on which instances for an RAC database can run). If you do not do so, you most likely will receive an ORA-00245 (ORA-00245: control file backup operation failed) when running an RMAN backup.

For Oracle RAC with ASM , this can be placed on ASM diskgroup

$rman target /

RMAN> SHOW SNAPSHOT CONTROLFILE NAME;
RMAN>CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/dbs/snapcf_test.f'; # default

For Oracle Real Application Clusters with ASM

$rman target /
RMAN>CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<shared snapshot control file>';

RMAN>CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/TEST/CONTROLFILE/snapcf_test.f';

ORA-00245: control file backup failed; target is likely on a local file system

In case of Oracle RAC environment , if the snapshot control is not set to shared location or ASM disk, following errors happens

1. if Autobackup of controlfile is enabled, RMAN is failing with error:
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3009: failure of Control File and SPFILE Autobackup command on
ORA_DISK_1 channel at 10/27/2018 12:13:31
ORA-245: control file backup operation failed


2. Taking control file backup using backup controlfile command
SQL> ALTER DATABASE BACKUP CONTROLFILE TO '/path/control.bk' REUSE
*
ERROR at line 1:
ORA-245: control file backup operation failed

Resolution

RMAN> SHOW SNAPSHOT CONTROLFILE NAME;

RMAN>CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<shared snapshot control file>';

RMAN>CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/TEST/CONTROLFILE/snapcf_test.f';

Restoration from Snapshot controlfile

You can Restore using snapshot controlfile also

restore controlfile from '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_test.f';

I hope you like this post on snapshot controlfile and ORA-00245

Please do provide the feedback

Also Reads
RMAN List backup commands
RMAN connection decoded
Oracle RMAN commands cheatsheet
recover database using RMAN
How to debug Oracle RMAN session
RMAN-06059
RMAN-20004

Filed Under: Oracle, Oracle Database Tagged With: Snapshot controlfile

Reader Interactions

Comments

  1. shameer says

    May 4, 2021 at 12:28 pm

    It is nice, Thank You

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • how to find file based on size in linux
  • How to use sed replace string in file
  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us