HAPPY NEW YEAR 2021

For Any queries,collaborations please mail us at support@funoracleapps.com

Archive Location is Filled!! How to move to a different location with deleting and changing Archive destination

No comments

Archive Location is Filled!!  How to move to a different location with deleting and changing Archive destination


My archive location is filled and I want to move the archive logs to a different location because I need to make sure it is picked up in the next RMAN Backup. I just don't want to delete the archive without a backup to clear up my space.


Steps:

My SID= PROD
Archive Location= /archlog/PROD
New Location=/stage/oracle/prod/

Connect as an oracle user
Set the environment
mkdir -p /stage/oracle/prod/

rman target / 

backup as copy archivelog like '/archlog/prod/%' format '/stage/oracle/prod/PROD_%t_%s.arc' delete input;

.
This will move the archives and making your archive destination free. 




If you like please follow and comment

No comments :

Post a Comment