Linux Backup Script

[reeshe]

Hi All,

Can you share me your RMAN BACKUP script for RHEL pls.
I need to backup my new Linux PROD Oracle 10g database.
And I misplaced my notes :(



Thanks a lot

[davey23uk]

well what have you come up with so far from the thousands of rman examples on the web

[reeshe]

Hi David,

I got this script but its from 8.1.7 version

Are the commands still valid in 10g? or deprecated

===============
c:\ rman target / nocatalog


run {
allocate channel c1 type disk format 'h:\rman_backup\dfcon_%d_%u_%s_%p';
backup
incremental level 0
tag "Full hot backup"
(database include current controlfile);

backup current controlfile tag='current';
release channel c1;

allocate channel c1 type disk format 'h:\rman_backup\arch_%d_%u_%s_%p';
change archivelog all validate;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

backup archivelog all;

sql "alter database backup controlfile to ''h:\rman_backup\cf01.
last''";
release channel c1;
}

============

How do I put it in bat batch file ? e.g backup.bat or backup.sh


Thanks a lot

[PAVB]

How do I put it in bat batch file ? e.g backup.bat or backup.sh

Ever heard about copy/paste?

[reeshe]

It wont run as is dear it need parameter to be passed

thanks

[davey23uk]

yet you provide no error, or any information

[reeshe]

I remember I have a notes before but it was lost

Its something like this:
I remember i have 2 or 3 files

1st file: rman1.exe > inside it is > rman target / nocatalog file=param.file
2nd file: param.file > inside it is> run {backup database} ... etc
3rd file: I'm not sure if it was cleaning up obsolete files

Can you just lend me your scripts instead

Thanks a lot

[reeshe]

By the way...what the difference between :

sql> alter system switch logfile;

and

sql> ALTER SYSTEM ARCHIVE LOG CURRENT;


Thanks a lot

[davey23uk]

none in real terms

[reeshe]

thanks

If i have 4 online redo, and i want to force archive log all contents of them 4, so that I can
backup the latest changes in the database into the tape drive or any external drives...
Do I have to issue
'ALTER SYSTEM SWITCH LOGFILE' four times (4x) or
'ALTER SYSTEM ARCHIVE LOG CURRENT' four times


thanks again