This is called a dummy instance which starts with a Memory_target value (automatic memory management). In this situation you need not to define size of any SGA components and Oracle takes care of SGA components sizes and PGA size . Generally we use this instance for restoring spfile from auto backup.
Remove all spfile and pfiles from dbs location and then you should have permission on O_H/rdbms/log directory
RMAN>startup force nomount;
DEMO
C:\Documents and Settings\amit>sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Sat Feb 25 20:13:09 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS>>startup force
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'H:\APP\ORACLE\PRODUCT\11.1.0\DATABASE\
INITIBM.ORA'
SYS>>exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Documents and Settings\amit>rman target /
Recovery Manager: Release 11.1.0.6.0 - Production on Sat Feb 25 20:13:51 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup force nomount
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'H:\APP\ORACLE\PRODUCT\11.1.0\DATABASE\
INITIBM.ORA'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 159019008 bytes
Fixed Size 1331852 bytes
Variable Size 67112308 bytes
Database Buffers 83886080 bytes
Redo Buffers 6688768 bytes
RMAN> exit
Recovery Manager complete.
C:\Documents and Settings\amit>sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Sat Feb 25 20:17:31 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS>>sho parameter spf
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
Remove all spfile and pfiles from dbs location and then you should have permission on O_H/rdbms/log directory
RMAN>startup force nomount;
DEMO
C:\Documents and Settings\amit>sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Sat Feb 25 20:13:09 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS>>startup force
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'H:\APP\ORACLE\PRODUCT\11.1.0\DATABASE\
INITIBM.ORA'
SYS>>exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Documents and Settings\amit>rman target /
Recovery Manager: Release 11.1.0.6.0 - Production on Sat Feb 25 20:13:51 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup force nomount
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'H:\APP\ORACLE\PRODUCT\11.1.0\DATABASE\
INITIBM.ORA'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 159019008 bytes
Fixed Size 1331852 bytes
Variable Size 67112308 bytes
Database Buffers 83886080 bytes
Redo Buffers 6688768 bytes
RMAN> exit
Recovery Manager complete.
C:\Documents and Settings\amit>sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Sat Feb 25 20:17:31 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS>>sho parameter spf
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
Thanks for providing this informative information you may also refer.
ReplyDeletehttp://www.s4techno.com/blog/2016/10/12/10g-data-guard-physical-standby-creation-step-step/
Hi. I have a peculiar problem in windows.
ReplyDeleteIn the initial stages this was working fine and rman started a dummy instance with default sga settings.
suddenly rman fails to start the dummy instance.
please look at my messages
C:\Users\Admin>rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Sat Aug 19 15:05:20 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 08/19/2017 15:05:24
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
RMAN> startup force nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE\APPS\DBSERVER12C\12_2_0_1\DATABASE\INITCONDB1.ORA'
starting Oracle instance without parameter file for retrieval of spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 08/19/2017 15:05:48
RMAN-04025: unable to generate a temporary file
I really don't have any idea on what really happened inn my system
@Shivakkumar Palanisamy:
ReplyDeletePlease check the error from bottom to top.
From your post looks like your last error is
RMAN-04025: unable to generate a temporary file
Check the cause of this error whether you have sufficient disk space or correct permission on the directory.
In case further assistance required, you can get in touch at
- AJ
https://snapshottooold.blogspot.in/
abhishekjha10@gmail.com