rman target / Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 18 20:47:38 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) RMAN> startup nomount Oracle instance started Total System Global Area 8551575552 bytes Fixed Size 2245480 bytes Variable Size 503319704 bytes Database Buffers 8036286464 bytes Redo Buffers 9723904 bytes RMAN> set DBID=2387922???; executing command: SET DBID RMAN> restore controlfile from '/dba/share/MYDB/c-2387922???-20130910-00.ctl'; Starting restore at 18-SEP-13 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=391 device type=DISK channel ORA_DISK_1: no AUTOBACKUP in 7 days found RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 09/18/2013 20:48:04 RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or pieceWe searched MOS and forums. Most of the search , pointing it is old backup ( more then 7 day ), some doc say backup corrupted etc etc. Instead going for whole story that how reached to conclusion, let we tell you the finding.
We found the mount option for /dba/share/MYDB ( where we copied backup from source ) not correct
...that's why getting error. We changed it to
rw,bg,intr,hard,timeo=600,wsize=32768,rsize=32768,nfsvers=3,tcp,noacl 0 0
After this change we able to restore control file and rest of the backup successfully
ARINET DBA Services is a Chicago, IL based organization established in 2013. Uniting more than 100+ years of combined involvement in giving quality Oracle database Support administrations to American organizations, we've given the diverse options about remote dba experts, remote dba organizations, remote dba reinforce, remote database, prophet remote, dba remote, database association, prophet dba reinforce, Oracle sponsorship and Oracle Consultants.
ReplyDeleteamazing information thanks a lot sharing with us.
ReplyDeleteTMB Clerk Result 2017
GPSC Assistant Professor and Industrial Engineer Result 2017
UPSC NDA NA Admit Card 2017
NHTET Admit Card 2017
NEET Admit card 2017
Health Benefits of Basil Seeds