Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Archive log destination full

589266Jan 12 2010 — edited Jan 12 2010
archive logs filesystem become full.

I want to set 2nd archive destination once 1st one is full....

oracle 10gr2 unix

Comments

Robert Geier
I don't know of any way to automatically switch to a second destination when the first is full.

You could :-

1. backup and delete files
2. move or zip files
3. increase the size of the destination
4. change the log_archive_dest using "alter system"
Azar
Backup archive log to tape or somewhere


rman>backup archivelog delete input
589266
Robert Geier wrote:
I don't know of any way to automatically switch to a second destination when the first is full.

You could :-

1. backup and delete files
2. move or zip files
3. increase the size of the destination
4. change the log_archive_dest using "alter system"
----

I have been doing it.....
but I want to make it automatic....
Robert Geier
So you just need a scheduled job to run rman job "backup archivelog all delete input". You can run from cron, or database scheduler, or OEM agent.
Hi,

Archive logs are very important when it comes to recovery. So backing up the archive logs is very important.

Backup your archive logs daily and maintain the archive logs for three days(this should be decided the size of your destination and how many archive logs generate for a day) on the disk.

The below command will backup the archivelogs and delete the archive logs generated before three days
BACKUP ARCHIVELOG ALL;
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
Regards,
Vijayaraghavan K
EdStevens
Vijayaraghavan Krishnan wrote:
Hi,

Archive logs are very important when it comes to recovery. So backing up the archive logs is very important.

Backup your archive logs daily and maintain the archive logs for three days(this should be decided the size of your destination and how many archive logs generate for a day) on the disk.

The below command will backup the archivelogs and delete the archive logs generated before three days
BACKUP ARCHIVELOG ALL;
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
Regards,
Vijayaraghavan K
You're on the right track, but how do you figure the above has any knowledge of "3 days old"?
Robert Geier
For archivelogs I prefer something like :-

delete noprompt force archivelog all completed before "sysdate-3" backed up 2 times to device type 'SBT_TAPE';
Hi Stevens,

Sorry my command was wrong for the above scenario, it will delete all expired backup.

I need to use the below command.
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-3' ALL DELETE ALL INPUT;
Regards,
Vijayaraghavan K
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 9 2010
Added on Jan 12 2010
#general-database-discussions
8 comments
1,944 views