OraFAQ Forum: Backup & Recovery » Restore Error ORA-19963

Home » RDBMS Server » Backup & Recovery » Restore Error ORA-19963 (12c, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restore Error ORA-19963 [message #663953]

Tue, 27 June 2017 21:20

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.

Report message to a moderator

Re: Restore Error ORA-19963 [message #663954 is a reply to message #663953]

Tue, 27 June 2017 21:36

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Restore Error ORA-19963 [message #663959 is a reply to message #663953]

Wed, 28 June 2017 01:09

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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"?

Report message to a moderator

Re: Restore Error ORA-19963 [message #663961 is a reply to message #663959]

Wed, 28 June 2017 01:46

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.

Report message to a moderator

Re: Restore Error ORA-19963 [message #663962 is a reply to message #663961]

Wed, 28 June 2017 01:49

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 22:00:03 CST 2025