Operating System - HP-UX
1752782 Members
6334 Online
108789 Solutions
New Discussion

Tina Oracle cold backup list

 
LE_1
Advisor

Tina Oracle cold backup list

Hi,

I created a "Oracle" object for Tina (for hot backup).
I just want to generate a
the list : tina_cold_SID.txt
and I have this error :
"Oracle cold backup list generation failed ERR_FNF"
when I launch a full backup.

My database is up, NOarchivelog because I just want to generate the cold backup list, not to do a real
hot backup.
What's wrong here ?

Is there another way to generate this list for a Oracle db ?

thanks

1 REPLY 1
Christophe MAILHE
Frequent Advisor

Re: Tina Oracle cold backup list

SET HEADING OFF;
SET LINESIZE 255;
SET TRIMSPOOL ON;
SET PAGESIZE 0;
SET VERIFY OFF;
SET FEED OFF;
SET ECHO OFF;
SPOOL tina_cold_SID.txt;
select name from v$datafile;
select member from v$logfile;
select name from v$controlfile;
select value from v$parameter where UPPER(name) = 'IFILE';
SPOOL OFF;


This do not include PFILEs