{1 - 24} GreyGrey
{25 - 49} GreenGreen
{50 - 499} BlueBlue
{500 - 4999} OrangeOrange
{5000 - 24999} RedRed
{25000+} BlackBlack

Please confirm that you would like to report this for an admin to review.


Oracle: ORA-01180: can not create datafile 1 during RMAN restore.

Oracle Consultant needs help regarding

“ORA-01180: can not create datafile 1 during RMAN restore.”





Hello,
I am trying to refresh one of our QA environments and I am getting this error message:

RMAN> run
2> {
3> allocate channel c1 device type disk;
4> allocate channel c2 device type disk;
5> restore database;
6> recover database;
7> }
 
allocated channel: c1
channel c1: SID=5 device type=DISK
 
allocated channel: c2
channel c2: SID=131 device type=DISK
 
Starting restore at 08-NOV-12
using channel ORA_DISK_1
 
creating datafile file number=1 name=+DATA1/alephpr/datafile/system.269.722874729
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/08/2012 16:27:40
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '+DATA1/alephpr/datafile/system.269.722874729'

I created a new database from scratch with the same name as is in Production, later on I will proceed to rename it to the right one. I started the steps for refreshing the PRD copy:

RMAN> shutdown immediate
 
using target database control file instead of recovery catalog
database dismounted
Oracle instance shut down
 
RMAN> startup nomount
 
connected to target database (not started)
Oracle instance started
 
Total System Global Area 534462464 bytes
 
Fixed Size 2228200 bytes
Variable Size 176160792 bytes
Database Buffers 348127232 bytes
Redo Buffers 7946240 bytes
 
RMAN> set dbid=3573460394
 
executing command: SET DBID
 
RMAN> restore controlfile from '/restorealeph/c-3573460394-20121106-01';
 
Starting restore at 08-NOV-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK
 
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
+output file name=+DATA1/alephpr/controlfile/current.260.798747585+
+output file name=+FLASH/alephpr/controlfile/current.276.798747585+
Finished restore at 08-NOV-12
 
RMAN> alter database mount;
 
database mounted
released channel: ORA_DISK_1

Once the control file is restored, I need to crosscheck, delete expired and catalog the backups at the new server:

RMAN> crosscheck backup;
 
...
Crosschecked 48 objects
 
RMAN> delete noprompt expired backup;
...
Deleted 48 EXPIRED objects
 
RMAN> list backup summary;
 
specification does not match any backup in the repository

I need now to catalog the backups we transferred from Prod into the QA server’s directory /restorealeph:

RMAN> catalog start with '/restorealeph/';
 
searching for all files that match the pattern /restorealeph/ 
 
List of Files Unknown to the Database
=====================================
File Name: /restorealeph/9cnpm51u_1_1
File Name: /restorealeph/9enpm6lj_1_1
File Name: /restorealeph/c-3573460394-20121107-00
File Name: /restorealeph/c-3573460394-20121107-01
File Name: /restorealeph/c-3573460394-20121106-01
 
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
 
List of Cataloged Files
=======================
File Name: /restorealeph/9cnpm51u_1_1
File Name: /restorealeph/9enpm6lj_1_1
File Name: /restorealeph/c-3573460394-20121107-00
File Name: /restorealeph/c-3573460394-20121107-01
File Name: /restorealeph/c-3573460394-20121106-01
 
RMAN> list backup summary;
 
 
List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
4097    B  F  A DISK        07-NOV-12       1       1       NO         BACKUP_ALEPHPR.TUR_110712030000
4098    B  A  A DISK        07-NOV-12       1       1       NO         BACKUP_ALEPHPR.TUR_110712030000
 
