SOLVED

ORA-01180

Asked by OracleDba••12 views•oracle
1
2
3
ORA-01180

ORA-01180: can not create datafile 1 ORA-01110 RMAN-03002
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
1:

Reset database to previous incarnation as follows :

RMAN> list incarnation of database;

SQL> select INCARNATION#, RESETLOGS_TIME from v$database_incarnation order by RESETLOGS_TIME desc;

Then reset database incarnation like following.

RMAN> reset database to incarnation 1;

using target database control file instead of recovery catalog

database reset to incarnation 1

RMAN>

After reset operation, list incarnation again, it will change.

RMAN> list incarnation of database;

Solution 2 :

Reset FRA parameters and set log_archive_dest_1 parameters like following.

SQL> alter system reset db_recovery_file_dest scope=both;

SQL> alter system reset db_recovery_file_dest_size scope=both;

SQL> alter system set log_archive_dest_1='location=/u01/recovery_area'  scope=both;

Hope it Helps !
OracleDba•

Post Your Solution