Hi,
We want to be able to create a unique log file every time we run an
Oracle backup.
Currently, we just end up with a new log file that overwrites the
previous one, or we end
up always appending. We'd like instead to somehow have the newly created
log file get renamed to, say,
logfilename.date or something like that. That way, we have one from each
day. I can write a shell script
to rename the file, but I need some way to have the shell script get run
after the backups have completed.
I'd prefer this over just having some cron job do it. This way I know
the Oracle backups are done.
We're running 7.2.2 and backing up an Oracle database using the NMO.
Client runs 7.2.2.
Currently, we have an NSR client resource that specifies the pathname
for the RMAN script as
the saveset (just one), and it has 'nsrnmo' under the backup command
field. I was reading about savepnpc, but
we have nsrnmo listed for the field value because this is what the docs
said to do, so I don't see how savepnpc will help us here.
In taking a look at the nsrnmo script, I see this:
# Optional Variable: PRECMD
#
# Default value: NONE
#
# Description: This variable can be used to run a command or command script
# before nsrnmostart. It will be launched
once for every saveset
# entered in the client setup.
#
PRECMD=
# Optional Variable: POSTCMD
#
# Default value: NONE
#
# Description: This variable can be used to run a command or command script
# after nsrnmostart has completed. It will
be launched once for
# every saveset entered in the client setup.
#
POSTCMD=
I could create a shell script and list it for the PRECMD variable and
have it first rename the
current log, or I could use the POSTCMD, and do it after, but the thing
that bothers me is where they say
that it will be launched once for every saveset. Does this mean if we
have just the one RMAN script
listed for the client then it will only get run one time? OR, if the
RMAM backup script produces,
say, 5 save sets then it would get run 5 times? We're never going to
generate less than 2 save sets
based on the filesperset value in the RMAN script and the number of
files in our database. I'd say we would have
no fewer than 5 savesets from a backup and maybe a lot more if it's a
full. How do I solve this?
Thanks for any help
George
--
George Sinclair - NOAA/NESDIS/National Oceanographic Data Center
SSMC3 4th Floor Rm 4145 | Voice: (301) 713-3284 x210
1315 East West Highway | Fax: (301) 713-3301
Silver Spring, MD 20910-3282 | Web Site: http://www.nodc.noaa.gov/
- Any opinions expressed in this message are NOT those of the US Govt. -
To sign off this list, send email to listserv AT listserv.temple DOT edu and type
"signoff networker" in the body of the email. Please write to networker-request
AT listserv.temple DOT edu if you have any problems with this list. You can access the
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|