Re: Hot backup question

Hi Paulo,

You just need to use the "until cancel" syntax on the recover database command, and then cancel immediately. You can then do a resetlogs open of the database, which will restore it to the last transaction consistent state before the end of the backup. Of course, you will need then to take a new baseline backup to enable you to roll forward through any subsequently generated redo.

HTH, Steve Adams

On 16 Jun 1997 19:10:28 GMT, anti-spam_at_invalid.domain (PM) wrote:

>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 Wed Jun 18 1997 - 00:00:00 CDT