OraFAQ Forum: Backup & Recovery » problem while taking cold backup

Home » RDBMS Server » Backup & Recovery » problem while taking cold backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem while taking cold backup [message #217205]

Thu, 01 February 2007 03:06

pavan27
Messages: 50
Registered: December 2006
Location: bangalore

Member

Hi to every one,

i had a problem while taking cold backup.

this is my script file.
set echo off
set pause off
set feed off
set head off
spool cold_baskup.sh
select 'cp '||name||'/diks1/oracle/oradata/backup' from v$datafile;
select 'cp '||name||'/disk1/oracle/oradata/backup' from v$tempfile;
select 'cp '||name||'/disk1/oracle/oradata/backup' from v$controlfile;
select 'cp '||member||'/disk1/oracle/oradata/backup' from v$logfile;
spool off

when i execute my cold_backup.sh at os level
only redo,temp ts, system ts is backing up remaining are not comming in the backup.
can any one explain waat is the error/what mistake i am dooing..
-------------------------------------------------
i did same i windows. how can in run the spool file in windows command promt.
-------------------------------------------------
thanks,
pavan

[Updated on: Thu, 01 February 2007 03:10]

Report message to a moderator