Select Menu

Ads

Random Posts

Powered By Blogger
Powered By Blogger

Blog Archive

Search This Blog

Blog Archive

Thirupal Boreddy. Powered by Blogger.

My Blog List

Followers

Lorem 1

Technology

Circle Gallery

Shooting

Racing

News

Lorem 4

» » Process for clearing down archivelogs via Rman

Process for clearing down archivelogs via Rman

The only way archive logs should be deleted is through rman, as follows.

Ensure that a backup isn't running at present

ps -ef grep bko - (or 'grep rman')

rman target / catalog or /var/opt/oracle/oratab_options)>

crosscheck archivelog all;

delete archivelog all backed up 2 times to sbt;

If this does not clear enough space, the 2 can be reduced to 1.

If more space needs to be reclaimed, then tha following can be used.

delete archivelog until time 'sysdate - 3';

Again the 3 can be reduced to clear more space. Note that using this method is a last resort, as it

deletes archive logs which have not been backed up to tape.

About Oracle DBA World

WePress Theme is officially developed by Templatezy Team. We published High quality Blogger Templates with Awesome Design for blogspot lovers.The very first Blogger Templates Company where you will find Responsive Design Templates.
«
Next
Newer Post
»
Previous
Older Post

No comments

Leave a Reply

QUERY FOR CPU USAGE

select  a.target_name as HOST, to_char(a.rollup_timestamp,' dd-Mon-yy::hh24:mi') as "DAY-TIME", sum(c.cpu_count) as ...