Home » RDBMS Server » Server Administration » Database Cold Cloning (Oracle11g,)
Database Cold Cloning [message #581388] Fri, 05 April 2013 04:20 Go to next message
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 #581401 is a reply to message #581388] Fri, 05 April 2013 07:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Specify the size of your datafiles as they actually are:
'C:\app\Indra\oradata\fclone\sysaux01.dbf' size <74112*your_database_block_size>

Regards
Michel

[Updated on: Fri, 05 April 2013 11:25]

Report message to a moderator

Re: Database Cold Cloning [message #581407 is a reply to message #581401] Fri, 05 April 2013 11:19 Go to previous messageGo to next message
Indra Parmar
Messages: 6
Registered: March 2013
Location: Surat
Junior Member
Thanks michel.


Regards,
Indra
Re: Database Cold Cloning [message #581920 is a reply to message #581388] Thu, 11 April 2013 16:10 Go to previous messageGo to next message
humayunarshad
Messages: 1
Registered: April 2013
Junior Member
Hi,

The problem should be with the comma after the sysaux datafile clause. please check and let me know if i am wrong.

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;

Re: Database Cold Cloning [message #581982 is a reply to message #581920] Fri, 12 April 2013 07:09 Go to previous message
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

Previous Topic: Grid control installation
Next Topic: deprecated parameter not in spfile and cannot reset in memory
Goto Forum:
  


Current Time: Thu Mar 28 16:13:40 CDT 2024