Re: Urgent call, user managed recovery

Lanying & Manfred wrote:
> Hello,
>
> *** A TEST ENVIRONMENT OF AN BACKUP/RECOVER BEGINNER ***
>
> Ora9.2 Win XP
>
> I've a horror scenario in archivelog modus, a consistent full database
> backup is always available.
>
> At the beginning of the database session as a sysdba, I've created a
> controlfile backup to trace.
> I've done a shutdown immediate, after that I've destroyed all the online
> redolog files and controlfiles.
>
> Having destroyed all these nice files I've copied all the backup database
> files (files of the tablespaces)
> back to the appropriate directory.
>
> With the help of these statements (out of controlfile trace file) Ii want to
> recover the database.
> ---
> STARTUP NOMOUNT
>
> CREATE CONTROLFILE REUSE DATABASE "SUSHI" RESETLOGS ARCHIVELOG
>
> -- SET STANDBY TO MAXIMIZE PERFORMANCE
>
> MAXLOGFILES 50
>
> MAXLOGMEMBERS 5
>
> MAXDATAFILES 100
>
> MAXINSTANCES 1
>
> MAXLOGHISTORY 113
>
> LOGFILE
>
> GROUP 1 'C:\ORACLE\ORADATA\SUSHI\REDO01.LOG' SIZE 100M,
>
> GROUP 2 'C:\ORACLE\ORADATA\SUSHI\REDO02.LOG' SIZE 100M,
>
> GROUP 3 'C:\ORACLE\ORADATA\SUSHI\REDO03.LOG' SIZE 100M
>
> -- STANDBY LOGFILE
>
> DATAFILE
>
> 'C:\ORACLE\ORADATA\SUSHI\SYSTEM01.DBF',
>
> 'C:\ORACLE\ORADATA\SUSHI\UNDOTBS01.DBF',
>
> 'C:\ORACLE\ORADATA\SUSHI\DRSYS01.DBF',
>
> 'C:\ORACLE\ORADATA\SUSHI\EXAMPLE01.DBF',
>
> 'C:\ORACLE\ORADATA\SUSHI\INDX01.DBF',
>
> 'C:\ORACLE\ORADATA\SUSHI\ODM01.DBF',
>
> 'C:\ORACLE\ORADATA\SUSHI\TOOLS01.DBF',
>
> 'C:\ORACLE\ORADATA\SUSHI\USERS01.DBF',
>
> 'C:\ORACLE\ORADATA\SUSHI\XDB01.DBF'
>
> CHARACTER SET WE8MSWIN1252;
>
> --# Recovery is required if any of the datafiles are restored backups,
>
> --# or if the last shutdown was not normal or immediate.
>
> RECOVER DATABASE USING BACKUP CONTROLFILE
>
> --# Database can now be opened zeroing the online logs.
>
> ALTER DATABASE OPEN RESETLOGS;
>
> --# Commands to add tempfiles to temporary tablespaces.
>
> --# Online tempfiles have complete space information.
>
> --# Other tempfiles may require adjustment.
>
> ---
>
> After entering this statement
>
> ALTER DATABASE OPEN RESETLOGS; I get an obviously inconsistent system
> tablespace which needs recovery.
>
> *************************************************************************
> QUESTION NOW: Can Oracle handle this horror scenario?
> *************************************************************************

Change RECOVER DATABASE USING BACKUP CONTROLFILE to RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; and keep hitting enter until you get to a log you do not have. When you get there type cancel.

Regards,

Steve Received on Mon Jul 10 2006 - 13:56:23 CDT