Home » RDBMS Server » Backup & Recovery » problem while taking cold backup
problem while taking cold backup [message #217205] Thu, 01 February 2007 03:06 Go to next message
Messages: 50
Registered: December 2006
Location: bangalore
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.

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

Report message to a moderator

Re: problem while taking cold backup [message #217209 is a reply to message #217205] Thu, 01 February 2007 03:23 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


go through above link


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

Report message to a moderator

Previous Topic: Backup issues on Windows
Next Topic: Problem with duplicate database using rman
Goto Forum:

Current Time: Thu Oct 27 20:13:07 CDT 2016

Total time taken to generate the page: 0.09235 seconds