Search This Blog

Total Pageviews

Monday, 30 June 2025

RMAN-06403: could not obtain a fully authorized session






RMAN> restore spfile from '/dumps/VORCL/spfile_2m3t9864_1_1';

Starting restore at 30-JUN-25
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/30/2025 04:04:23
RMAN-12010: automatic channel allocation initialization failed
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3701
Additional information: -755668061






RMAN> startup force nomount ;   --------------------   startup force nomount 

Oracle instance started

Total System Global Area    3221225472 bytes

Fixed Size                     8797928 bytes
Variable Size               1476395288 bytes
Database Buffers            1728053248 bytes
Redo Buffers                   7979008 bytes

RMAN> restore spfile from '/dumps/VORCL/spfile_2m3t9864_1_1';

Starting restore at 30-JUN-25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4 instance=vorcl11 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/30/2025 04:05:42
RMAN-06564: must use the TO clause when the instance is started with SPFILE







allocate  channel then try !!!!



run {
     allocate channel d1 type disk;
     restore spfile from '/dumps/VORCL/spfile_2m3t9864_1_1';
     }
RMAN> 2> 3> 4>

using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=927 device type=DISK

Starting restore at 30-JUN-25

channel d1: restoring spfile from AUTOBACKUP /dumps/VORCL/spfile_2m3t9864_1_1
channel d1: SPFILE restore from AUTOBACKUP complete
Finished restore at 30-JUN-25
released channel: d1

Oracle DBA

anuj blog Archive