Backing up oracle using Netbackup7 . Error with RMAN ......RMAN-00554.......RMAN-04005: error from target database:

[mrinal_sarkar62]

Hi all,
I was trying to backup Oracle database using templete.
The following log is generated as follows:-

INF - Begin progress logging for process: (2380.5912)
INF - Putting the database in mount state.
INF - Using: "c:\oracle\product\10.2.0\db_1\bin\sqlplus.exe"
INF - Connection info: 'connect system/*****@devdb as SYSDBA'.
INF - Start of SQLPLUS output.
INF - SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 29 19:28:08 2010
INF - Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
INF - SQL> ERROR:
INF - ORA-12514: TNS:listener does not currently know of service requested in connect
INF - descriptor
INF - SQL> ORA-01012: not logged on
INF - SQL> ORA-01012: not logged on
INF - SQL> ORA-01012: not logged on
INF - End of SQLPLUS output.
INF - Using policy Windows_ORC_vm1 to perform a user directed Oracle Stream Based backup.
INF - Starting Oracle Recovery Manager.
INF - Using: "c:\oracle\product\10.2.0\db_1\bin\rman.exe"
INF - Connection info: target 'system/*****@devdb' nocatalog
INF - Start of Recovery Manager input.
INF - # -----------------------------------------------------------------
INF - # RMAN command section
INF - # -----------------------------------------------------------------
INF - RUN {
INF - ALLOCATE CHANNEL ch00
INF -     TYPE 'SBT_TAPE';
INF - SEND 'NB_ORA_CLIENT=mbhi-srv2-vm1,NB_ORA_POLICY=Windows_ORC_vm1,NB_ORA_SERV=mbhi-app-srv-20,NB_ORA_SCHED=Monthly_Full';
INF - BACKUP
INF -     INCREMENTAL LEVEL=0
INF -     FORMAT 'bk_u%u_s%s_p%p_t%t'
INF -     DATABASE;
INF - RELEASE CHANNEL ch00;
INF - # Backup Archived Logs
INF - ALLOCATE CHANNEL ch00
INF -     TYPE 'SBT_TAPE';
INF - SEND 'NB_ORA_CLIENT=mbhi-srv2-vm1,NB_ORA_POLICY=Windows_ORC_vm1,NB_ORA_SERV=mbhi-app-srv-20,NB_ORA_SCHED=Monthly_Full';
INF - BACKUP
INF -     FORMAT 'arch_u%u_s%s_p%p_t%t'
INF -     ARCHIVELOG
INF -         ALL
INF -     DELETE INPUT;
INF - RELEASE CHANNEL ch00;
INF - # Control file backup
INF - ALLOCATE CHANNEL ch00
INF -     TYPE 'SBT_TAPE';
INF - SEND 'NB_ORA_CLIENT=mbhi-srv2-vm1,NB_ORA_POLICY=Windows_ORC_vm1,NB_ORA_SERV=mbhi-app-srv-20,NB_ORA_SCHED=Monthly_Full';
INF - BACKUP
INF -     FORMAT 'ctrl_u%u_s%s_p%p_t%t'
INF -     CURRENT CONTROLFILE;
INF - RELEASE CHANNEL ch00;
INF - }
INF - End of Recovery Manager input.
INF - Start of Recovery Manager output.
INF - Recovery Manager: Release 10.2.0.4.0 - Production on Thu Jul 29 19:28:40 2010
INF - RMAN-00571: ===========================================================
INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
INF - RMAN-00571: ===========================================================
INF - RMAN-00554: initialization of internal recovery manager package failed
INF - RMAN-04005: error from target database:
INF - End of Recovery Manager output.
INF - End Oracle Recovery Manager.
INF - Putting the database in open state.
INF - Using: "c:\oracle\product\10.2.0\db_1\bin\sqlplus.exe"
INF - Connection info: 'connect system/*****@devdb as SYSDBA'.
INF - Start of SQLPLUS output.
INF - SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 29 19:29:07 2010
INF - Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
INF - SQL> ERROR:
INF - ORA-12514: TNS:listener does not currently know of service requested in connect
INF - descriptor
INF - SQL> SP2-0640: Not connected
INF - SQL> SP2-0640: Not connected
INF - End of SQLPLUS output.
=====================================================================

As I found a forum where it only says that
"Did you allow to connect target DB via Oracle Net Service(Listener) with SYSDBA privilege? I found similar case in knowledge base. Try to change remote_login_passwordfile parameter to exclusive."
But there was no further discussion.
I am not a oracle expert.
Can any one help me.

Thanks.
Mrinal

[Marianne]

Me neither...

That's why I always insist to have an Oracle DBA with me whenever a new Oracle client needs to be configured.
RMAN is part of Oracle - therefore the Oracle DBA's responsibility.
All you need to do from NBU point of view is to create a policy and ensure enough media is available.

[Will_Restore · Accepted solution]

your dba needs to add an entry to listener.ora so oracle knows what devdb is

[mrinal_sarkar62]

Hi,
I am very much support your advice, Marianna, but the problem is that the BDA is with me is a newly joined employee.
When I am trying to say my problem he simply shows me that using the given user name and password he can log-in from his local system(remote log in) and can start the backup form the Oracle 10's RMAN itself.

What should I do, escallate the case to the higher manager or I'll stab that DBA.

But in either case my problem not being solved.
Let see, that Wrobbins's solution works or not.

Thanks.

Mrinal Sarkar

[Marianne]

Let's try and convince the DBA to help us....

If I understand correctly - the backup works when the DBA start the backup from RMAN?
It only fails when the script is started from the NBU policy?
If this is correct, let's try baby steps:

Ask the dba to run the script on the client while logged in as oracle user.
If that works, try to run the script as root (this is what the agent is doing).
Let us know how it goes.
If you post the backup script, one of us can ask one of our DBA friends to check it for possible problems...

[mrinal_sarkar62]

Hi All,

Thanks a lot to all of you for the pin pointing the problem. As I told to the higher managment and the pressure came to the DBA and then he himself came for the co-operation.
The issue was as follows:-
1. The database does'nt have archive log enabled.
2. I have wrong information of  "TNS Alies"  name.

As the DBA was not coporating with me ,I myself went  for studing RMAN command. So , I went and logged in and enabled the archive log. Then I once unmounted and mounted the database.
After that I changed the Schedule name to "Default Application Backup" (This is the default application shedule autometically created at the time of policy creation) in the templete of the netbackup for Oracle in the client side. Previously I was using "Autometic backup" name
Then I started a hot backup and it went successfully.
As we were trying for the cold backup so , again I disabled the "Archive Log" in the Oracle and edited the templete at the Oracle server(Netbackup Client).
Then, I enable the two option " make the database offline before taking backup " and  " make the database online after the backup".
after doing this the backup was failing.
I went for the Symantec Support.
The person name was Alien. He went and checked every thing from registry entry to enviourment variables but found nothing along he checked the policy of the netbackup for oracle.
He then restarted the database. and BINGO!! the backup was successful using cold backup.
The problem was I have'nt restarted the database after the "Archive Log " disabled.

I want to know three things:-
1. What Alien checked in the registry?
2. What need to be there in the  windows Variables?
3. What we need to do for incremental backup for Oracle(As I  don't find any of that optionin teh schedule policy)?

Thanks.
Mrinal Sarkar

[mrinal_sarkar62]

The DBA have update the listener.ora as wrobbins have told us.
Thanks a lot to all of you.