rman restore failed "no AUTOBACKUP found or specified handle is not a valid copy or piece"
Hi,
I want to restore oracle db of my linux server, but it failed. Could anyone help me??
RMAN> startup force nomount
Oracle instance started
Total System Global Area 17103163392 bytes
Fixed Size 2308896 bytes
Variable Size 8657044704 bytes
Database Buffers 8422162432 bytes
Redo Buffers 21647360 bytes
RMAN> run {
allocate channel c1 type 'sbt_tape';
send 'NB_ORA_SERV=qin, NB_ORA_CLIENT=song-db';
restore controlfile from ' /cntrl_14_1_893111594';
release channel c1;
}
2> 3> 4> 5> 6>
allocated channel: c1
channel c1: SID=582 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.7 (2015062002)
sent command to channel: c1
Starting restore at 15-OCT-15
channel c1: no AUTOBACKUP in 7 days found
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/15/2015 11:14:48
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
RMAN>
Hallo,
you cannot restore controlfile with this syntax ("from ' /cntrl_14_1_893111594';).
1/if you use RMAN catalog (rcvcat is used in your backup script), then simply use:
restore controlfile;
2/if you dont use RMAN catalog (rcvcat not used), then you should have controlfile autobackup configured and then use:
restore controlfile from autobackup;
but I dont see any autobackup in your bplist (it has a format = c-DBID-date-nn).
I recommend you to consult your Oracle admin when configuring Oracle backups.
Rgds
Michal