you also need a recovery catalog or you must use the control files as a repository. This requires the nocatalog option. I don't think you can set this option in the way you do it. I think there is an environment variable, where you can set the nocatalog mode. Check the manual please.
I think there are certain components in the script that you should add and try this again ex. catalog dtabase OR controlfile, you have not defined filesperset for the script, you have not defined backup server, media pool in the script. I think backup server parameter should be there for backups especially if you are running the script from the clinet. Try setting your script using this example script:
connect target system/manager@database; connect rcvcat rman/rman@catalog; run { set command id to 'abc';
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=backup_server,NSR_DATA_VOLUME_POOL=Default)' ; allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=backup_server,NSR_DATA_VOLUME_POOL=Default)' ; backup full filesperset 4 format '/FULL_%d_%u/' database include current controlfile ; sql "alter system archive log current"; backup format 'ar%d_t%t_s%s_p%p' (archivelog all);
BerndG_42aac9
22 Posts
0
June 29th, 2007 01:00
you also need a recovery catalog or you must use the control files
as a repository. This requires the nocatalog option. I don't think you
can set this option in the way you do it. I think there is an environment
variable, where you can set the nocatalog mode. Check the manual
please.
regards
Bernd
ble1
4 Operator
•
14.4K Posts
0
June 29th, 2007 02:00
Rudolph1
1 Rookie
•
28 Posts
0
June 29th, 2007 02:00
But my test.sql script? Will that work or is it wrong?
ble1
4 Operator
•
14.4K Posts
0
June 29th, 2007 03:00
amediratta
2 Intern
•
2K Posts
0
June 30th, 2007 19:00
connect target system/manager@database;
connect rcvcat rman/rman@catalog;
run {
set command id to 'abc';
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=backup_server,NSR_DATA_VOLUME_POOL=Default)' ;
allocate channel t2 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=backup_server,NSR_DATA_VOLUME_POOL=Default)' ;
backup full filesperset 4
format '/FULL_%d_%u/'
database
include current controlfile
;
sql "alter system archive log current";
backup
format 'ar%d_t%t_s%s_p%p'
(archivelog all);
release channel t1;
release channel t2;
}