jeevan mathew
asked on
archive-destination
When we receive the following message is received: ORA-00257 archiver is stuck. Connect internal only, until freed.
We can take backup of archivelogs and remove them .
How we will the backup of archive logs .
We can take backup of archivelogs and remove them .
How we will the backup of archive logs .
The easiest way to remove them is if you use Oracle's RMAN utility to back up your database and your archived redo logs. You can then configure RMAN to automatically remove the archived redo logs after they have been backed up once (or twice, or whatever number you are comfortable with).
If you use some other tool to backup your Oracle database and archived redo log files, you may be able to add a command in that tool (or in a script that calls that tool) to remove archived redo logs that are older than a certain time frame (like maybe a day or two or three).
If you use some other tool to backup your Oracle database and archived redo log files, you may be able to add a command in that tool (or in a script that calls that tool) to remove archived redo logs that are older than a certain time frame (like maybe a day or two or three).
ASKER
could you please tell me the commands for that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
>>We can take backup of archivelogs and remove them .
Yes. Removal of them after appropriate backups is common.
>>How we will the backup of archive logs
That depends on how you back up your database and what backup strategies you have in place.
You typically want individual files on multiple tapes in case one tape snaps.