Cold backups shell script

From: Steven Alfisi <steven_at_alfisi.com>
Date: 16 Nov 2002 19:01:14 -0800
Message-ID: <a05aabfc.0211161901.32899cfb@posting.google.com>

I am running Oracle 9i Enterprise Edition on SuSe linux 7.3 pro. I am writing a shell script for a cold backup and the following line is giving me an ORA-00942 table not found error...

select 'cp '||name|| ' /data/oracle/os_backups/homedb' from v\$controlfile;

The log file that I am spooling too is saying that it's only recognizing v as the table name. I thought the \ would allow the $controlfile to be part of the table name. I also tried / just for sh$ts and giggles. I am using the bash shell. Any ideas?

Thanks in advance,
Steven Received on Sat Nov 16 2002 - 21:01:14 CST