No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 9400
3 B. Vroman 4800
4 P. Wisse 4300
5 J. Schnackenberg 2900
6 J. PĂ©ran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48524
Total active users1409
Act. users last 24h3
Act. users last hour0
Registered user hits last week77
Registered user hits last month415
Go up

trouble during restore / switch datafile
Next thread: peformance issues
Prev thread: Your opinion regarding the autoupgrade new feature

Message Score Author Date
Hi, I just restored a big database. <pre>run { ...... Alain Bourgeois Jul 10, 2020, 16:56
But problem is that alert log shows lots of errors...... Alain Bourgeois Jul 10, 2020, 16:58

Follow up by mail Click here


Subject: trouble during restore / switch datafile
Author: Alain Bourgeois, Belgium
Date: Jul 10, 2020, 16:56, 28 days ago
Os info: linux 6
Oracle info: 12.2 oracle ee
Message: Hi,
I just restored a big database.
run {

set newname for tempfile 1 to '+DATAC';
set newname for tempfile 2 to '+DATAC';
set newname for tempfile 3 to '+DATAC';
set newname for datafile 1 to '+DATAC';
set newname for datafile 2 to '+DATAC';
set newname for datafile 3 to '+DATAC';
set newname for datafile 4 to '+DATAC';
set newname for datafile 5 to '+DATAC';
set newname for datafile 6 to '+DATAC';
set newname for datafile 8 to '+DATAC';
set newname for datafile 9 to '+DATAC';
set newname for datafile 10 to '+DATAC';
restore database;
SET UNTIL TIME "to_date('2020-04-21 09:50:00','YYYY-MM-DD HH24:MI:SS')";
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
}


On the screen no error:

...
channel ORA_DISK_8: restored backup piece 3
channel ORA_DISK_8: restore complete, elapsed time: 15:41:18
channel ORA_DISK_7: piece handle=/backup_db/cnamcs/rman/level0/base_8quu3ql7_4_1 tag=BACKUP_BASE_DB
channel ORA_DISK_7: restored backup piece 4
channel ORA_DISK_7: restore complete, elapsed time: 15:24:34
channel ORA_DISK_6: piece handle=/backup_db/cnamcs/rman/level0/base_8quu3ql7_5_1 tag=BACKUP_BASE_DB
channel ORA_DISK_6: restored backup piece 5
channel ORA_DISK_6: restore complete, elapsed time: 15:21:26
Finished restore at 10-JUL-20

executing command: SET until clause

datafile 1 switched to datafile copy
input datafile copy RECID=67 STAMP=1045392091 file name=+DATAC/CNAMCS/DATAFILE/system.260.1044384013
datafile 2 switched to datafile copy
input datafile copy RECID=68 STAMP=1045392092 file name=+DATAC/CNAMCS/DATAFILE/sysaux.259.1044383949
datafile 3 switched to datafile copy
input datafile copy RECID=69 STAMP=1045392092 file name=+DATAC/CNAMCS/DATAFILE/undotbs1.262.1044384045
datafile 4 switched to datafile copy
input datafile copy RECID=70 STAMP=1045392093 file name=+DATAC/CNAMCS/DATAFILE/users.261.1044384041
datafile 5 switched to datafile copy
input datafile copy RECID=71 STAMP=1045392093 file name=+DATAC/CNAMCS/DATAFILE/maintbs.257.1044383937
datafile 6 switched to datafile copy
input datafile copy RECID=72 STAMP=1045392093 file name=+DATAC/CNAMCS/DATAFILE/afistbs.258.1044383941
datafile 8 switched to datafile copy
input datafile copy RECID=73 STAMP=1045392094 file name=+DATAC/CNAMCS/DATAFILE/undotbs1.263.1044384051
datafile 9 switched to datafile copy
input datafile copy RECID=74 STAMP=1045392094 file name=+DATAC/CNAMCS/DATAFILE/undotbs1.264.1044384063
datafile 10 switched to datafile copy
input datafile copy RECID=75 STAMP=1045392095 file name=+DATAC/CNAMCS/DATAFILE/undotbs1.265.1044384065

renamed tempfile 1 to +DATAC in control file
renamed tempfile 2 to +DATAC in control file
renamed tempfile 3 to +DATAC in control file

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: trouble during restore / switch datafile
Author: Alain Bourgeois, Belgium
Date: Jul 10, 2020, 16:58, 28 days ago
Message: But problem is that alert log shows lots of errors AFTER restore:

But alert log shows error at the end (not during restore process, but during switch datafile all):

2020-07-10T10:41:29.267130+00:00
Errors in file /u01/app/oracle/diag/rdbms/cnamcs/cnamcs/trace/cnamcs_m000_130813.trc:
ORA-01110: data file 1: '+DATAC1/cnamcs/datafile/system.1682.898701259'
ORA-01565: error in identifying file '+DATAC1/cnamcs/datafile/system.1682.898701259'
ORA-17503: ksfdopn:2 Failed to open file +DATAC1/cnamcs/datafile/system.1682.898701259
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
2020-07-10T10:41:29.843047+00:00
Errors in file /u01/app/oracle/diag/rdbms/cnamcs/cnamcs/trace/cnamcs_m000_130813.trc:
ORA-01110: data file 2: '+DATAC1/cnamcs/datafile/sysaux.1689.898701259'
ORA-01565: error in identifying file '+DATAC1/cnamcs/datafile/sysaux.1689.898701259'
ORA-17503: ksfdopn:2 Failed to open file +DATAC1/cnamcs/datafile/sysaux.1689.898701259
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
2020-07-10T10:41:30.305287+00:00
Errors in file /u01/app/oracle/diag/rdbms/cnamcs/cnamcs/trace/cnamcs_m000_130813.trc:
ORA-01110: data file 3: '+DATAC1/cnamcs/datafile/undotbs1.1688.898701259'
ORA-01565: error in identifying file '+DATAC1/cnamcs/datafile/undotbs1.1688.898701259'
ORA-17503: ksfdopn:2 Failed to open file +DATAC1/cnamcs/datafile/undotbs1.1688.898701259
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
2020-07-10T10:41:30.855664+00:00
Errors in file /u01/app/oracle/diag/rdbms/cnamcs/cnamcs/trace/cnamcs_m000_130813.trc:
ORA-01110: data file 4: '+DATAC1/cnamcs/datafile/users.1683.898701259'
ORA-01565: error in identifying file '+DATAC1/cnamcs/datafile/users.1683.898701259'
ORA-17503: ksfdopn:2 Failed to open file +DATAC1/cnamcs/datafile/users.1683.898701259
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
2020-07-10T10:41:31.468367+00:00
Errors in file /u01/app/oracle/diag/rdbms/cnamcs/cnamcs/trace/cnamcs_m000_130813.trc:
ORA-01110: data file 5: '+DATAC1/cnamcs/datafile/maintbs.1694.900506795'
ORA-01565: error in identifying file '+DATAC1/cnamcs/datafile/maintbs.1694.900506795'
ORA-17503: ksfdopn:2 Failed to open file +DATAC1/cnamcs/datafile/maintbs.1694.900506795
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
2020-07-10T10:41:31.851294+00:00
Errors in file /u01/app/oracle/diag/rdbms/cnamcs/cnamcs/trace/cnamcs_m000_130813.trc:
ORA-01110: data file 6: '+DATAC1/cnamcs/datafile/afistbs.1695.900506823'
ORA-01565: error in identifying file '+DATAC1/cnamcs/datafile/afistbs.1695.900506823'
ORA-17503: ksfdopn:2 Failed to open file +DATAC1/cnamcs/datafile/afistbs.1695.900506823
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
...
ORA-19625: error identifying file +DATAC1/cnamcs/datafile/undotbs1.5513.970843187
ORA-17503: ksfdopn:2 Failed to open file +DATAC1/cnamcs/datafile/undotbs1.5513.970843187
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
ORA-15001: diskgroup "DATAC1" does not exist or is not mounted
Switch of datafile 10 complete to datafile copy
checkpoint is 50287282316


What can I do?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here