SabarnaDeb
3 Argentum

Unable to take control file backup.

Jump to solution

Hi All,

Control file backup failed at the end of the oracle online database backup. Below is the error.

Error message:

savegrp: suppressed 35 lines of output.
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on CH1 channel at 03/01/2012 21:44:52
ORA-01580: error creating control backup file /BACKUP/oracle_backup/backup/files_level2/2012_02_27_msatprd_l2/snapcf_yexp1.f
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory

Recovery Manager complete.
The backup process failed:
RMAN exited with return code '1'.
Exiting with error:
RMAN exited with return code '1'.
Client_name:     RMAN exited with return code '1'.

Below parameter has been set in oracle client.

configure controlfile autobackup on

configure controlfile autobackup format for device type ’sbt_tape’ to

’/NMO_%f/’

How to set control file backup location to tape?????

0 Kudos
1 Solution

Accepted Solutions
Bebo2k
3 Zinc

Re: Unable to take control file backup.

Jump to solution

Thanks Sabarna_Deb for the updates,

Good point, so after you set this SNAPSHOT CONTROLFILE NAME configure command, the problem is solved now and control file is located to tape correctly ?

Thanks,

Ahmed Bahaa

View solution in original post

0 Kudos
6 Replies
Bebo2k
3 Zinc

Re: Unable to take control file backup.

Jump to solution

Seems to be Oracle issue for me , You can solve it by doing the following:

log in to the database as sysdba:

oracle@host: sqlplus "/ as sysdba"


sys@db1> EXECUTE SYS.DBMS_BACKUP_RESTORE.CFILESETSNAPSHOTNAME('/BACKUP/oracle_backup/backup/files_level2/2012_02_27_msatprd_l2/snapcf_yexp1.f);

PL/SQL procedure successfully completed.

Hope that this solution solves the issue,

Thanks,

Ahmed Bahaa

SabarnaDeb
3 Argentum

Re: Unable to take control file backup.

Jump to solution

Hi Ahmed,

I want to take in tapes.

0 Kudos
Bebo2k
3 Zinc

Re: Unable to take control file backup.

Jump to solution

Did you set 'SBT_TAPE' as the default output device for Oracle AUTOBACKUP backups. SET CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'

Would you try to manually test the control file backup to tape, at the RMAN> prompt, type this:  backup current controlfile; <Enter>

SabarnaDeb
3 Argentum

Re: Unable to take control file backup.

Jump to solution

Now i was able to take controlfile backup by setting below "configure" command from RMAN.

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'snapshot controlfile path and name';

As per my case i configured this one :

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/BACKUP/oracle_backup/backup/snapshot/snapcf_yexp1.f';

Bebo2k
3 Zinc

Re: Unable to take control file backup.

Jump to solution

Thanks Sabarna_Deb for the updates,

Good point, so after you set this SNAPSHOT CONTROLFILE NAME configure command, the problem is solved now and control file is located to tape correctly ?

Thanks,

Ahmed Bahaa

View solution in original post

0 Kudos
SabarnaDeb
3 Argentum

Re: Unable to take control file backup.

Jump to solution

Yes

0 Kudos