Recovery scenarios

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 260
Joined: Sat Jun 27, 2009 3:53 am
Location: India

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.

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

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:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests