Hot backup question

From: PM <anti-spam_at_invalid.domain>
Date: 1997/06/16
Message-ID: <5o4334$m3p$1@newstoo.worldbank.org>#1/1

This is my online backup procedure:

	1- For each tablespace
		alter tablespace begin backup
		send datafile to tape
		alter tablespace end backup
	2- alter system switch logfile
	3- alter database backup controlfile to '/tmp/controfile'
		send backup controlfile to tape

	4- backup to tape the archived logfiles

I want to restore that database in another server, but using different paths to the datafiles,archives, etc. Here's is my restore process:

	1- Create new init.ora file 
	2- Restore datafiles from tape
	3- Restore controlfile from tape
	4- Restore archived logfiles from tape
	5- SQLDBA
		startup mount
		alter database rename file ... ( since the paths have changed)
		recover database using backup controlfile 

		At this point Oracle starts asking for archived logfiles, but 

the problem is that the first archived logfile it asks for is the archived logfile created after the "switch logfile" command in the backup procedure above, and that I don't have in tape.

        Am I doing something wrong or the whole concept is wrong ?

        Please respond to pmotta_at_worldbank.org .

        Thank you,

        Paulo Received on Mon Jun 16 1997 - 00:00:00 CDT