Example of Restore Log for Alternate Location with Inocrrent Permission Setup

The following is an example of a common restore error message that may appear during Restore to Alternate Location if the Oracle user is not added to the access permission for the alternate location folder with Full control.


[2021/02/22 14:12:11] [erro] SQL*Plus: Release 18.0.0.0.0 - Production on Mon
Feb 22 14:12:07 2021
[2021/02/22 14:12:11] [cbs] erro,SQL*Plus: Release 18.0.0.0.0 - Production on
Mon Feb 22 14:12:07 2021,0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] Version 18.3.0.0.0
[2021/02/22 14:12:11] [cbs] erro,Version 18.3.0.0.0,0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] Copyright (c) 1982, 2018, Oracle. All rights
reserved.
[2021/02/22 14:12:11] [cbs] erro,"Copyright (c) 1982, 2018, Oracle. All rights
reserved.",0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] Connected to:
[2021/02/22 14:12:11] [cbs] erro,Connected to:,0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] Oracle Database 18c Enterprise Edition Release
18.0.0.0.0 - Production
www.ahsay.com AhsayOBM Oracle Backup and Restore Guide | 95 of 141
[2021/02/22 14:12:11] [cbs] erro,Oracle Database 18c Enterprise Edition Release
18.0.0.0.0 - Production,0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] Version 18.3.0.0.0
[2021/02/22 14:12:11] [cbs] erro,Version 18.3.0.0.0,0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] ORA-00283: recovery session canceled due to errors
[2021/02/22 14:12:11] [cbs] erro,ORA-00283: recovery session canceled due to
errors,0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] ORA-17528: A read-only file or a file opened readonly cannot be written to:
[2021/02/22 14:12:11] [cbs] erro,ORA-17528: A read-only file or a file opened
read-only cannot be written to:,0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] D:\RS\ORADATA\ORCL123\SYSTEM01.DBF.
[2021/02/22 14:12:11] [cbs]
erro,D:\RS\ORADATA\ORCL123\SYSTEM01.DBF.,0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] SP2-0042: unknown command "auto" - rest of line
ignored.
[2021/02/22 14:12:11] [cbs] erro,"SP2-0042: unknown command \"auto\" - rest of
line ignored.",0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] Disconnected from Oracle Database 18c Enterprise
Edition Release 18.0.0.0.0 - Production
[2021/02/22 14:12:11] [cbs] erro,Disconnected from Oracle Database 18c
Enterprise Edition Release 18.0.0.0.0 - Production,0,0,0,1613960327406,0,0
[2021/02/22 14:12:11] [erro] Version 18.3.0.0.0
[2021/02/22 14:12:11] [cbs] erro,Version 18.3.0.0.0,0,0,0,1613960327406,0,0
[2021/02/22 14:12:19] [info] Remove win service
[2021/02/22 14:12:19] [cbs] info,Remove win service,0,0,0,1613960327406,0,0
[2021/02/22 14:12:30] [erro] [hV] Restore database fail., Reason = "Recover
database fail"
[2021/02/22 14:12:30] [cbs] erro,"[hV] Restore database fail., Reason =
\"Recover database fail\"",0,0,0,1613960327406,0,0
[2021/02/22 14:12:31] [erro] Restore completed with error(s)
[2021/02/22 14:12:31] [cbs]
end,RESTORE_STOP_SUCCESS_WITH_ERROR,0,0,0,1613960327406,0,0
AhsayOBM