Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN: nocatalog; remove backed up archived redos

RE: RMAN: nocatalog; remove backed up archived redos

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Sun, 28 Oct 2001 21:06:36 -0800
Message-ID: <F001.003B6A9D.20011028212517@fatcity.com>

Leng,

Why are you trying to remove the record from the control file? I don't know for sure but I doubt you can.

It will be overwritten in time anyway, as referenced by the parameter control_file_record_keep_time
>From the 817 help:

CONTROL_FILE_RECORD_KEEP_TIME
Parameter type: Integer  

Parameter class: Dynamic. Scope = ALTER SYSTEM.  

Default value: 7 (days)  

Range of values: 0 to 365 (days)  

CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused. In the event a new record needs to be added to a reusable section and the oldest record has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections never expand, and records are reused as needed.  

Note: This parameter applies only to records in the control file that are circularly reusable (such as archive log records and various backup records). It does not apply to records such as datafile, tablespace, and redo thread records, which are never reused unless the corresponding object is dropped from the tablespace.  

See Also: "CONTROL_FILES", Oracle8i Concepts, and Oracle8i Backup and Recovery Guide for more information on control files.  

HTH,
Bruce Reardon

-----Original Message-----
Sent: Saturday, 27 October 2001 17:30

Ramon,

Thanks for the reply.

I guess I've tried the delete part as well. Here's another attempt at it:



List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time ------- ---------- ---------- -- ---------- ----------

70 70 442774915 0 442774914 70 10-OCT-01     List of Backup Pieces
    Key Pc# Cp# Status Completion Time Piece Name

    List of Archived Logs Included
    Thrd Seq Low SCN Next SCN Low Time Next Time

RMAN> allocate channel for delete type disk;
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: delete
RMAN-08500: channel delete: sid=15 devtype=DISK

RMAN> change datafilecopy
2> '/data3/rman_bk/HOTP_70_1_442774914' delete;

RMAN-03022: compiling command: change
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: change
RMAN-06003: ORACLE error from target database: RMAN-20230: datafile
copy not found in the recovery catalog
RMAN-06015: error while looking up datafilecopy name: /data3/rman_bk/HOTP_70_1_442774914

Not found in recovery catalog! I'm not using a catalog. And the file is an archived redo log, not a datafile.

All you rman experts, what do we do now?

Ta,

Leng.



 Date: Wed, 24 Oct 2001 09:48:08 -0500
 Subject: RE: RMAN: nocatalog; remove backed up archived redos

Leng,

If you dont use a catalog with rman you wouldn't be able to store scripts
to make automated backups and restore. Also that means that all the information about your backups will be stored in the control file of the
target database, if you loose your controlfiles will loose all the information
of your backups, so they will be useless.

Allocate channel for delete type disk;
change datafilecopy 'yourfile' delete;
release channel;

This would work for you

Luck (Suerte)

Ramon E. Estevez
com.banilejas_at_codetel.net.do
809-565-3121

-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de Leng Kaing Enviado el: Tuesday, 23 October, 2001 6:10 PM

Hello everyone,

Env: 8i and 8.0

I've been digging around the rman manuals and metalink but can't seem to find anything decent on this so thought I'd try this forum...

Firstly, what functionality do you loose when you don't use a catalog?

2ndly, how does one delete old backups? I'm backing up to disk. All is fine with the backup. But now I need to delete the backups from disk, and remove the information about the backup from the controlfile.

Tried doing this but failed:



RMAN> allocate channel for delete type disk;
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: delete_05
RMAN-08500: channel delete_05: sid=15 devtype=DISK

RMAN> change backuppiece 70 delete;

RMAN-03022: compiling command: change
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: change
RMAN-06091: no channel allocated for maintenance (of an appropriate
type)

What's wrong here? I've allocated a channel and RMAN acknowledges that it's for delete. But can't do it.

Help!!

Thanks,

Leng.



Leng Kaing - lkaing_at_yahoo.com
Ph: +61-3-417-371-348
AUSOUG-VIC : http://www.ausoug.org/vic/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sun Oct 28 2001 - 23:06:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US