Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01180: can not create datafile

556637Mar 25 2008 — edited Apr 11 2008
I created a standby database using RMAN backup file.

1. backup primary database and create standby control file
RMAN> run
{
allocate channel c1 type disk;
backup database format '/u01/app/oracle/admin/confgdb/db_%u_%d_%s';
backup format '/u01/app/oracle/admin/confgdb/log_t%t_s%s_p%p' (archivelog all);
}

SQL> alter database create standby controlfile as '/u01/app/oracle/admin/confgdb/control01.dbf';

2. Get thest file from primary database server via sftp command.

3. copy init file from primary database to standby database. Add following:
standby_file_management=auto
fal_server='DBPRIMARY'
fal_client='DBSTANDBY'

4. startup standby database
SQL> startup nomount pfile='/u01/app/oracle/admin/confgdb/initconfgdb.ora';
SQL> alter database mount standby database;

5. connect mounted standby database and start to restore backup file
$ $ORACLE_HOME/bin/rman target /
RMAN> restore database;

Starting restore at 26-MAR-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=83 devtype=DISK

creating datafile fno=1 name=/u01/app/oracle/admin/confgdb/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/26/2008 08:40:40
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/u01/app/oracle/admin/confgdb/system01.dbf'


I checked directory
ls -l /u01/app/oracle/admin/confgdb
total 337768
drwxr-xr-x 2 oracle oinstall 4096 Mar 26 08:40 adump
drwxr-xr-x 2 oracle oinstall 4096 Mar 26 08:38 archive
drwxr-xr-x 2 oracle oinstall 4096 Mar 26 08:45 bdump
drwxr-xr-x 2 oracle oinstall 4096 Mar 26 08:38 cdump
-rw-r----- 1 oracle oinstall 6209536 Mar 26 09:51 control01.dbf
-rw-r----- 1 oracle oinstall 333012992 Mar 25 16:58 db_01jc4ohg_CONFGDB_1
-rw-r----- 1 oracle oinstall 6258688 Mar 25 17:01 db_02jc4oia_CONFGDB_2
-rwxr-xr-x 1 oracle oinstall 9353 Mar 26 08:32 initconfgdb.ora
drwxr-xr-x 2 oracle oinstall 4096 Mar 26 08:38 recover
drwxr-xr-x 2 oracle oinstall 4096 Mar 26 08:40 udump

I do not know the root cause and how to resolve it.

Can you help me to find the root cause?

-Doris
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2008
Added on Mar 25 2008
12 comments
5,278 views