Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


ORA-01180:


Hi,  For my practice doing incomplete recovery..But i was stuck with ORA-01180:  Steps i followed:-  1.Taken full backup with rman including archivelog. 2.script used to do recovery is   RMAN> run { 2> set until sequence 15;  ( my current sequence number is 17 upto 15 i have backup) 3> restore database; 4> recover database; 5> }  but i execute this script getting the following error   creating datafile file number=1 name=/u01/app/oracle/product/11.2.0/db_1/dbs/TEST/system01.dbf RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 09/28/2012 22:20:43 ORA-01180: can not create datafile 1 ORA-01110: data file 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/TEST/system01.dbf'  Please advice.

Ayyapan wrote: Hi,  For my practice doing incomplete recovery..But i was stuck with ORA-01180:  Steps i followed:-  1.Taken full backup with rman including archivelog. 2.script used to do recovery is   RMAN> run { 2> set until sequence 15;  ( my current sequence number is 17 upto 15 i have backup) 3> restore database; 4> recover database; 5> }   but i execute this script getting the following error   creating datafile file number=1 name=/u01/app/oracle/product/11.2.0/db_1/dbs/TEST/system01.dbf RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 09/28/2012 22:20:43 ORA-01180: can not create datafile 1 ORA-01110: data file 1: '/u01/app/oracle/product/11.2.0/db_1/dbs/TEST/system01.dbf'  Please advice.  does OS user have necessary OS file permission to create the file?

drwxrwxr-x 2 oracle oracle    4096 Sep 28 22:29 TEST

oracle user have necessary privilege

when i try to do a complete restore its working fine.

Its restoring into $ORACLE_HOME/dbs folder, do you have space in ORACLE_HOME?

Yes have enough space.

Where your backups are stored? On to disk? If on Disk, those backups are accessible? Try CATALOG START WITH '<backup location>' and then restore command  Edited by: vreddy on Sep 28, 2012 11:29 AM


Related Links

Table not visible in the database IDE, but exists when checked from DOS prm
Getting error by using expdp with table partitions
Oracle Database Sessions
A fundamental question on .profile file and ORACLE env variables
10G control file loss
Rman is running a long time
please give command for table import
Not able to open EDITOR
Dynamic Index Disable
DBMS RDBMS
Error while rebuilding index
spauto.sql
How to Remove Foreign Key Constraint
DBMS_STATS and GATHER_STATS_JOB
Migrating the DB from Linux to Solaris
Enforcing validation in the database