| 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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
