| Database Cold Cloning [message #581388] |
Fri, 05 April 2013 04:20  |
 |
Indra Parmar
Messages: 6
Registered: March 2013
Location: Surat
|
Junior Member |
|
|
Hello All,
I am trying to perform cold cloning at my home pc.
when i am trying to ceate control file , i got this error.
please anyone can help me out..?
SQL> CREATE CONTROLFILE SET DATABASE "fclone" RESETLOGS FORCE LOGGING NOARCHIVEL
OG
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 5
4 MAXDATAFILES 10
5 MAXINSTANCES 1
6 MAXLOGHISTORY 400
7 LOGFILE
8 GROUP 1 'C:\app\Indra\oradata\fclone\REDO01.log',
9 GROUP 2 'C:\app\Indra\oradata\fclone\REDO02.log',
10 GROUP 3 'C:\app\Indra\oradata\fclone\REDO03.log'
11 DATAFILE
12 'C:\app\Indra\oradata\fclone\system01.dbf',
13 'C:\app\Indra\oradata\fclone\undotbs01.dbf',
14 'C:\app\Indra\oradata\fclone\users01.dbf',
15 'C:\app\Indra\oradata\fclone\sysaux01.dbf',
16 CHARACTER SET WE8ISO8859P1;
CREATE CONTROLFILE SET DATABASE "fclone" RESETLOGS FORCE LOGGING NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 12800 (blocks), but should match header 74112
ORA-01110: data file 2: 'C:\app\Indra\oradata\fclone\sysaux01.dbf'
SQL>
Regard,
Indra
|
|
|
|
|
|
|
|
|
|
| Re: Database Cold Cloning [message #581982 is a reply to message #581920] |
Fri, 12 April 2013 07:09  |
|
Indra Parmar
Messages: 6
Registered: March 2013
Location: Surat
|
Junior Member |
|
|
Dear Humayunarshad,
The problem was about the size of Redo log that i have not specified.
And you are right too there was also problem with comma i have given at your highlighted part.
As michel suggested i have solved the problem.
Here is my controlfile.
CREATE CONTROLFILE SET DATABASE "fclone" RESETLOGS FORCE LOGGING NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 10
MAXINSTANCES 1
MAXLOGHISTORY 400
LOGFILE
GROUP 1 'C:\app\Indra\oradata\fclone\REDO01.log' SIZE 51M,
GROUP 2 'C:\app\Indra\oradata\fclone\REDO02.log' SIZE 51M,
GROUP 3 'C:\app\Indra\oradata\fclone\REDO03.log' SIZE 51M
DATAFILE
'C:\app\Indra\oradata\fclone\system01.dbf',
'C:\app\Indra\oradata\fclone\undotbs01.dbf',
'C:\app\Indra\oradata\fclone\users01.dbf',
'C:\app\Indra\oradata\fclone\sysaux01.dbf'
CHARACTER SET WE8ISO8859P1;
Control file created.
SQL>
SQL> alter database open resetlogs;
Database altered.
SQL>
SQL>
Regards,
Indra
[Updated on: Fri, 12 April 2013 07:22] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
