Database Backup and Recovery (MOSC)

MOSC Banner

How to restore controlfile backup piece without backup controlfiles

edited May 8, 2014 9:41AM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓

I've monthly rman backups and wish to restore a backup to a new host for testing.

Backups have been taken with autobackup on.

After prearing new host and statring oracle in nomount I've tried to restore controlfile from backup piece as below

but it errors searching for auto backups whiche are not present

How to restore controlfie backup piece when controlfile backup peices are not present

RMAN>run

{

set DBID 2545844721

restore controlfile from '/u01/backups/bak_PANT_s_qrp22jb4.CTL'

}

executing command set DBID

starting restore at 07-MAY-2014 16:19:21

ussing channel ORA_DISK_1

channel ORA_DISK_1: no AUTOBACKUP in 7 days found

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