if suppose we lost a database (target db doesnot exist) and it doesn't have recovery catalog but we only have the full backup and its archivelog
in this situation how do we recover the database? in 11g and prior 11g
2. how to restore archivelogs to filesystem, which was backedup using RMAN.
Yes, you can do the restore. You have to add the backups to the catalog (a new DB catalog or the controlfile catalog), then RMAN will use them as normal.
http://www.oracle-base.com/articles/10g ... kup_pieces
You don't need to restore the archived redo logs. When you issue a recover command, any required archived redo logs are automatically restored from their backups.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 11 guests