rman restore failed "no AUTOBACKUP found or specified handle is not a valid copy or piece"

[Lacey_Chu]

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>

[Lacey_Chu]

my nbu master and media server is named qin. the nbu client is named song-db.

[root@qin ~]# /var/images/NetBackup/srt/ed1166b/usr/openv/netbackup/bin/bplist -C song-db -t 4 -l -R /
-rw-rw---- oracle    oinstall     10485760 Oct 14 22:41 /cntrl_23_1_893112078
-rw-rw---- oracle    oinstall    360972288 Oct 14 22:41 /al_22_1_893112062
-rw-rw---- oracle    oinstall     51118080 Oct 14 22:41 /al_21_1_893112062
-rw-rw---- oracle    oinstall     70778880 Oct 14 22:40 /al_20_1_893112047
-rw-rw---- oracle    oinstall    739246080 Oct 14 22:40 /al_19_1_893112047
-rw-rw---- oracle    oinstall       262144 Oct 14 22:40 /bk_18_1_893112039
-rw-rw---- oracle    oinstall     10223616 Oct 14 22:40 /bk_17_1_893112036
-rw-rw---- oracle    oinstall       786432 Oct 14 22:40 /bk_16_1_893112029
-rw-rw---- oracle    oinstall      1310720 Oct 14 22:40 /bk_15_1_893112029
-rw-rw---- oracle    oinstall     10223616 Oct 14 22:33 /cntrl_14_1_893111594
-rw-rw---- oracle    oinstall    359661568 Oct 14 22:32 /al_13_1_893111579
-rw-rw---- oracle    oinstall     55050240 Oct 14 22:32 /al_12_1_893111571
-rw-rw---- oracle    oinstall     66846720 Oct 14 22:32 /al_11_1_893111556
-rw-rw---- oracle    oinstall    739246080 Oct 14 22:32 /al_10_1_893111556
-rw-rw---- oracle    oinstall       262144 Oct 14 22:32 /bk_9_1_893111544
-rw-rw---- oracle    oinstall     10223616 Oct 14 22:31 /bk_8_1_893111518
-rw-rw---- oracle    oinstall    426770432 Oct 14 22:31 /bk_6_1_893111503
-rw-rw---- oracle    oinstall    592183296 Oct 14 22:31 /bk_7_1_893111503
-rw-rw---- oracle    oinstall     10223616 Oct 14 11:47 /bk_6_1_893072835
-rw-rw---- oracle    oinstall       262144 Oct 14 11:47 /bk_8_1_893072836
-rw-rw---- oracle    oinstall     10223616 Oct 14 11:37 /bk_2_1_893072222
-rw-rw---- oracle    oinstall       262144 Oct 14 11:37 /bk_4_1_893072222
[root@qin ~]#

song-db:root # ./bplist -C song-db -t 4 -l -s 10/13/2015 -e 10/15/2015 -R /
-rw-rw---- oracle    oinstall     10485760 Oct 14 22:41 /cntrl_23_1_893112078
-rw-rw---- oracle    oinstall    360972288 Oct 14 22:41 /al_22_1_893112062
-rw-rw---- oracle    oinstall     51118080 Oct 14 22:41 /al_21_1_893112062
-rw-rw---- oracle    oinstall     70778880 Oct 14 22:40 /al_20_1_893112047
-rw-rw---- oracle    oinstall    739246080 Oct 14 22:40 /al_19_1_893112047
-rw-rw---- oracle    oinstall       262144 Oct 14 22:40 /bk_18_1_893112039
-rw-rw---- oracle    oinstall     10223616 Oct 14 22:40 /bk_17_1_893112036
-rw-rw---- oracle    oinstall       786432 Oct 14 22:40 /bk_16_1_893112029
-rw-rw---- oracle    oinstall      1310720 Oct 14 22:40 /bk_15_1_893112029
-rw-rw---- oracle    oinstall     10223616 Oct 14 22:33 /cntrl_14_1_893111594
-rw-rw---- oracle    oinstall    359661568 Oct 14 22:32 /al_13_1_893111579
-rw-rw---- oracle    oinstall     55050240 Oct 14 22:32 /al_12_1_893111571
-rw-rw---- oracle    oinstall     66846720 Oct 14 22:32 /al_11_1_893111556
-rw-rw---- oracle    oinstall    739246080 Oct 14 22:32 /al_10_1_893111556
-rw-rw---- oracle    oinstall       262144 Oct 14 22:32 /bk_9_1_893111544
-rw-rw---- oracle    oinstall     10223616 Oct 14 22:31 /bk_8_1_893111518
-rw-rw---- oracle    oinstall    426770432 Oct 14 22:31 /bk_6_1_893111503
-rw-rw---- oracle    oinstall    592183296 Oct 14 22:31 /bk_7_1_893111503
-rw-rw---- oracle    oinstall     10223616 Oct 14 11:47 /bk_6_1_893072835
-rw-rw---- oracle    oinstall       262144 Oct 14 11:47 /bk_8_1_893072836
-rw-rw---- oracle    oinstall     10223616 Oct 14 11:37 /bk_2_1_893072222
-rw-rw---- oracle    oinstall       262144 Oct 14 11:37 /bk_4_1_893072222
song-db:root #

[Marianne]

Have you tried to run bplist as 'oracle' user?
 

For troubleshooting, ensure these log folders exist :
On master : bprd ( restart NBU after creating the folder )
On client : dbclient with 777 permissions.

Please copy logs to .txt files (e.g. bprd.txt) and upload as File attachments.

[Marianne]

Have a look at this TN on how to restore control file from autobackup:  http://www.veritas.com/docs/000028586

[Genericus]

Remember, the client should be the source where the db was backed up, but run the script from the destination where you want to restore it.

Verify your backup using this command from the client:

# To find media to restore for oracle clients by Oracle block file - ON THE CLIENT  run this command:
     /usr/openv/netbackup/bin/bpclntcmd -ml /db_717_1_662950820 -ct Oracle
#    if you have dates you can add -s mm/dd/yy

(please change the values of the oracle block value from db_717_1_662950820! )

The fact that oracle uses one numbering system and NetBackup uses another always causes grief, but this can help determine if you are using the correct file.

[Michal_Mikulik1 · Accepted solution]

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