Database Backup and Recovery (MOSC)

MOSC Banner

Recover from a backed recovery area

edited Jul 6, 2012 5:51AM in Database Backup and Recovery (MOSC) 7 commentsAnswered
Oracle 11gr2 

I do full backups to disk every day an then backup the recovery area to tape. I need to restore a archive log from three days ago but I don't know and I did not fine any info to do this.

Thank you for any help

try 1)

RMAN> run {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
restore archivelog sequence 327 thread 2;
}

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=355 instance=psytfpe1 device type=DISK

Starting restore at 12-DEC-11

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/12/2011 15:16:29

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