Home » RDBMS Server » Backup & Recovery » Including Archive logs in Controlfile manually (oracle 12c Windows 2012)
Including Archive logs in Controlfile manually [message #676618] Tue, 25 June 2019 00:07 Go to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hello All,

We had an massive schema Import in our prod DB, which cause many archive log generation, but had low disk space.
So kept some archive logs aside.

When a new member generated RMAN backup, he found that, archive log missing, he didnt know the history.
So he did CROSSCHEK, which means the control file has ignored those archive log files, so the rman backup was successful.

But, now we are trying to copy those archive log back in to the default location and trying to make rman backup, we get these errors, how to tell the control file, that these archive log files should be added back again.

Starting backup at 20-JUN-19
specification does not match any archived log in the repository
backup cancelled because there are no files to backup
Finished backup at 20-JUN-19


allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1050 device type=DISK
specification does not match any archived log in the repository


Regards
krish
Re: Including Archive logs in Controlfile manually [message #676620 is a reply to message #676618] Tue, 25 June 2019 01:01 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You need to catalog the archive logfiles, for example,

CATALOG START WITH '/u01';
Re: Including Archive logs in Controlfile manually [message #676622 is a reply to message #676620] Tue, 25 June 2019 02:09 Go to previous messageGo to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi John,

Thanks for the reply.

Is it ok, if the series is mismatched?
I mean, the missing back up archive log sequence is two days before, can we make RMAN backup on these?

Thanks
krish
Re: Including Archive logs in Controlfile manually [message #676623 is a reply to message #676622] Tue, 25 June 2019 02:37 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Is it ok, if the series is mismatched?
I mean, the missing back up archive log sequence is two days before, can we make RMAN backup on these?
If you try it, you will find out Smile
Re: Including Archive logs in Controlfile manually [message #676626 is a reply to message #676623] Tue, 25 June 2019 02:56 Go to previous message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi John,

Yes, I got it.

Thanks
Krish
Previous Topic: what is the consequences of adding a plus archivelog and delete in oracle suggested backup
Next Topic: Drop guaranteed restore point and make more space
Goto Forum:
  


Current Time: Thu Mar 28 05:07:28 CDT 2024