topic ALTER DATABASE OPEN RESETLOGS; in Operating System - HP-UX

ALTER DATABASE OPEN RESETLOGS;

Enrico Venturi — Thu, 02 Oct 2003 09:17:00 GMT

Hello colleagues,
I perform the online backup of a database DBSNML and I copy the relevant files to another machine; here I've created another instance of a database DBSNML1 ...
After the creation, while the DB is empty, I perform the controfile backup by:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

After that I import the DBSNML datafiles, then I perform a startup nomount and a I create the new controlfile by setting the database name to DBSNML1

After that I try to startup the DB: it's ok, but when I open it it requires the recovery of the system.dbf ...

How can I solve this problem?

Enrico

Re: ALTER DATABASE OPEN RESETLOGS;

Hari Kumar — Thu, 02 Oct 2003 09:23:08 GMT

Have you done Shutdown cleanly, i mean Shutdown immediate,
You need to switch log files immediately after the point in time that you want to recover to. I believe that this will give you the last change that you are looking for ,
then u do clean shutdown and then follow again with all the procedure(copying all the files ), u have done with.

Hope u got,
Thanks

Re: ALTER DATABASE OPEN RESETLOGS;

twang — Thu, 02 Oct 2003 09:58:02 GMT

If you are sure that the last shutdown was not normal or immediate, recovery is not required. Then you can "CREATE CONTROLFILE REUSE set DATABASE RESETLOGS" to recreate the database.

Re: ALTER DATABASE OPEN RESETLOGS;

Stan_17 — Fri, 03 Oct 2003 12:26:00 GMT

Hi,

when you say, you copied relevant files, did you copy the recent archive logs that were generated after the hotbackup started. besides, are you switching logfiles at the end of your hotbackup script. if not then, thats the problem.

so do a hotbackup which has a switch logfile statement at the end of your backup script, copy all datafiles, archivelogs to the another machine.

startup nomount;
create controlfile set dbsnml1...restlogs...
recover database using backup controlfile
feed the necessary archivelogs
alter database open resetlogs.

hth,
Stan