Database Backup and Recovery (MOSC)

MOSC Banner

Recovery without archivelog

edited Mar 18, 2013 1:41PM in Database Backup and Recovery (MOSC) 10 commentsAnswered
 Dear Team,
Our NAS storage crashed, on the same we were having development server and last 3 month development was there.

Now, we have RMAN full hot backup with us but without archivelog file.

Restoration is completed but unable to do recovery.

RMAN> recover database;

Starting recover at 28-JAN-13
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/28/2013 10:02:47
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until cancel using backup controlfile

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center