How to delete alogs fom Oracle downstream targetOracle DBV File ParameterOracle disaster recovery on LinuxOracle getting slowHow to delete .dbf file in oracle?Fixed expired accounts in Oracle 11gHow to wipe the slate clean on an Oracle installation?ORA-1034 Oracle Not FoundOracle IIg Windows 64 InstallHow to enable Oracle-Managed Files on Oracle Express for Windows XPHow can I recover oracle database without new data?
In the US, can a former president run again?
Got a new frameset, don't know why I need this split ring collar?
Weird thing in 737 cabin
Print the new site header
What is this plant I saw for sale at a Romanian farmer's market?
Definition of 'vrit'
If the mass of the Earth is decreasing by sending debris in space, does its angular momentum also decrease?
Digital signature that is only verifiable by one specific person
Are there foreign customs agents on US soil?
How is linear momentum conserved in circular motion?
Are there any individual aliens that have gained superpowers in the Marvel universe?
How can the US president give an order to a civilian?
How would Japanese people react to someone refusing to say “itadakimasu” for religious reasons?
First occurrence in the Sixers sequence
What does "vrit' mean with reference to documentaries?
Does anyone recognize these rockets, and their location?
How to sort human readable size
Explicit song lyrics checker
How to avoid offending original culture when making conculture inspired from original
Does cooling a potato change the nature of its carbohydrates?
How did Frodo know where the Bree village was?
Is this broken pipe the reason my freezer is not working? Can it be fixed?
I wish, I yearn, for an answer to this riddle
How could I create a situation in which a PC has to make a saving throw or be forced to pet a dog?
How to delete alogs fom Oracle downstream target
Oracle DBV File ParameterOracle disaster recovery on LinuxOracle getting slowHow to delete .dbf file in oracle?Fixed expired accounts in Oracle 11gHow to wipe the slate clean on an Oracle installation?ORA-1034 Oracle Not FoundOracle IIg Windows 64 InstallHow to enable Oracle-Managed Files on Oracle Express for Windows XPHow can I recover oracle database without new data?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query:
SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG;
returns, for example, 10 archive logs. Is it correct to delete older logs, not registered in capture process? Please help to find correct suggestion. Is there any ready solutions for dealing with the old redo-transported logs or I need to write script from scratch?
oracle oracle-11g
asked Nov 26 '15 at 21:19
shcherbakshcherbak
239112
add a comment |
I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query:
SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG;
returns, for example, 10 archive logs. Is it correct to delete older logs, not registered in capture process? Please help to find correct suggestion. Is there any ready solutions for dealing with the old redo-transported logs or I need to write script from scratch?
oracle oracle-11g
asked Nov 26 '15 at 21:19
shcherbakshcherbak
239112
add a comment |
I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query:
SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG;
returns, for example, 10 archive logs. Is it correct to delete older logs, not registered in capture process? Please help to find correct suggestion. Is there any ready solutions for dealing with the old redo-transported logs or I need to write script from scratch?
oracle oracle-11g
asked Nov 26 '15 at 21:19
shcherbakshcherbak
239112
I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query:
SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG;
returns, for example, 10 archive logs. Is it correct to delete older logs, not registered in capture process? Please help to find correct suggestion. Is there any ready solutions for dealing with the old redo-transported logs or I need to write script from scratch?
oracle oracle-11g
oracle oracle-11g
asked Nov 26 '15 at 21:19
shcherbakshcherbak
239112
asked Nov 26 '15 at 21:19
shcherbakshcherbak
239112
asked Nov 26 '15 at 21:19
shcherbakshcherbak
239112
asked Nov 26 '15 at 21:19
shcherbakshcherbak
239112
asked Nov 26 '15 at 21:19
shcherbakshcherbak
239112
239112
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
spool the below query output and put into the script. This will delete the logs which are not required anymore.
SELECT
-- r.CONSUMER_NAME,
'rm ' || r.NAME
-- , to_char(r.FIRST_SCN),
-- to_char(r.NEXT_SCN),
-- case when (r.next_scn > c.required_checkpoint_scn) then 'NO' else 'YES' end purgable
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME and r.source_database = c.source_database and r.next_scn < ( select min(required_checkpoint_scn) from dba_capture
where capture_type='DOWNSTREAM')
and purgeable='YES'
order by modified_time;
answered Jun 1 at 1:54
NiteshNitesh
111
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f739233%2fhow-to-delete-alogs-fom-oracle-downstream-target%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
spool the below query output and put into the script. This will delete the logs which are not required anymore.
SELECT
-- r.CONSUMER_NAME,
'rm ' || r.NAME
-- , to_char(r.FIRST_SCN),
-- to_char(r.NEXT_SCN),
-- case when (r.next_scn > c.required_checkpoint_scn) then 'NO' else 'YES' end purgable
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME and r.source_database = c.source_database and r.next_scn < ( select min(required_checkpoint_scn) from dba_capture
where capture_type='DOWNSTREAM')
and purgeable='YES'
order by modified_time;
answered Jun 1 at 1:54
NiteshNitesh
111
add a comment |
spool the below query output and put into the script. This will delete the logs which are not required anymore.
SELECT
-- r.CONSUMER_NAME,
'rm ' || r.NAME
-- , to_char(r.FIRST_SCN),
-- to_char(r.NEXT_SCN),
-- case when (r.next_scn > c.required_checkpoint_scn) then 'NO' else 'YES' end purgable
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME and r.source_database = c.source_database and r.next_scn < ( select min(required_checkpoint_scn) from dba_capture
where capture_type='DOWNSTREAM')
and purgeable='YES'
order by modified_time;
answered Jun 1 at 1:54
NiteshNitesh
111
add a comment |
spool the below query output and put into the script. This will delete the logs which are not required anymore.
SELECT
-- r.CONSUMER_NAME,
'rm ' || r.NAME
-- , to_char(r.FIRST_SCN),
-- to_char(r.NEXT_SCN),
-- case when (r.next_scn > c.required_checkpoint_scn) then 'NO' else 'YES' end purgable
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME and r.source_database = c.source_database and r.next_scn < ( select min(required_checkpoint_scn) from dba_capture
where capture_type='DOWNSTREAM')
and purgeable='YES'
order by modified_time;
answered Jun 1 at 1:54
NiteshNitesh
111
spool the below query output and put into the script. This will delete the logs which are not required anymore.
SELECT
-- r.CONSUMER_NAME,
'rm ' || r.NAME
-- , to_char(r.FIRST_SCN),
-- to_char(r.NEXT_SCN),
-- case when (r.next_scn > c.required_checkpoint_scn) then 'NO' else 'YES' end purgable
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME and r.source_database = c.source_database and r.next_scn < ( select min(required_checkpoint_scn) from dba_capture
where capture_type='DOWNSTREAM')
and purgeable='YES'
order by modified_time;
answered Jun 1 at 1:54
NiteshNitesh
111
answered Jun 1 at 1:54
NiteshNitesh
111
answered Jun 1 at 1:54
NiteshNitesh
111
answered Jun 1 at 1:54
NiteshNitesh
111
111
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f739233%2fhow-to-delete-alogs-fom-oracle-downstream-target%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
