Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 784
  • Last Modified:

Archiver hung

I need to switch the archive log destination as my archiver has just hung in one of my 10g DBs. The commands: alter system archivelog stop;
alter system archivelog start to 'new location';

don't work, What is the correct syntax for 10g?

Also, to get around this in the meantime I simply relinked the archive directory to a new destination. The trouble now is how do I backup the archived redo logs in the original location? RMAN is looking for them under this same archive directory but of course this is just a link.

Thanks,
Mike.
0
MikeHunt
Asked:
MikeHunt
  • 3
  • 2
1 Solution
 
sanjeev559Commented:
go through the link you will get more exposure to those topics

http://www.oracle-base.com/articles/10g/RMANEnhancements10g.php
0
 
MikeHuntAuthor Commented:
It's a bit more urgent than that ... can you tell me how RMAN can backup archive logs if they're in a different location to the one  they were created in? ie. the link was changed but the location remained the same for the DB.

Can this even be done?
0
 
marperCommented:
You should post your question under Oracle section not under any DB general question sections and I belive you would get an answer by yestarday.
Anyhow ARCHIVE LOG START has been deprecated in 10g

You should be able to change the parameter while the database is up and running with ALTER SYSTEM SET LOG_ARCHIVE_DEST_1=......
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
MikeHuntAuthor Commented:
yep .. I didn't realize I'd posted the question in the wrong section. Anyway, the problem was fixed this morning but thanks for the info anyway.

Mike.
0
 
marperCommented:
In that case, could you please ask a moderator to either close this question or award the points to whoever gave you a correct answer ?
0
 
marperCommented:
you have accepted the answer while I was typing my message...sorry and thanks :)
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now