Netbackup RMAN 备份常见错误ora-19506 and ora-27028解决(英)

Details:

Overview:
NetBackup (tm) Oracle Recovery Manager (RMAN) backup fails, RMAN output shows errors
ORA-19506: failed to create sequential file
and
ORA-27028 skgfqcre: sbtbackup returned error.  
Backup fails immediately.

Troubleshooting:

Master Log Files:  N/A

Media Server Log Files:  N/A

Client Log Files:
In the dbclient log file, the following information is found:

12:59:17.054 [7569] <2> bsa_bplist: Request = oracle dba enterprise_bknet enterprise_bknet enterprise_bknet enterprise_rman 7 esvdevl 3 999 1121623156 1121795956 4 4 1 1 1 0 4 100 101 4 0 C C C C C 0 2 0 0 0
12:59:17.056 [7569] <4> bsa_bplist: Filepath = /esvdevl_bk_103_1_563979556
12:59:17.058 [7569] <2> dbc_get_string: Output = EXIT STATUS 133
12:59:17.058 [7569] <16> VxBSAQueryObject: ERR - dbc_get_string() failed 133
12:59:17.058 [7569] <2> xbsa_ProcessError: INF - entering
12:59:17.058 [7569] <2> xbsa_ProcessError: INF - leaving
12:59:17.058 [7569] <16> xbsa_QueryObject: ERR - VxBSAQueryObject: Failed with error:
 Server Status:  invalid request
12:59:17.059 [7569] <2> xbsa_QueryObject: INF - leaving (3)

Resolution:
On the master server, search for disallow statements by running the following command:

/usr/openv/netbackup/bin/admincmd/bpgetconfig | grep -i disallow

On a Windows master server, run the command:

\VERITAS\NetBackup\bin\admincmd\bpgetconfig

Look for the following in the output:

DISALLOW_CLIENT_LIST_RESTORE = YES
DISALLOW_CLIENT_RESTORE = YES

The first thing the Oracle backup does is run a bplist command to verify the backup image it wants to write is not already present.  Because NetBackup is configured not to allow the list of restores, the backup fails. This behavior is changed in the referenced "fixed in" version. Oracle backups no longer fail with the "fixed in" versions due to client list/restore restrictions.

Resolve this by removing the two disallow statements from the master server's bp.conf file (or from the registry on a Windows master server).  For a UNIX master server, the bp.conf file can be manually edited with any text editor.  Both Windows master servers and UNIX master servers can modify these values by using the NetBackup Administrative Console.  

Open the NetBackup Administrative Console, and from under Host Properties, select the master server. In the Client Attributes section, confirm the Global Attributes are set to allow client browse and restore. Also, confirm that the Oracle client does not have any additional limitations on the ability to browse for, or restore files.  

Restart the master server's NetBackup daemons or services after making these changes to the master's configuration.