No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

failed to create file system01.dbf
Next thread: Sysdba tables
Prev thread: Monitor user access

Message Score Author Date
Hi OK this days be patient with me i am confi...... john smith Jul 03, 2011, 10:12
Hi, Did you backup the test database and shifted ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Yasir Hashmi Jul 03, 2011, 10:39
Thanks Yassir i fixed by change the db_name to ...... john smith Jul 03, 2011, 19:23
Have you checked if directory 'C:\ORACLE\PRODUCT\1...... Johan Lorier Jul 04, 2011, 12:22

Follow up by mail Click here


Subject: failed to create file system01.dbf
Author: john smith, Sudan
Date: Jul 03, 2011, 10:12, 3252 days ago
Os info: Winx Pro
Oracle info: ora 10g
Message: Hi
OK this days be patient with me

i am configuring duplicate database on both server
server1 : test
server2:test1
both listener,tnsnames.ora well configured

the duplicate DB "test1" start with pfile.ora on nomount state

pfiletest1 :
db_name= test1
*.control_files='C:\oracle\product\10.1.0\oradata\test1\control01.ctl','C:\oracle\product\10.1.0\oradata\test1\control02.ctl','C:\oracle\product\10.1.0\oradata\test1\control03.ctl'
*.remote_login_passwordfile='EXCLUSIVE'
*.compatible=10.1.0.2.0
*.db_block_size=8192
*.db_cache_size=25165824
*.db_file_multiblock_read_count=16
*.db_recovery_file_dest_size=2147483648
*.java_pool_size=50331648
*.job_queue_processes=10
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=25165824
*.shared_pool_size=83886080
*.sort_area_size=65536
*.db_file_name_convert=('C:\oracle\product\10.1.0\oradata\TEST1','C:\oracle\product\10.1.0\oradata\TEST')
*.log_file_name_convert=('C:\oracle\product\10.1.0\oradata\TEST1','C:\oracle\product\10.1.0\oradata\TEST')



RMAN> connect target sys@test

target database Password:
connected to target database: TEST (DBID=2053352277)

RMAN> connect auxiliary sys@test1

auxiliary database Password:
connected to auxiliary database: test1 (not mounted)

RMAN> duplicate target database to "test" nofilenamecheck;

Starting Duplicate Db at 03/07/11
using target database controlfile instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=27 devtype=DISK

contents of Memory Script:
{
set until scn 473349;
set newname for datafile 1 to
"C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\SYSTEM01.DBF";
set newname for datafile 2 to
"C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\UNDOTBS01.DBF";
set newname for datafile 3 to
"C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\SYSAUX01.DBF";
set newname for datafile 4 to
"C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\USERS01.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

executing command: SET NEWNAME

Starting restore at 03/07/11
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\SYSAUX01.DBF
restoring datafile 00004 to C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\USERS01.DBF
ORA-19624: operation failed, retry possible
ORA-19504: failed to create file "C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\SYSTEM01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/03/2011 10:40:12
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

But every time i run the duplicate commmand
> duplicate target database to "test1" nofilenamecheck;

give the above errors

Regards
J.smith
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: failed to create file system01.dbf
Author: Yasir Hashmi, India
Date: Jul 03, 2011, 10:39, 3252 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,
Did you backup the test database and shifted the backup sets to test1 and catalog them ?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: failed to create file system01.dbf
Author: john smith, Sudan
Date: Jul 03, 2011, 19:23, 3252 days ago
Message: Thanks Yassir
i fixed by change the db_name
to "test" instead of "test1"
Regards
j.smith
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: failed to create file system01.dbf
Author: Johan Lorier, Netherlands
Date: Jul 04, 2011, 12:22, 3251 days ago
Message: Have you checked if directory 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST\' does exist, and does it have the right permissions?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here