Saturday, October 22, 2011

How to manually register archive log file to resolve gap in standby database

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    How to manually register archive log file to resolve gap in standby database

Solution:






You can manually copy these files to standby and register them using:

SQL>ALTER DATABASE REGISTER LOGFILE '<file_name>';

e.g:

SQL>ALTER DATABASE REGISTER LOGFILE '/tmp/arc01.arc';
Get Oracle Certifications for all Exams
Free Online Exams.com