Friday, January 13, 2012

RMAN-05541: No archived logs found in target database

After setting up the auxiliary instance ora11g2, I tried to duplicate the database ora11g.
#rman target sys/pwd@ora11g auxiliary sys/pwd@ora11g2;
RMAN>duplicate target database to ora11g2 from active database
I got the following error.
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command
RMAN-05541: no archived logs found in target database
Solution
Archive current redo log file and proceed with the duplication.
SQL> alter system archive log current;
RMAN> duplicate target database to ora11g2 from active database;
Starting Duplicate
using channel ORA_AUX_DISK_1
contents of Memory Script: { sql clone "create spfile from memory"; }
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script: { shutdown clone immediate; startup clone nomount; }
executing Memory Script

No comments:

Post a Comment