Content-Type: multipart/alternative;
 boundary="------------PKdW44k8qnaApGcGYm0ULowh"
Message-ID: <3ccc51ac-04ec-f457-07dc-28b269c65e46@gmail.com>
Date: Mon, 10 Oct 2022 08:51:33 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.3.1
Subject: Re: RMAN Recovery catalogue
To: oracle-l@freelists.org
References: <LO4P265MB3470D88048C007490A3FBECCE6209@LO4P265MB3470.GBRP265.PROD.OUTLOOK.COM>
Content-Language: en-US
From: Mladen Gogala <gogala.mladen@gmail.com>
In-Reply-To: <LO4P265MB3470D88048C007490A3FBECCE6209@LO4P265MB3470.GBRP265.PROD.OUTLOOK.COM>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: gogala.mladen@gmail.com
--------------PKdW44k8qnaApGcGYm0ULowh
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Replies in-line:
On 10/10/22 05:44, Paul Houghton (Paul.Houghton) wrote:
>
> We have RMAN backups with a recovery catalogue, which backs up to 
> Netbackup, which of course maintains its own catalogue of backups.
>
> I have two issues keeping the catalogues in sync
>
> Issue 1 – Test/cloned databases
>
> We have test databases which are backed up, but periodically refreshed 
> from production. The issue is that the database which relates to the 
> backups I have taken no longer exists, but there is another database 
> with the same name. I can’t delete old backups because I have an 
> archive log deletion policy. It seems I have to choose between 
> managing the archive logs before the database is refreshed, or 
> managing the backups after it has been refreshed, unless we can change 
> the archive log deletion policy just before the database is deleted. I 
> did open an SR which resulted in Doc ID 2545757.1 being updated to 
> reflect this.
>
What does archive deletion policy have to do with deleting old backups? 
DELETE BACKUP OF DATABASE COMPLETED BEFORE.... will wipe out the 
unnecessary archive logs as well.


> Issue 2 – Offline backups
>
> Some backups are written to tape and stored offline. These have a 
> different retention period to the normal recovery window, so I tell 
> RMAN they are archival backups and specify the retention time. It 
> seems Netbackup deletes reference to these from its catalogue as they 
> are stored offline. So if I do a crosscheck it marks all offline 
> backups as having expired. I can’t seem to get RMAN to manage these 
> backups. When it comes to delete them it says they have expired and to 
> run a crosscheck, but if I do that it marks all offline backups as 
> having expired. Then if I delete expired backups, it will delete all 
> offline backups. Is there a way to tell RMAN that these backups are 
> offline?
>
> Has anyone solved these issues? I’d like to completely automate my 
> management of backups, but either I am misunderstanding something, or 
> RMAN doesn’t handle anything but  the simplest cases.
>
> Thanks
>
> Paul
>
When you move backup tape from a unit not visible to NB you need to do 
crosscheck backup of database device type SBT_TAPE. You can also do 
"CHANGE" to AVAILABLE. This is all pretty routine stuff. Be careful, if 
you delete the backup from catalog, you will not be able to change it 
back from EXPIRED to AVAILABLE.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--------------PKdW44k8qnaApGcGYm0ULowh
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Replies in-line:<br>
    </div>
    <div class="moz-cite-prefix">On 10/10/22 05:44, Paul Houghton
      (Paul.Houghton) wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:LO4P265MB3470D88048C007490A3FBECCE6209@LO4P265MB3470.GBRP265.PROD.OUTLOOK.COM">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <style>@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}.MsoChpDefault
	{mso-style-type:export-only;
	mso-fareast-language:EN-US;}div.WordSection1
	{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal">We have RMAN backups with a recovery
          catalogue, which backs up to Netbackup, which of course
          maintains its own catalogue of backups.<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal">I have two issues keeping the catalogues in
          sync<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal">Issue 1 – Test/cloned databases<o:p></o:p></p>
        <p class="MsoNormal">We have test databases which are backed up,
          but periodically refreshed from production. The issue is that
          the database which relates to the backups I have taken no
          longer exists, but there is another database with the same
          name. I can’t delete old backups because I have an archive log
          deletion policy. It seems I have to choose between managing
          the archive logs before the database is refreshed, or managing
          the backups after it has been refreshed, unless we can change
          the archive log deletion policy just before the database is
          deleted. I did open an SR which resulted in Doc ID 2545757.1
          being updated to reflect this.</p>
      </div>
    </blockquote>
    <p>What does archive deletion policy have to do with deleting old
      backups? DELETE BACKUP OF DATABASE COMPLETED BEFORE.... will wipe
      out the unnecessary archive logs as well.<br>
    </p>
    <p><br>
    </p>
    <blockquote type="cite"
cite="mid:LO4P265MB3470D88048C007490A3FBECCE6209@LO4P265MB3470.GBRP265.PROD.OUTLOOK.COM">
      <div class="WordSection1">
        <p class="MsoNormal"><o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal">Issue 2 – Offline backups<o:p></o:p></p>
        <p class="MsoNormal">Some backups are written to tape and stored
          offline. These have a different retention period to the normal
          recovery window, so I tell RMAN they are archival backups and
          specify the retention time. It seems Netbackup deletes
          reference to these from its catalogue as they are stored
          offline. So if I do a crosscheck it marks all offline backups
          as having expired. I can’t seem to get RMAN to manage these
          backups. When it comes to delete them it says they have
          expired and to run a crosscheck, but if I do that it marks all
          offline backups as having expired. Then if I delete expired
          backups, it will delete all offline backups. Is there a way to
          tell RMAN that these backups are offline?<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal">Has anyone solved these issues? I’d like to
          completely automate my management of backups, but either I am
          misunderstanding something, or RMAN doesn’t handle anything
          but  the simplest cases.<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal">Thanks<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal">Paul<o:p></o:p></p>
      </div>
    </blockquote>
    <p>When you move backup tape from a unit not visible to NB you need
      to do crosscheck backup of database device type SBT_TAPE. You can
      also do "CHANGE" to AVAILABLE. This is all pretty routine stuff.
      Be careful, if you delete the backup from catalog, you will not be
      able to change it back from EXPIRED to AVAILABLE.<br>
    </p>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
<a class="moz-txt-link-freetext" href="https://dbwhisperer.wordpress.com">https://dbwhisperer.wordpress.com</a>
</pre>
  </body>
</html>

--------------PKdW44k8qnaApGcGYm0ULowh--
--
http://www.freelists.org/webpage/oracle-l