-
Database Cloning
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!
Adilsom José Musskopf
Live like each of your days was the last.
-
I'm not familiar with that book, but I am guessing your control files are older than your system.dbf datafile.
Jeff Hunter
-
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!!
Adilsom José Musskopf
Live like each of your days was the last.
-
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;
Eric Hanson
There are 10 types of people in the world:
Those who understand binary and those who don't!
-
Thanks by your attention, but I've just typed wrong.
Im my SQL File there is a semicolon on the right place.
Anyway, thanks!!!
Adilsom José Musskopf
Live like each of your days was the last.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|