Recovery scenarios

All posts relating to Oracle database administration.

Moderator: Tim...

Recovery scenarios

Postby sivakumarocp » Tue Nov 20, 2012 7:32 pm

Hi Tim,

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.
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: Recovery scenarios

Postby Tim... » Tue Nov 20, 2012 8:03 pm


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. ... 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
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:
Site Admin
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 3 guests