Database Cloning

[Adilsom Musskop]

Hello all :0:

I am doing a database cloning, and folloed all steps suggested by Sumit sarin in his book "Oracle DBA", bu, at end, in las line, when I order BD to OPEN with RESETLOGS clausule, it says me the following message "file 1 was not restored from a sufficiently old backup"
I am restoring my Database from my last cold yesterday's backup.

Have someone a suggestion??

I really would thanks!

[marist89]

I'm not familiar with that book, but I am guessing your control files are older than your system.dbf datafile.

[Adilsom Musskop]

I WILL EXPLAIN THE STEPS:

1) Create Parameters Files - Ok
2) Logon on My current DB, "ALTER DATABASE BACKUP CONTROFILE TO TRACE - Ok
3) Alter trace file to create all control files again.
This is my 'OpenClone.sql:

startup nomount pfile="D:\oracle\admin\clone\pfile\initclone.ora"
CREATE CONTROLFILE SET DATABASE "CLONE" RESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 1815
LOGFILE
GROUP 1 '\\ORACLE\ORADATA\CLONE\REDO01.LOG' SIZE 1M,
GROUP 2 '\\ORACLE\ORADATA\CLONE\REDO02.LOG' SIZE 1M,
GROUP 3 '\\ORACLE\ORADATA\CLONE\REDO03.LOG' SIZE 1M
DATAFILE
'\\ORACLE\ORADATA\CLONE\SYSTEM01.DBF',
'\\ORACLE\ORADATA\CLONE\RBS01.DBF',
'\\ORACLE\ORADATA\CLONE\USERS01.DBF',
'\\ORACLE\ORADATA\CLONE\TEMP01.DBF',
'\\ORACLE\ORADATA\CLONE\TOOLS01.DBF',
'\\ORACLE\ORADATA\CLONE\INDX01.DBF',
ALTER DATABASE OPEN RESETLOGS;


OK
4) Copy all Data Files and Redo Files - OK
Here I am restoring from my last cold backup - Today - 01:30 am
5) Define System Variables like ORACLE_HOME, ORACLE_SID... - OK
6) Initiate Instance - OK
7) Execute my "INITCLONE.SQL" - OK
Here error occurs pointing that '\\ORACLE\ORADATA\CLONE\SYSTEM01.DBF', is in error

Please, help me

Sorry by my so long post!!

[justadba]

Your script has a comma where it should have a semi-colon at the end of the file list. ie:

startup nomount pfile="D:\oracle\admin\clone\pfile\initclone.ora"
CREATE CONTROLFILE SET DATABASE "CLONE" RESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 1815
LOGFILE
GROUP 1 '\\ORACLE\ORADATA\CLONE\REDO01.LOG' SIZE 1M,
GROUP 2 '\\ORACLE\ORADATA\CLONE\REDO02.LOG' SIZE 1M,
GROUP 3 '\\ORACLE\ORADATA\CLONE\REDO03.LOG' SIZE 1M
DATAFILE
'\\ORACLE\ORADATA\CLONE\SYSTEM01.DBF',
'\\ORACLE\ORADATA\CLONE\RBS01.DBF',
'\\ORACLE\ORADATA\CLONE\USERS01.DBF',
'\\ORACLE\ORADATA\CLONE\TEMP01.DBF',
'\\ORACLE\ORADATA\CLONE\TOOLS01.DBF',
'\\ORACLE\ORADATA\CLONE\INDX01.DBF';
ALTER DATABASE OPEN RESETLOGS;

[Adilsom Musskop]

Thanks by your attention, but I've just typed wrong.
Im my SQL File there is a semicolon on the right place.
Anyway, thanks!!!