Thursday, February 10, 2011

RMAN: Archivelogs lost

Problem: I have lost some of the archivelog files without taking backup. If I run the rman to backup available archive logs, it throws error that the archivelog_seq# is not available.

Solution: run the following command.

RMAN> change archivelog all validate;

Now you run the backup archivelog command. RMAN will backup the available archivelogs successfully.



Eva Lona said...

Good post. Really usefull for oracle solutions

Path Infotech said...

Path Infotech is in the field of oracle training program from past several years.

For more info : Oracle Certification Courses

Keylabs Training said...

Awesome post thanks for sharing Oracle training



Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com