Re: control_file_record_keep_time --- confusing and messed up with my RMAN backups in standby server
- From: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- To: krishna000@xxxxxxxxx
- Date: Thu, 23 Jun 2011 23:09:16 +0800
Here's the question :
If this is your *first* BACKUP DATABASE run, how does it matter which
older archivelogs are backed up ? It makes no difference if the first
archivelog to be backed up is as of 7minutes OR 7days or 28days before the
start of the BACKUP DATABASE.
The older archivelogs are completely useless in any restore+recovery
scenario because you don't have an older database backup.
Going forward, you need to ensure that all archivelogs from the first BACKUP
DATABASE onwards do get backed up !
I presume that the SQL query output you present is from a query on
V$CONTROLFILE_RECORD_SECTION.
It shows that a total of 8,060 "records" -- think of them as "slots" -- for
ArchiveLog entries have been created but only 4,836 are in use currently.
This would happen if, at sometime in the past, in one 7day period your
database did generate 8,060 archivelogs, thus creating 8,060 entries in the
controlfile.
Here is an example of a V$ARCHIVED_LOG having entries as far back as 142
days ago !
-- but RMAN being "aware" of archivelogs only as old as 14 days ago :
http://hemantoracledba.blogspot.com/2011/04/archivelogs-in-controlfile.html
On Thu, Jun 23, 2011 at 7:13 PM, Balakrishna Y <krishna000@xxxxxxxxx> wrote:
> Hi All,
>
> Here is my live scenario .
> <snip>
> and we didn't notice this database at all to our knowledge .
>
> <snip>
>
> I've configured according to our policies which is 28 days retention and
> the backup's needs to be configured on standby server only . After
> everything i've took a first cold backup with archivelog all delete input .
> It errored in between
>
> RMAN-03009: failure of backup command on ORA_DISK_1 channel
> ORA-19571: archived-log recid 3257 stamp 650396427 not found in control
> file
>
> <snip>
>
> Can any body intrepret the output of the below . -- This is also confusing
>
> TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED
> FIRST_INDEX LAST_INDEX LAST_RECID
> ---------------------------- ----------- ------------- ------------
> ----------- ---------- ----------
> ARCHIVED LOG 584 8060 4836
> 8016 4791 11623
>
> Regards
>
> Bala
>
--
Hemant K Chitale
http://hemantoracledba.blogspot.com
Other related posts:
