Oracle-L: More RMAN on Windows questions

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Thu, 10 Apr 2003 14:18:39 -0800
Message-ID: <F001.0057F469.20030410141839@fatcity.com>

When an RMAN job is run via the OEM / Oracle Management Server job scheduler, where is it specified whether RMAN is using a repository or not? Is this information embedded in the TCL script that runs the job?
I am trying to find out whether or not I can recover a database with the RMAN backups currently in place. The job runs from OEM, and the RMAN script is as follows:

run {
allocate channel Channel1 type disk format 'D:\Backup\b_%u_%p_%c'; backup ( database include current controlfile setsize 30720000 filesperset 64 );
backup ( archivelog all
setsize 30720000 filesperset 64 delete input );

}

I've copied the resulting backup sets (two files: one DB, one archived logs) to another server. I've used DBCA to create a new Oracle instance on that server, and successfully started (nomount) the instance.

Is it even possible to recover this database? I have no control files other than those included in the database backup set, nor do I have spfiles.

Thanks,

Paul Baumgartel

Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Paul Baumgartel
INET: treegarden_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 10 2003 - 17:18:39 CDT