Backup strategy.

[manasa]

I have enabled export on my new sun server based oracle db.

I know that its not the right way to backup, hence i am going to enable hotbackups and after getting backup server will go for RMAN is my road map to backup.

My question here is how shall i write the shell script to automate?

I have more than 100 tablespaces, i find putting all the tablespaces into begin backup mode in script (more than 300 lines)will not make sense. Is there any way to put all the tablespace in backup mode by looping them making the script small and easy?

Appreciate any help on this part as i did not find much in googling(particularly an unix script).

[davey23uk]

begin
for i in (select tablespace_name from dba_tablespaces) loop;
execute immediate 'alter tablespace '||i.tablespace_name||' begin backup';
end loop;
end;
/


then watch your redo usage shoot through the roof.

if you ar eon 10g you can do alter database begin backup;

[marist89]

Don't waste your time with scripted backups. If you don't have an rman catalog, the controlfile will keep enough history to have a decent backup strategy.

http://marist89.blogspot.com/2005/05/backup-top-11.html