Browse Community
Help
Log In
Responses(6)
Solutions(1)
Bebo2k
544 Posts
0
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
1
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,
SabarnaDeb
2 Intern
•
139 Posts
March 1st, 2012 20:00
Hi Ahmed,
I want to take in tapes.
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;
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';
March 5th, 2012 01:00
Yes
Dell Support Resources
View All
Top
Bebo2k
544 Posts
0
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
Bebo2k
544 Posts
1
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
SabarnaDeb
2 Intern
•
139 Posts
0
March 1st, 2012 20:00
Hi Ahmed,
I want to take in tapes.
Bebo2k
544 Posts
1
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;
SabarnaDeb
2 Intern
•
139 Posts
1
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
0
March 5th, 2012 01:00
Yes