ORA-01180: can not create datafile 1 ORA-01110: data file 1

-هنگامی که می خواهیم  با ابزار RMAN اوراکل ریکاوری انجام دهیم و با خطای زیر مواجه می شویم :

-When you try to recover database with rman but you get this error:

ORA-01180: can not create datafile 1 ORA-01110: data file 1

RMAN> run{

2> set until sequence=72;

3> restore database;

4> recover database;

5> }

executing command: SET until clause

Starting restore at 30-MAY-16

using channel ORA_DISK_1

creating datafile file number=1 name=+DATA/primary/datafile/system.258.903950969

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 05/30/2016 10:02:09

ORA-01180: can not create datafile 1

ORA-01110: data file 1: ‘+DATA/primary/datafile/system.258.903950969’

-زمانی که با این مشکل با Rman برخورد میکنید مشکل ازینجاست که شما بک آپ level 0 ندارین و می بایست بک آپ level 0  تهیه کرده باشین از قبل تا بتوانید ریکاوری را انجام دهید:

-for solve this problem you most have a backup as level 0 with rman to do recovery:

RMAN> run {

backup as compressed backupset  format ‘/rman/backup/full_%d_%s_%p.bkf’

incremental level 0 database include current controlfile;

SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’; }

2> 3> 4>

Starting backup at 30-MAY-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=18 device type=DISK

channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00005 name=+DATA/primary/datafile/test.270.912865915

input datafile file number=00001 name=+DATA/primary/datafile/system.258.903950969

input datafile file number=00002 name=+DATA/primary/datafile/sysaux.257.903950991

input datafile file number=00003 name=+DATA/primary/datafile/undotbs1.264.903951013

input datafile file number=00004 name=+DATA/primary/datafile/users.261.903951027

channel ORA_DISK_1: starting piece 1 at 30-MAY-16

channel ORA_DISK_1: finished piece 1 at 30-MAY-16

piece handle=/rman/backup/full_ORCL_6_1.bkf tag=TAG20160530T102717 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45

channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 30-MAY-16

channel ORA_DISK_1: finished piece 1 at 30-MAY-16

piece handle=/rman/backup/full_ORCL_7_1.bkf tag=TAG20160530T102717 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 30-MAY-16

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

همانطور که می بینید بک آپ level 0 ما تهیه شد حال می توانید اگر نیاز به ریکاوری بود با ابزار RMAN این کار را انجام دهید:

-Now you can recover database  when you need to recover database;

RMAN> run {

2> set until sequence=77;

3> restore database;

4> recover database;

5> }

executing command: SET until clause

Starting restore at 30-MAY-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=95 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to +DATA/primary/datafile/system.258.903950969

channel ORA_DISK_1: restoring datafile 00002 to +DATA/primary/datafile/sysaux.257.903950991

channel ORA_DISK_1: restoring datafile 00003 to +DATA/primary/datafile/undotbs1.264.903951013

channel ORA_DISK_1: restoring datafile 00004 to +DATA/primary/datafile/users.261.903951027

channel ORA_DISK_1: restoring datafile 00005 to +DATA/primary/datafile/test.270.912865915

channel ORA_DISK_1: reading from backup piece /rman/backup/full_ORCL_6_1.bkf

channel ORA_DISK_1: piece handle=/rman/backup/full_ORCL_6_1.bkf tag=TAG20160530T102717

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:02:05

Finished restore at 30-MAY-16

Starting recover at 30-MAY-16

using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 74 is already on disk as file /rman/archive/archive_74_1.903950954

archived log for thread 1 with sequence 75 is already on disk as file /rman/archive/archive_75_1.903950954

archived log for thread 1 with sequence 76 is already on disk as file /rman/archive/archive_76_1.903950954

archived log file name=/rman/archive/archive_74_1.903950954 thread=1 sequence=74

archived log file name=/rman/archive/archive_75_1.903950954 thread=1 sequence=75

archived log file name=/rman/archive/archive_76_1.903950954 thread=1 sequence=76

media recovery complete, elapsed time: 00:00:01

Finished recover at 30-MAY-16

با احترام

محسن صفابخش

Mohsen Safabakhsh

2 thoughts on “ORA-01180: can not create datafile 1 ORA-01110: data file 1

دیدگاهتان را بنویسید

نشانی ایمیل شما منتشر نخواهد شد. بخش‌های موردنیاز علامت‌گذاری شده‌اند *