Database Backup and Recovery (MOSC)

MOSC Banner

no AUTOBACKUP in 7 days found

edited Feb 23, 2014 12:39PM in Database Backup and Recovery (MOSC) 11 commentsAnswered ✓
 Dear Expert,
I want to ask about restore controlfile.
I always encountered following error.

channel t1: no AUTOBACKUP in 7 days found
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/25/2013 17:42:14
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

I already specify the file name of controlfile handle piece but still got that error
run {
allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
restore controlfile from 'ctl_PRD_20131117_831754284_658';
release channel t1;
}

Any input what can I do to restore but not using autobackup ?

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