RMAN> list backup tag="BACKUP_ALEPHPR.TUR_110712030000";
 
 
List of Backup Sets
===================
 
 
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4097    Full    178.04G    DISK        00:00:00     07-NOV-12
        BP Key: 4097   Status: AVAILABLE  Compressed: NO  Tag: BACKUP_ALEPHPR.TUR_110712030000
        Piece Name: /restorealeph/9cnpm51u_1_1
  List of Datafiles in backup set 4097
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/system.269.722874729
  2       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/sysaux.266.722874731
  3       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs1.289.722874727
  4       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs2.257.722874727
  5       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/users.298.722874731
  6       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/audit.299.723372305
  7       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/case_datos.260.723372307
  8       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/case_indices.261.723372307
  9       Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_hist.262.723372309
  10      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_l.264.723372319
  11      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_long.265.723372349
  12      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_md.270.723372355
  13      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_sm.271.723372369
  14      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_xl.272.723372375
  15      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_l.273.723372401
  16      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_md.274.723372427
  17      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_sm.275.723372455
  18      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/index_xl.276.723372473
  19      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/tools.278.723372501
  26      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/data_sm.300.736088959
  27      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/dev_disco_ptm5_meta.301.746385117
  28      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/dev_disco_pstore.302.746385119
  29      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/dev_disco_ptm5_cache.304.746385121
  30      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs1.305.796391931
  31      Full 6919879655786 07-NOV-12 +DATA1/alephpr/datafile/undotbs2.306.796392185
 
BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4098    16.89G     DISK        00:00:00     07-NOV-12
        BP Key: 4098   Status: AVAILABLE  Compressed: NO  Tag: BACKUP_ALEPHPR.TUR_110712030000
        Piece Name: /restorealeph/9enpm6lj_1_1
 
  List of Archived Logs in backup set 4098
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    35722   6919870864350 06-NOV-12 6919871887697 06-NOV-12
  1    35723   6919871887697 06-NOV-12 6919872372211 06-NOV-12
  1    35724   6919872372211 06-NOV-12 6919872410158 06-NOV-12
  1    35725   6919872410158 06-NOV-12 6919872447301 06-NOV-12
  1    35726   6919872447301 06-NOV-12 6919872503332 06-NOV-12
  1    35727   6919872503332 06-NOV-12 6919872551564 06-NOV-12
  1    35728   6919872551564 06-NOV-12 6919872603881 06-NOV-12
  1    35729   6919872603881 06-NOV-12 6919872655942 06-NOV-12
  1    35730   6919872655942 06-NOV-12 6919872698722 06-NOV-12
  1    35731   6919872698722 06-NOV-12 6919872741655 06-NOV-12
  1    35732   6919872741655 06-NOV-12 6919872782284 06-NOV-12
  1    35733   6919872782284 06-NOV-12 6919872872302 06-NOV-12
  1    35734   6919872872302 06-NOV-12 6919872910206 06-NOV-12
  1    35735   6919872910206 06-NOV-12 6919872945577 06-NOV-12
  1    35736   6919872945577 06-NOV-12 6919872980056 06-NOV-12
  1    35737   6919872980056 06-NOV-12 6919873013411 06-NOV-12
  1    35738   6919873013411 06-NOV-12 6919873050761 06-NOV-12
  1    35739   6919873050761 06-NOV-12 6919873084996 06-NOV-12
  1    35740   6919873084996 06-NOV-12 6919873122049 06-NOV-12
  1    35741   6919873122049 06-NOV-12 6919873521767 06-NOV-12
  1    35742   6919873521767 06-NOV-12 6919873952773 06-NOV-12
  1    35743   6919873952773 06-NOV-12 6919874258549 06-NOV-12
  1    35744   6919874258549 06-NOV-12 6919874472213 06-NOV-12
  1    35745   6919874472213 06-NOV-12 6919874744856 06-NOV-12
  1    35746   6919874744856 06-NOV-12 6919875113086 06-NOV-12
  1    35747   6919875113086 06-NOV-12 6919875733337 06-NOV-12
  1    35748   6919875733337 06-NOV-12 6919876139061 06-NOV-12
  1    35749   6919876139061 06-NOV-12 6919876707162 06-NOV-12
  1    35750   6919876707162 06-NOV-12 6919877706313 06-NOV-12
  1    35751   6919877706313 06-NOV-12 6919877919039 06-NOV-12
  1    35752   6919877919039 06-NOV-12 6919878024429 06-NOV-12
  1    35753   6919878024429 06-NOV-12 6919878107673 06-NOV-12
  1    35754   6919878107673 06-NOV-12 6919878258511 06-NOV-12
  1    35755   6919878258511 06-NOV-12 6919878308336 06-NOV-12
  1    35756   6919878308336 06-NOV-12 6919878424419 06-NOV-12
  1    35757   6919878424419 06-NOV-12 6919878488485 06-NOV-12
  1    35758   6919878488485 06-NOV-12 6919878827092 06-NOV-12
  1    35759   6919878827092 06-NOV-12 6919879350098 07-NOV-12
  1    35760   6919879350098 07-NOV-12 6919879675556 07-NOV-12
  2    35949   6919870864360 06-NOV-12 6919871494640 06-NOV-12
  2    35950   6919871494640 06-NOV-12 6919871887487 06-NOV-12
  2    35951   6919871887487 06-NOV-12 6919872410655 06-NOV-12
  2    35952   6919872410655 06-NOV-12 6919872552468 06-NOV-12
  2    35953   6919872552468 06-NOV-12 6919872698940 06-NOV-12
  2    35954   6919872698940 06-NOV-12 6919872872690 06-NOV-12
  2    35955   6919872872690 06-NOV-12 6919872980371 06-NOV-12
  2    35956   6919872980371 06-NOV-12 6919873085902 06-NOV-12
  2    35957   6919873085902 06-NOV-12 6919873569082 06-NOV-12
  2    35958   6919873569082 06-NOV-12 6919873949096 06-NOV-12
  2    35959   6919873949096 06-NOV-12 6919874404640 06-NOV-12
  2    35960   6919874404640 06-NOV-12 6919875011814 06-NOV-12
  2    35961   6919875011814 06-NOV-12 6919875631429 06-NOV-12
  2    35962   6919875631429 06-NOV-12 6919876324885 06-NOV-12
  2    35963   6919876324885 06-NOV-12 6919876363526 06-NOV-12
  2    35964   6919876363526 06-NOV-12 6919876748508 06-NOV-12
  2    35965   6919876748508 06-NOV-12 6919877741784 06-NOV-12
  2    35966   6919877741784 06-NOV-12 6919878108943 06-NOV-12
  2    35967   6919878108943 06-NOV-12 6919878424477 06-NOV-12
  2    35968   6919878424477 06-NOV-12 6919879012111 06-NOV-12
  2    35969   6919879012111 06-NOV-12 6919879260589 07-NOV-12
  2    35970   6919879260589 07-NOV-12 6919879350086 07-NOV-12
  2    35971   6919879350086 07-NOV-12 6919879464935 07-NOV-12
  2    35972   6919879464935 07-NOV-12 6919879548399 07-NOV-12
  2    35973   6919879548399 07-NOV-12 6919879675564 07-NOV-12
 
  
