Home » RDBMS Server » Backup & Recovery » Why it is searching SBT_TYPE?
Why it is searching SBT_TYPE? [message #254152] Thu, 26 July 2007 00:01 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TYPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TYPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TYPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TYPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/10.2.0/db_1/dbs/snapcf_Arju.f'; # default

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

RMAN> delete backupset tag TAG20070725T165930;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 07/26/2007 10:54:21
ORA-19554: error allocating device, device type: SBT_TYPE, device name:
ORA-27001: unsupported device type
Additional information: 1



But Whenever I specify ,

RMAN> delete backupset tag TAG20070725T165930 device type disk;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
6       6       1   1   AVAILABLE   DISK        /oracle/app/flash_recovery_area/ARJU/autobackup/2007_07_25/o1_mf_s_628870796_3bhgfm1k_.bkp

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/oracle/app/flash_recovery_area/ARJU/autobackup/2007_07_25/o1_mf_s_628870796_3bhgfm1k_.bkp recid=6 stamp=628880371
Deleted 1 objects


So where is the problem. I am connected as system. Whenever I use configure then it does not work. Why I have to explicitly mention
device type!
Re: Why it is searching SBT_TYPE? [message #254157 is a reply to message #254152] Thu, 26 July 2007 00:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

By the way whenever I give BACKUP DATABASE command . Its automatically backup to disk. No need to mention device type. But in case of performing delete operation I have to set. Why? Is this a feature of Oracle!!!
Re: Why it is searching SBT_TYPE? [message #254169 is a reply to message #254157] Thu, 26 July 2007 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have 2 types of device configured so you have to say which one it has to search for.
In case of backup, there is a default: DISK.
Not in case of delete, hopefully.

To remove SBT configuration use:
CONFIGURE CHANNEL DEVICE TYPE sbt CLEAR;

Regards
Michel
Re: Why it is searching SBT_TYPE? [message #254398 is a reply to message #254169] Thu, 26 July 2007 12:03 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
By the way whenever I give BACKUP DATABASE command . Its automatically backup to disk. No need to mention device type.


Beacause its the DEFAULT but SBT is not default you can make that default by setting.

Quote:
But in case of performing delete operation I have to set. Why? Is this a feature of Oracle!!!


What you have to set??
Previous Topic: Rman restore control files with oracle8.1.7
Next Topic: raw disks v/s file system
Goto Forum:
  


Current Time: Tue Dec 06 16:27:50 CST 2016

Total time taken to generate the page: 0.07220 seconds