[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

rman

when i type archive log list i get archive log files of different instance at the end. Can you pleas tell what's wrong
0
vadicherla
Asked:
vadicherla
  • 3
  • 2
  • 2
  • +2
2 Solutions
 
joebednarzCommented:
Maybe the current database was a clone or copy of the previous???

If you know the approximate date of the archive logs (for instance up til 2 weeks ago):

DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-14';
0
 
vadicherlaAuthor Commented:
No its not a clone of any. Its gold instance from were we copy all other instances. I just want to know how archivelog files populated here which belongs to other instance

Thanks
Sudhakar
0
 
mohammadzahidCommented:
Maybe your archive log files are mutiplexed to create at different location. Check log_archive_dest paramater sne see if any archive are created there MANDATORY parameter or not.

Please post your rman commmand or script here.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Richard OlutolaConsultantCommented:
Are you running other instances on the same box?

It could be a typo in the location of the other instances. Are all those foreign archive logs current?
0
 
mohammadzahidCommented:
Maybe your log_archive_dest parameter is using SERVICE_NAME to connect to different instance (remote host)

LOG_ARCHIVE_DEST_2 = 'SERVICE=standby1'

Can you check spfile or init.ora file for this parameter.

See this url on setting up Archive log.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/archredo.htm
0
 
vadicherlaAuthor Commented:
can you tell me how to move arvhivelog location from location to another in rman.  


Thanks
Sudhakar
0
 
vadicherlaAuthor Commented:
I want to move some of archive log files from one location to another and update the catalog repository about the chage by giveing crosscheck archivelog all;

Thanks
Sudhakar
0
 
Richard OlutolaConsultantCommented:
What I tend to do is when I take my full backups with Backup Database, I include the archivelogs and then I delete the archivelogs since they have already been backed up. This way you don't need to shift archivelogs around because I guess you're running to space issues.

Try the following:

backup database plus archivelog delete input;

This takes your data backup, and backs up the archivelogs, then delete the archivelogs freeing up valuable space.

Richard.
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

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.

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