| RMAN Connect nocatalog in Legato [message #277208] |
Mon, 29 October 2007 04:21  |
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
|
Member |
|
|
How do you specify connect nocatalog in oracle 8.1.7 and NMO v4.1
Run the following RMAN SCRIPT
---
connect target sys/orac1@db1 nocatalog
run {
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=dbserver1.com, NSR_DATA_VOLUME_POOL=Default)';
backup current controlfile;
release channel t1;
}
---
also tried
connect nocatalog target sys/orac1@db1
..
But keep getting an error from Legator when running the job
NOCATALOG -- is a bad command
How do i specify in RMAN script for legator to connect with nocatalog? help will be appreciated
|
|
|
|
|
|
| Re: RMAN Connect nocatalog in Legato [message #277240 is a reply to message #277235] |
Mon, 29 October 2007 05:25  |
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
|
Member |
|
|
Thats what i tried at first not putting the nocatalog
But Legato came back with an error saying you are not connected to a catalog.
On the command line when testing
C:\> rman
if you start RMAN
RMAN>connect target sys/oradb1@db1
and then run the backup commands you get an error,
but if you run
c:\> rman nocatalog
RMAN>connect target sys/oradb1@db1
Then run the backup commands, you successfully use NMO to backup to tape
I tried removing the nocatalog
|
|
|
|
|
|
| Re: RMAN Connect nocatalog in Legato [message #277269 is a reply to message #277258] |
Mon, 29 October 2007 06:28 |
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
|
Member |
|
|
No i did not have a solution. That was just a test on the command line.
How do i put that in a script so Legato can execute the job.
When i add that line in the script
rman nocatalog
connect target sys/oracldb@db1
run {
..
.
}
I get an error from Legato job,
-- C:\>rman nocatalog
Is not a recognised command or batch command.
So how will i include the connections to rman with NOCATALOG in the script.
|
|
|
|
|
|
| Re: RMAN Connect nocatalog in Legato [message #277324 is a reply to message #277278] |
Mon, 29 October 2007 10:16 |
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
|
Member |
|
|
I do not have the details of the errors, i was working on site of a client trying to schedule orcle rman backups using legato 7.3.2.
we were using Networker Module for Oracle NMO 4.2.
- You run the rman script from savesets on the Legato Server.
when you submit the job on Legato, it executes the rman commands in the script. Oracle 9i was connecting ok without the nocatalog command, you simply put the connection is the script as
connect target sys/oracledb@dbi
it connects with the no catalog default, but the same in 8i is failing to connect ( it needs you to specify the nocatalog in the connection, and this is where my problem is. The error i was getting is the nocatalog part like i explained before)
- You provide environment parameters using nsrmon.bat file
- you write the rman script on the windows database server which legato executes as part of the rman backups.
So the error you want to know is all about the nocatalog connection. All the jobs for 9i were executed ok using the same commands in the script. I hope this points to where my problem is.
|
|
|
|
|
|
| Re: RMAN Connect nocatalog in Legato [message #277514 is a reply to message #277325] |
Tue, 30 October 2007 07:18 |
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
|
Member |
|
|
The errors:
--- from the msglog file ( configured in nsrnmo.bat )-------
Recovery Manager: Release 8.1.7.4.1 - Production
RMAN> CONNECT ***********************************************
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "nocatalog": expecting one of: "newline, ;"
RMAN-01007: at line 1 column 46 file: d:\oracle\rman\scripts/nmosb000003
---- From Legator Server log ---------
savegrp: suppressed 1 lines of verbose output
check daemon.log for details.
C:\>nsrnmostart -s bplbackup -g TEST -LL -m bpl_trackwise -l full -q -W 78 -N "d:\oracle\rman\scripts\prod1.rman" "d:\oracle\rman\scripts\twprod2.rman"
RMAN script execution is not successful. RMAN exited with return code '3'.
C:\>REM
C:\>REM Cleanup from the command
C:\>REM
C:\>ENDLOCAL
--------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
