| How can I reset the "backup set number" back to 1 [message #401104] |
Fri, 01 May 2009 11:34  |
ralfsy
Messages: 2
Registered: May 2009
Location: Germany
|
Junior Member |
|
|
Hi,
I have deleted all old backup sets (from RMAN and TSM), because we got a new tape library. But the first new RMAN backup doesn't have the "backup set number" -> 1
RMAN> list backup;
using target database controlfile instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
271 Full 538M SBT_TAPE 00:00:28 01-MAY-09
BP Key: 27 Status: AVAILABLE Tag: TEC OFFLINE V1.0
Piece Name: TEC/685683752/27/1
-------
How can I reset the backup set number ... Would be nice, if the new backups start with the backup set numer 1.
-- Ralf --
[Updated on: Fri, 01 May 2009 12:17] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: How can I reset the "backup set number" back to 1 [message #401121 is a reply to message #401104] |
Fri, 01 May 2009 12:58  |
ralfsy
Messages: 2
Registered: May 2009
Location: Germany
|
Junior Member |
|
|
Michel,
thank you for your answer. It isn't really important, but it would be nice, if I could do it.
I have exported the control file with:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
The result is in the attached file. Maybe I'm blind ... Maybe I'm to stupid ... Maybe both ... I can't find the backup set number in the control file.
--Ralf--
P.S. to the Moderator: Thank you for adding the 'code' '/code' 
Had to edit the message .. I called Michel Michael. Today is really not my day.
[Updated on: Fri, 01 May 2009 13:01] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
