Pages

Friday 16 August 2013

Error while performing RMAN restoration

We got below error while restoring database from backup(ASM) to file system

RMAN> run {
2> SET NEWNAME FOR DATABASE   TO  '/fsnadmin/sangamesh/spshidms/database/%b';
3> SET NEWNAME FOR tempfile  1 TO  '/fsnadmin/sangamesh/spshidms/database/%b';
4> SET NEWNAME FOR tempfile  2 TO  '/fsnadmin/sangamesh/spshidms/database/%b';
5> SET NEWNAME FOR tempfile  3 TO  '/fsnadmin/sangamesh/spshidms/database/%b';
6> restore database;
7> switch datafile all;
8> switch tempfile all;
9> }

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 14-AUG-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=758 device type=DISK

channel ORA_DISK_1: restoring datafile 00001
input datafile copy RECID=1349 STAMP=823381234 file name=+RECO_ACLO1/spshidmp/datafile/system.2090.792669571
destination for restore of datafile 00001: /fsnadmin/sangamesh/spshidms/database/system.307.790709109
ORA-19505: failed to identify file "+RECO_ACLO1/spshidmp/datafile/system.2090.792669571"
ORA-17503: ksfdopn:2 Failed to open file +RECO_ACLO1/spshidmp/datafile/system.2090.792669571
ORA-15001: diskgroup "RECO_ACLO1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-19600: input file is datafile-copy 1349 (+RECO_ACLO1/spshidmp/datafile/system.2090.792669571
channel ORA_DISK_1: restoring datafile 00002
input datafile copy RECID=1355 STAMP=823381244 file name=+RECO_ACLO1/spshidmp/datafile/sysaux.2091.792669571
destination for restore of datafile 00002: /fsnadmin/sangamesh/spshidms/database/sysaux.306.790709109
ORA-19505: failed to identify file "+RECO_ACLO1/spshidmp/datafile/sysaux.2091.792669571"
ORA-17503: ksfdopn:2 Failed to open file +RECO_ACLO1/spshidmp/datafile/sysaux.2091.792669571
ORA-15001: diskgroup "RECO_ACLO1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-19600: input file is datafile-copy 1355 (+RECO_ACLO1/spshidmp/datafile/sysaux.2091.792669571
channel ORA_DISK_1: restoring datafile 00003
input datafile copy RECID=1354 STAMP=823381243 file name=+RECO_ACLO1/spshidmp/datafile/undotbs1.2036.792669575
destination for restore of datafile 00003: /fsnadmin/sangamesh/spshidms/database/undotbs1.305.790709109
ORA-19505: failed to identify file "+RECO_ACLO1/spshidmp/datafile/undotbs1.2036.792669575"
ORA-17503: ksfdopn:2 Failed to open file +RECO_ACLO1/spshidmp/datafile/undotbs1.2036.792669575
ORA-15001: diskgroup "RECO_ACLO1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-19600: input file is datafile-copy 1354 (+RECO_ACLO1/spshidmp/datafile/undotbs1.2036.792669575

Reason:
Parameters db_file_name_convert and db_create_online_log_dest_1 are not set. So set these parameters and try.
Eg:
*.db_file_name_convert='+RECO_ACLO1/prod/datafile/','/fsnadmin/sangamesh/test/database/'

*.db_create_online_log_dest_1=’/fsnadmin/sangamesh/test/database/

No comments:

Post a Comment