Home » RDBMS Server » Backup & Recovery » Restore Error ORA-19963 (12c, Windows)
Restore Error ORA-19963 [message #663953] Tue, 27 June 2017 21:20 Go to next message
greencurry
Messages: 13
Registered: June 2017
Junior Member
Hi all,

I got the error ORA-19963 when restoring the database using 12c. Please help.

Source
DB Version: 12.1.0.2
Platform: WIN 2012R2
Bit-64 bit

Target :
DB Version: 12.1.0.2
Platform: WIN 2012R2
Bit 64 bit

Backup:
=======
RMAN> backup database format 'c:\backup\petdb\%U' include current controlfile;


Restore:
========
rman target /
RMAN> shutdown immediate;
RMAN> set DBID=3852063000;
RMAN> startup force nomount;
RMAN> restore controlfile from 'C:\backup\petdb\12S7TT19_1_1';

Starting restore at 28-JUN-2017
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=243 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/28/2017 10:10:25
ORA-19963: error getting logical block size of file C:\backup\petdb\12S7TT19_1_1
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Re: Restore Error ORA-19963 [message #663954 is a reply to message #663953] Tue, 27 June 2017 21:36 Go to previous messageGo to next message
BlackSwan
Messages: 25741
Registered: January 2009
Location: SoCal
Senior Member
>O/S-Error: (OS 5) Access is denied.
Which part of above do you NOT understand?
Oracle is the victim; not the culprit.
OS user does NOT have needed OS permission to access the desired OS file.
Re: Restore Error ORA-19963 [message #663959 is a reply to message #663953] Wed, 28 June 2017 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 65249
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From your previous topic:

Michel Cadot wrote on Wed, 21 June 2017 08:44

Check that:

Quote:
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

Michel Cadot wrote on Wed, 21 June 2017 09:00

...
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Why "startup force"?

Re: Restore Error ORA-19963 [message #663961 is a reply to message #663959] Wed, 28 June 2017 01:46 Go to previous messageGo to next message
greencurry
Messages: 13
Registered: June 2017
Junior Member
It's resolved. The database instance was started by user 'oracle' (introduced in 12c) and it has no access right to open the controlfile backup. No issue after forcing the instance to be started by Windows system user.
Re: Restore Error ORA-19963 [message #663962 is a reply to message #663961] Wed, 28 June 2017 01:49 Go to previous message
Michel Cadot
Messages: 65249
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the feedback but is this not the same conclusion than in your previous topic for the same error? Wink

Previous Topic: ORA-00280
Next Topic: Retention Policy with RMAN Incremental Backups
Goto Forum:
  


Current Time: Sun Dec 10 18:19:06 CST 2017

Total time taken to generate the page: 0.01213 seconds