What is the correct syntax of this command? What is the "Catalog 1 Connect String" supposed to be?
-- Joshua S. Bassi IBM Certified - AIX 4/5L, SAN, Shark Tivoli Certified Consultant - ADSM/TSM eServer Systems Expert -pSeries HACMP AIX, HACMP, Storage, TSM Consultant Cell (831) 595-3962 [EMAIL PROTECTED] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@;VM.MARIST.EDU] On Behalf Of Rob Schroeder Sent: Monday, October 28, 2002 3:56 PM To: [EMAIL PROTECTED] Subject: Re: TDP for Oracle Version Expiration Even easier is to use TDPOSYNC SYNCDB, and it lets you put a date range in. Then you can select by reviewing the date of each backup you want to keep/delete. Much safer than typing the correct number in. If you use a crosscheck command daily, then old backups shoudln't hang around. Rob Schroeder Famous Footwear 608-827-3495 phone 608-662-6495 fax Joshua Bassi <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent by: "ADSM: cc: Dist Stor Subject: TDP for Oracle Version Expiration Manager" <[EMAIL PROTECTED] .EDU> 10/28/2002 05:49 PM Please respond to "ADSM: Dist Stor Manager" All, Here is the script directly out of the TDP for Oracle manual: To remove an old backup, issue this command from the RMAN prompt: run { allocate channel for delete type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=c:\RMAN\scripts\tdpo.opt)'; change backupset primary_key delete; } Note: To enter a number value for the primary key variable, look up the value in the RMAN catalog. My question is: what exactly is the "primary key" variable? -- Joshua S. Bassi IBM Certified - AIX 4/5L, SAN, Shark Tivoli Certified Consultant - ADSM/TSM eServer Systems Expert -pSeries HACMP AIX, HACMP, Storage, TSM Consultant Cell (831) 595-3962 [EMAIL PROTECTED]
