No question at this time
DBA Top 10
1 B. Vroman 13400
2 M. Cadot 10400
3 J. Schnackenberg 8300
4 T. Boles 7850
5 A. Kavsek 5700
6 M. Hidayathullah ... 2200
7 G. Lambregts 1100
8 T. P 1000
8 P. Wisse 1000
10 . Lauri 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48302
Total active users1583
Act. users last 24h3
Act. users last hour0
Registered user hits last week198
Registered user hits last month812
Go up

Archives have to be deleted by RMAN from Standby Site
Next thread: INSERT INTO RETURNING with VBA using ADO/OLE DB
Prev thread: Creation of Materialized View on View fails

Message Score Author Date
Dear all, OUR FRA Destination size is 450 GB W...... Jill Salalila Sep 30, 2018, 09:59
Depends on what you mean by OK and how you do your...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Tim Boles Oct 02, 2018, 22:35

Follow up by mail Click here


Subject: Archives have to be deleted by RMAN from Standby Site
Author: Jill Salalila, Philippines
Date: Sep 30, 2018, 09:59, 77 days ago
Os info: Oracle Linux 6.7
Oracle info: 12.1.0.2
Message: Dear all,

OUR FRA Destination size is 450 GB
We want to reduce archive dest size to 180 GB

We scheduled a shell script to delete archived logs on Standby side once FRA reached 85%

We are planning to disable that script
Better we want to delete archive logs next day by RMAN. I meant to say

Today's date is: SEP 30
Whatever archives are generated at Standby on 30 SEPTEMBER, the next day i.e on OCT 1st, archive logs must be deleted from Standby site

Is it O.K ?

RMAN> delete noprompt archivelog until time 'sysdate -1';

Please update







Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Archives have to be deleted by RMAN from Standby Site
Author: Tim Boles, United States
Date: Oct 02, 2018, 22:35, 74 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Depends on what you mean by OK and how you do your backups.


If you are using RMAN to do your backups then configure archive retention policy and let RMAN do the work.

https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#BRADV89438

Configuring the Backup Retention Policy

https://docs.oracle.com/database/121/RCMRF/rcmsynta009.htm#RCMRF113

Then you can do your backup plus archivelog

BACKUP DATABASE PLUS ARCHIVELOG DELETE ALL INPUT;

However, if you just want to know if your command will work.

https://docs.oracle.com/database/121/RCMRF/rcmsubcl002.htm#GUID-DDF929FF-796B-4AD6-AE58-F831CAFC7703__BABJGBFG

It should be fine.....but as always test it in a test envrionment first...and make sure you backup the archivelogs first.

Regards
Tim
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here