DBA Hub

📋Steps in this guide1/1

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

MISS TO GIVE "+" SYMBOL IN ASM WHILE ADDING DATAFILE IN TABLESPACE ORA-01157: cannot identify/lock data file 3130 - see DBWR trace file ORA-01110: data file

oracle configurationintermediate
by OracleDba
13 views
1

Overview

Code/Command (click line numbers to comment):

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
130
131
132
133
134
135
136
137
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

-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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!