544 Posts

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

544 Posts

March 1st, 2012 12:00

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

2 Intern

 • 

139 Posts

March 1st, 2012 20:00

Hi Ahmed,

I want to take in tapes.

544 Posts

March 2nd, 2012 02:00

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;

2 Intern

 • 

139 Posts

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';

2 Intern

 • 

139 Posts

March 5th, 2012 01:00

Yes

No Events found!

Top