| Computers Forum Index » Computer - Databases - Oracle (Server) » RMAN freeze when duplicate db... |
|
Page 1 of 1 |
|
| Author |
Message |
| bob123... |
 Posted: Sun Nov 01, 2009 4:03 pm |
|
|
|
Guest
|
Hi,
I try to duplicate a database (10.2.0.3)
with RMAN, the script freeze at the end of the duplication (executing Memory
Script)
Any clue ?
Thanks in advance
The output below:
RMAN> run
2> {
3> allocate auxiliary channel c1 type disk;
4> set until time '22/10/2009 13:00';
5> set newname for datafile 'D:\DATA\ORACLE\T3O\T3O_SYSTEM01.DBF' to
'D:\DATA\OR
ACLE\T3OB\T3OB_SYSTEM01.DBF';
6> set newname for datafile 'D:\DATA\ORACLE\T3O\T3O_UNDO01.DBF' to
'D:\DATA\ORAC
LE\T3OB\T3OB_UNDO01.DBF';
7> set newname for datafile 'D:\DATA\ORACLE\T3O\T3O_SYSAUX01.DBF' to
'D:\DATA\OR
ACLE\T3OB\T3OB_SYSAUX01.DBF';
8> duplicate target database to 'CBDT3OB'
9> logfile group 1 ('D:\DATA\ORACLE\T3OB\T3OB_LOG01.RDO') size 512000,
10> group 2 ('D:\DATA\ORACLE\T3OB\T3OB_LOG02.RDO') size 512000;
11> }
released channel: ORA_AUX_DISK_1
allocated channel: c1
channel c1: sid=320 devtype=DISK
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting Duplicate Db at 22/10/2009 15:17
contents of Memory Script:
{
set until scn 320030;
set newname for datafile 1 to
"D:\DATA\ORACLE\T3OB\T3OB_SYSTEM01.DBF";
set newname for datafile 2 to
"D:\DATA\ORACLE\T3OB\T3OB_UNDO01.DBF";
set newname for datafile 3 to
"D:\DATA\ORACLE\T3OB\T3OB_SYSAUX01.DBF";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 22/10/2009 15:17
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\DATA\ORACLE\T3OB\T3OB_SYSTEM01.DBF
restoring datafile 00002 to D:\DATA\ORACLE\T3OB\T3OB_UNDO01.DBF
restoring datafile 00003 to D:\DATA\ORACLE\T3OB\T3OB_SYSAUX01.DBF
channel c1: reading from backup piece
D:\DATA\ORACLE\T3O\SAUVE\BK_CBDT3O_23_7009
18980
channel c1: restored backup piece 1
piece handle=D:\DATA\ORACLE\T3O\SAUVE\BK_CBDT3O_23_700918980
tag=TAG20091022T114
300
channel c1: restore complete, elapsed time: 00:00:08
Finished restore at 22/10/2009 15:17
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CBDT3OB" RESETLOGS
ARCHIVE
LOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1752
LOGFILE
GROUP 1 ( 'D:\DATA\ORACLE\T3OB\T3OB_LOG01.RDO' ) SIZE 512000 ,
GROUP 2 ( 'D:\DATA\ORACLE\T3OB\T3OB_LOG02.RDO' ) SIZE 512000
DATAFILE
'D:\DATA\ORACLE\T3OB\T3OB_SYSTEM01.DBF'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=700931875
filename=D:\DATA\ORACLE\T3OB\T3OB_UN
DO01.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=700931875
filename=D:\DATA\ORACLE\T3OB\T3OB_SY
SAUX01.DBF
contents of Memory Script:
{
set until time "22/10/2009 13:00";
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 22/10/2009 15:17
starting media recovery
archive log thread 1 sequence 4 is already on disk as file
D:\DATA\ORACLE\T3O\AR
CHIVE\T3O_1_700673596_4.ARC
archive log filename=D:\DATA\ORACLE\T3O\ARCHIVE\T3O_1_700673596_4.ARC
thread=1 s
equence=4
media recovery complete, elapsed time: 00:00:01
Finished recover at 22/10/2009 15:17
contents of Memory Script:
{
shutdown clone;
startup clone nomount ;
}
executing Memory Script |
|
|
| Back to top |
|
|
|
| gazzag... |
| Posted: Mon Nov 02, 2009 11:16 am |
|
|
|
Guest
|
On 1 Nov, 11:03, "bob123" <bob... at (no spam) gmail.com> wrote:
Quote: Hi,
I try to duplicate a database (10.2.0.3)
with RMAN, the script freeze at the end of the duplication (executing Memory
Script)
Any clue ?
Thanks in advance
<snip>
Quote: Finished recover at 22/10/2009 15:17
contents of Memory Script:
{
shutdown clone;
startup clone nomount ;}
executing Memory Script
I'm guessing that you have another session logged into the cloned
database which is preventing the "SHUTDOWN CLONE" command from
completing. Have you looked in the alert log?
HTH
-g |
|
|
| Back to top |
|
|
|
| bob123... |
| Posted: Wed Nov 04, 2009 1:31 am |
|
|
|
Guest
|
Quote: I'm guessing that you have another session logged into the cloned
dtabase which is preventing the "SHUTDOWN CLONE" command from
completing. Have you looked in the alert log?
Thanks very much
Your are right, now I have at end:
any help ?
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/03/2009 11:22:15
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-00336: log file size
1000
blocks is less than minimum 8192 blocks |
|
|
| Back to top |
|
|
|
| bob123... |
| Posted: Wed Nov 04, 2009 2:25 am |
|
|
|
Guest
|
Sorry
I think I can change my redolog size ...
I will try tomorow |
|
|
| Back to top |
|
|
|
|
