OraFAQ Forum: Backup & Recovery » Why it is searching SBT

Home » RDBMS Server » Backup & Recovery » Why it is searching SBT_TYPE?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Why it is searching SBT_TYPE? [message #254152]

Thu, 26 July 2007 00:01

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!

Report message to a moderator

Re: Why it is searching SBT_TYPE? [message #254157 is a reply to message #254152]

Thu, 26 July 2007 00:25

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!!!

Report message to a moderator

Re: Why it is searching SBT_TYPE? [message #254169 is a reply to message #254157]

Thu, 26 July 2007 01:17

Michel Cadot
Messages: 68651
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

Report message to a moderator

Re: Why it is searching SBT_TYPE? [message #254398 is a reply to message #254169]

Thu, 26 July 2007 12:03

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??

Report message to a moderator

Previous Topic:	Rman restore control files with oracle8.1.7
Next Topic:	raw disks v/s file system

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 17:47:11 CDT 2024