We value your privacy

We use cookies to enhance your browsing experience, serve personalised content, and analyse our traffic. By clicking "Accept All", you consent to our use of cookies.

Customise Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorised as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyse the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customised advertisements based on the pages you visited previously and to analyse the effectiveness of the ad campaigns.

No cookies to display.

  Master in Data Analyst | Batch Starting from 10 March 2025 | Register for Free Demo

Know More

Miss to give + Symbol in ASM while adding Datafile in Tablespace

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 20 Jun, 2021
  • 0 Comments
  • 4 Mins Read

Miss to give + Symbol in ASM while adding Datafile in Tablespace

MISS TO GIVE "+" SYMBOL IN ASM WHILE ADDING DATAFILE IN TABLESPACE

1
2
3
4
5
6
7
ORA-01157: cannot identify/lock data file 3130 - see DBWR trace file
ORA-01110: data file 3130: '/data/oracle/product/11.2.0/db/dbs/DATA'
ORA-27037: unable to obtain file status
ORA-01186: file 3130 failed verification tests
ORA-01157: cannot identify/lock data file 3130 - see DBWR trace file
ORA-01110: data file 3130: '/data/oracle/product/11.2.0/db/dbs/DATA'
File 3130 not verified due to error ORA-01157
Solution 1. Find out the data file number( It is available in the alert log) 2. use the rman to copy the data to ASM disk group. 3. offline the data file 4. copy the data file to the ASM disk group 5. switch the data file from old name to new COPY file 6. Recover the new data file 7. make data file on line.
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
-bash-3.00$ rman target /
 
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Dec 10 12:10:21 2009
 
Copyright (c) 1982, 2005, Oracle. All rights reserved.
 
connected to target database: (DBID=732088347)
 
RMAN> sql 'alter database datafile 3130 offline';
 
using target database control file instead of recovery catalog
sql statement: alter database datafile 3130 offline
 
RMAN> copy datafile '/data/oracle/product/11.2.0/db/dbs/DATA' to '+DATA';
 
Starting backup at 10-DEC-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=2179 instance= devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=2125 instance= devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=2139 instance= devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=2057 instance= devtype=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: sid=2101 instance= devtype=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: sid=2121 instance= devtype=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: sid=2122 instance= devtype=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: sid=2124 instance= devtype=DISK
allocated channel: ORA_DISK_9
channel ORA_DISK_9: sid=2108 instance= devtype=DISK
allocated channel: ORA_DISK_10
channel ORA_DISK_10: sid=2149 instance= devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=03130 name=/data/oracle/product/11.2.0/db/dbs/DATA
output filename=+DATA/datafile/ymedia_cookie_tdata_200907.4732.705240801 tag=TAG20091210T121321 recid=5381 stamp=705240808
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 10-DEC-09
 
Starting Control File and SPFILE Autobackup at 10-DEC-09
piece handle=/data/oracle/product/11.2.0/db/dbs/c-832088347-10091210-04 comment=NONE
Finished Control File and SPFILE Autobackup at 10-DEC-09
 
RMAN> switch datafile '/data/oracle/product/11.2.0/db/dbs/DATA' TO COPY;
 
datafile 3130 switched to datafile copy "+DATA/datafile/ymedia_cookie_tdata_200907.4732.705240801"
 
RMAN> recover datafile '+DATA/datafile/ymedia_cookie_tdata_200907.4732.705240801';
 
Starting recover at 20-DEC-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=2056 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: sid=2111 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_2: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: sid=2085 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_3: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: sid=2113 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_4: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: sid=2091 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_5: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: sid=2129 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_6: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: sid=2116 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_7: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: sid=2150 instance=devtype=SBT_TAPE
channel ORA_SBT_TAPE_8: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_9
channel ORA_SBT_TAPE_9: sid=2133 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_9: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_10
channel ORA_SBT_TAPE_10: sid=2134 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_10: NetVault Oracle APM v.5.5.11
 
starting media recovery
media recovery complete, elapsed time: 00:00:00
 
Finished recover at 10-DEC-09
channel ORA_SBT_TAPE_1: sid=2056 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: sid=2111 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_2: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: sid=2085 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_3: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: sid=2113 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_4: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: sid=2091 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_5: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: sid=2129 instance= devtype=SBT_TAPE
channel ORA_SBT_TAPE_6: NetVault Oracle APM v.5.5.11
allocated channel: ORA_SBT_TAPE_7
 
starting media recovery
media recovery complete, elapsed time: 00:00:00
 
Finished recover at 10-DEC-21
 
RMAN> sql 'alter database datafile 3130 online';
 
sql statement: alter database datafile 3130 online
 
RMAN> quit
Upgrade 12.2.0.1 to 19c Oracle Database Manually
Unplug and Plug Pluggable Database