Re: Problem creating database copy from hot backup

On 26 Feb 2003 09:37:48 -0800, gbvguy_at_yahoo.com (Michael Spragg) wrote:

>I am trying to create a copy of a 8.1.7 production database to a test
>machine using hot backups. I do the following steps:
>
>* On the source machine ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
>* Run hot backup on production machine to tape
>* Restore backed up files on tape to test server
>* Create a script to create a new controlfile for the new database
>using the output from step 1. I modify the CREATE CONTROLFILE
>statement as follows and I strip out everything except the following:
>
> STARTUP NOMOUNT
> CREATE CONTROLFILE SET DATABASE "new_dbname" RESETLOGS NOARCHIVELOG
> MAXLOGFILES 32
> MAXLOGMEMBERS 2
> MAXDATAFILES 33
> MAXINSTANCES 8
> MAXLOGHISTORY 908
> LOGFILE
> ... List redo logs modified to reflect new locations on test server
> DATAFILE
> ...List datafiles modified to reflect new locations on test server
> CHARACTER SET WE8ISO8859P1;
>
>* Run the script from previous step on test server in SVRMGRL
>* Recover the database with the following command:
>
> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
>
>* I successfully apply archived redo logs and when I get to the
>desired point I type CANCEL.
>
>I have tried this at least a half dozen times on different databases
>and at this point I *always* get the same message in reference to the
>SYSTEM datafile:
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> CANCEL
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get
>error below
> ORA-01194: file 1 needs more recovery to be consistent
> ORA-01110: data file 1: '/u5/oradata/tcedm/system01.dbf'
>
>Am I missing a step or doing something wrong here? Is it possible to
>create a copy of a database this way?
>
>Any help would be greatly appreciated.
>
>Thanks - Mike

You would need to switch logfile prior to backing up the archived redo log files in your backup procedure. You are missing the online redo logfile, and NO: you shouldn't back it up during hot backup as has been explained many times in this group.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 26 2003 - 12:21:28 CST