Database Backup and Recovery (MOSC)

MOSC Banner

need to restore table tape

edited Aug 19, 2014 5:01AM in Database Backup and Recovery (MOSC) 1 commentAnswered

Hi Team,

I have one request to restore deleted records of 26th july. I have verified in logs and backup is completed to tape.

Whenever restore controlfile ,not able to restore as its telling looking for autobackup but at last restore is failed no valid backup piece or no autobackup found. I tried lot of options to restore but not able to.

Please any one suggest how to restore controlfile from tape.

I verified with backup team that tapes are available on that day.

I have tried below options but not able to restore controlfile.

connect target /

run {

set controlfile autobackup format for device type SBT_TAPE to "%F";

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