Home » RDBMS Server » Backup & Recovery » How can I reset the "backup set number" back to 1 (Oracle 9.2.0.4 on Linux - RMAN backup with IBM TDPO to TSM v5.5)
How can I reset the "backup set number" back to 1 [message #401104] Fri, 01 May 2009 11:34 Go to next message
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 #401108 is a reply to message #401104] Fri, 01 May 2009 12:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think this is possible or maybe recreating the control file but you will loose the possibility to use the previous backup.
Why this number is important for you?

Regards
Michel
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 Go to previous messageGo to next message
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' Embarassed

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

Re: How can I reset the "backup set number" back to 1 [message #401123 is a reply to message #401121] Fri, 01 May 2009 13:25 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The backup to trace does not contain information on backups, this is why I said maybe the next one will start with number one but you will loose information about previous backups and can't use them.

Regards
Michel
Previous Topic: Changing Rman configurations
Next Topic: diff. between unarchived and inactive.
Goto Forum:
  


Current Time: Thu Mar 28 06:56:16 CDT 2024