RMAN> list incarnation;
 
 
List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ALEPHPR  3573460394       PARENT  1          13-MAY-10
2       2       ALEPHPR  3573460394       PARENT  2229467    28-JUN-10
3       3       ALEPHPR  3573460394       CURRENT 6918261828355 26-SEP-12

The ASM structure is created…

ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 509282 507421 0 507421 0 N DATA1/ 
MOUNTED EXTERN N 512 4096 1048576 50641 42850 0 42850 0 N FLASH/ 
ASMCMD> cd DATA1/ALEPHPR/DATAFILE
ASMCMD> pwd
+DATA1/ALEPHPR/DATAFILE

Both source and target databases are 11.2.0.2 PSU 6 running on Linux x64. I cannot use RMAN Duplicate since there is no visibility among different environments (PROD – QA in this case).

Any idea?

Thanks

Martin

Edited by: martin.morono on Nov 8, 2012 11:19 AM

Edited by: martin.morono on Nov 8, 2012 11:49 AM


What do you suggest for

ORA-01180: can not create datafile 1 during RMAN restore.

Kindly answer!

Oracle Discussion Forums : Thread List – Oracle Database



Confirm that you would like to Remove Email Alerts for your question. You cant undo this and you will not be able to re-subscribe.


Tags

No Answers

You must be Logged In to Answer this Question

Already a Member, Log In
Not a member yet? Sign Up

Categories

Sponsors


oracle forum