| Re: problems with rman oracle 9i [message #50824] |
Tue, 09 April 2002 10:07 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
allocate is a seperate command. format goes in the database backup or archive backup command. Try this:
run {
allocate channel c1 type disk;
backup
format '/backup/u00/oracle/prod/df_%d_%p_%c'
(database);
sql 'alter database open';
release channel c1;
}
I think you may have problems with the "sql 'alter database open';" command. I do not have version 9 but you might look into it if you have problems. You may be able to do "open database" and not have to call from sql.
Note the following example (where backup begins and semicolon ends):
run {
# Hot database level 0 whole backup
allocate channel c1 type disk;
backup
incremental level 0
skip inaccessible
tag hot_db_bk_level0
# recommended format
format '/export/home/oracle/exports/backups/rman_backups/bk_%s_%p_%t'
(database include current controlfile);
sql 'alter system archive log current';
# backup all archive logs
backup
format '/export/home/oracle/exports/backups/rman_backups/al_%s_%p_%t'
(archivelog all delete input);
}
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
