Solved!
Go to SolutionS
SabarnaDeb
2 Intern
•
139 Posts
0
4752
March 1st, 2012 08:00
Unable to take control file backup.
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?????
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
2 Intern
•
139 Posts
2835
0
Posted March 1st, 2012 20:00
Hi Ahmed,
I want to take in tapes.
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;
SabarnaDeb
2 Intern
•
139 Posts
2835
1
Posted March 2nd, 2012 05:00
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';
SabarnaDeb
2 Intern
•
139 Posts
2835
0
Posted March 5th, 2012 01:00
Yes
Bebo2k
544 Posts
2835
0
Posted March 2nd, 2012 13:00
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