oracle无法启动，恢复spfile

最新推荐文章于 2023-01-01 20:58:38 发布
最新推荐文章于 2023-01-01 20:58:38 发布
阅读量3k 收藏
点赞数
分类专栏： oracle_杂谈 文章标签： oracle database application file cache testing
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/shushugood/article/details/7788973
版权

oralce无法启动，分很多种情况，请看alertsid.log

一般情况下的启动顺序为

1. spfilesid.ora 。

2.如果没有找到，就直接从spfile.ora 启动。

3.如果还是没有找到，就从initsid.ora启动。


注意这里的sid要换成你自己的sid。 如果是RAC环境，initsid.ora中，一般是放有磁盘共享的spfile的路径。

本文是自己工作操作的一部分，有点乱，空了来整理


Connecting to 192.168.9.252:10094...

Connection established.
Escape character is '^@]'.


Last login: Sat Dec  3 18:49:21 2011 from edsm01
Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
Sourcing //.profile-EIS.....
root@edsm02 # su - grid
Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
$ asmcmd
ASMCMD> 
ASMCMD> ls
DG01DATA/
DG01REDO/
DG02REDO/
DGCRS/
ASMCMD> cd DG01DATA
ASMCMD> ls
UNICOM/
ASMCMD> cd UNICOM/PARAMETERFILE
ASMCMD> ls
spfile.262.768832711
ASMCMD> spcopy spfile.262.^[[2~48318382080/1024/1024/1024=^C
ASMCMD> 
ASMCMD> spcopy spfile.262.768832711 /tmp/
ORA-15056: additional error message
ORA-15300: File +DG01DATA/UNICOM/PARAMETERFILE/spfile.262.768832711 is incompatible with this operation
ORA-06512: at line 7 (DBD ERROR: OCIStmtExecute)
ASMCMD> cp spfile.262.768832711 /tmp/
copying +DG01DATA/UNICOM/PARAMETERFILE/spfile.262.768832711 -> /tmp//spfile.262.768832711
ASMCMD> exit
$ exit
root@edsm02 # cd /tmp
root@edsm02 # cd ^C
root@edsm02 # 
root@edsm02 # su - oracle
Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
export LOGNAME
export ORACLE_BASE
export ORACLE_HOME
export ORACLE_SID
export ORA_CRS_HOME
export PATH
$ cd $ORACLE_HOME/dbs
$ cp /tmp/spfile.262.768832711 .
$ ls
core                  hc_unicom2.dat        init.ora              initunicom2.ora       orapwunicom2          spfile.262.768832711
$ more initunicom2.ora
SPFILE='+DG01DATA/unicom/spfileunicom.ora'
$ exit
root@edsm02 # ls
hsperfdata_grid       hsperfdata_noaccess   hsperfdata_root       spfile.262.768832711
root@edsm02 # su - grid
Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
$ asmcmd




ASMCMD> ASMCMD> ASMCMD> 
ASMCMD> cd DG01DATA
ASMCMD> cd unicom
ASMCMD> ls
DATAFILE/
PARAMETERFILE/
TEMPFILE/
spfileunicom.ora
ASMCMD> spcopy spfileunicom.ora /tmp
ORA-15056: additional error message
ORA-15300: File +DG01DATA/unicom/spfileunicom.ora is incompatible with this operation
ORA-06512: at line 7 (DBD ERROR: OCIStmtExecute)
ASMCMD> cp spfileunicom.ora /tmp/
copying +DG01DATA/unicom/spfileunicom.ora -> /tmp//spfileunicom.ora
ASMCMD> exit
$ exit
root@edsm02 # su - oracle
Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
export LOGNAME
export ORACLE_BASE
export ORACLE_HOME
export ORACLE_SID
export ORA_CRS_HOME
export PATH
$ cd $ORACLE_HOME/dbs
$ ls
core                  hc_unicom2.dat        init.ora              initunicom2.ora       orapwunicom2          spfile.262.768832711
$ rm spfile*^C
$ 
$ cp /tmp/spfileunicom.ora .
$ ls
core                  hc_unicom2.dat        init.ora              initunicom2.ora       orapwunicom2          spfile.262.768832711  spfileunicom.ora
$ strings ^[[24~spfileunicom.ora |^C
$ 
$ strings  spfileunicom.ora |more
unicom1.__db_cache_size=19327352832
unicom2.__db_cache_size=19327352832
unicom1.__java_pool_size=134217728
unicom2.__java_pool_size=134217728
unicom1.__large_pool_size=402653184
unicom2.__large_pool_size=268435456
unicom1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
unicom1.__pga_aggregate_target=21340618752
unicom2.__pga_aggregate_target=22682796032
unicom1.__sga_target=25904021504
unicom2.__sga_target=24561844224
unicom1.__shared_io_pool_size=0
unicom2.__shared_
io_pool_size=0
unicom1.__shared_pool_size=3489660928
unicom2.__shared_pool_size=4160749568
unicom1.__streams_pool_size=0
unicom2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/unicom/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DG01REDO/unicom/controlfile/current.256.768792603','+DG02REDO/unicom/controlfile/current.256.768792605'
*.db_block_size=32768
*.db_cache_size=19327352832
*.db_create_file_dest='+DG01DATA'
*.db_cr
eate_online_log_dest_1='+DG01REDO'
*.db_create_online_log_dest_2='+DG02REDO'
*.db_domain=''
*.db_files=4096
*.db_keep_cache_size=2147483648
*.db_name='unicom'
*.db_recovery_file_dest='+DG01REDO'
*.db_recovery_file_dest_size=5218762752
*.db_writer_processes=8
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=unicomXDB)'
*.hash_area_size=134217728
unicom2.instance_number=2
unicom1.instance_number=1
*.job_queue_processes=20
*.memory_max_target=47244640256
*.memo
ry_target=47244640256
*.open_cursors=1000
*.parallel_force_local=TRUE
*.parallel_max_servers=94
*.parallel_min_servers=16
*.pga_aggregate_target=21474836480
*.processes=1000
*.remote_listener='rac-scan:1521'
*.remote_login_passwordfile='exclusive'
*.result_cache_max_size=1073741824
*.sessions=1005
*.sga_target=20401094656
*.sort_area_retained_size=0
*.sort_area_size=67108864
unicom2.thread=2
unicom1.thread=1
unicom2.undo_tablespace='UNDOTBS2'
unicom1.undo_tablespace='UNDOTBS1'
$ string^C
$ strings spfileunicom.ora > pfileunicom.ora
$ vi pfileunicom.ora
"pfileunicom.ora" 62 lines, 1949 characters 
:q!
unicom2.__large_pool_size=268435456
unicom1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
unicom1.__pga_aggregate_target=21340618752
unicom2.__pga_aggregate_target=22682796032
unicom1.__sga_target=25904021504
unicom2.__sga_target=24561844224
unicom1.__shared_io_pool_size=0
unicom2.__shared_
io_pool_size=0
unicom1.__shared_pool_size=3489660928
unicom2.__shared_pool_size=4160749568
unicom1.__streams_pool_size=0
unicom2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/unicom/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DG01REDO/unicom/controlfile/current.256.768792603','+DG02REDO/unicom/controlfile/current.256.768792605'
*.db_block_size=32768
*.db_cache_size=19327352832
*.db_create_file_dest='+DG01DATA'
*.db_cr
eate_online_log_dest_1='+DG01REDO'
*.db_create_online_log_dest_2='+DG02REDO'
*.db_domain=''
*.db_files=4096
*.db_keep_cache_size=2147483648
*.db_name='unicom'
*.db_recovery_file_dest='+DG01REDO'
*.db_recovery_file_dest_size=5218762752
*.db_writer_processes=8
*.diagnostic_dest='/u01/app/oracle'
:q!
$ ls
core                  hc_unicom2.dat        init.ora              initunicom2.ora       orapwunicom2          pfileunicom.ora       spfile.262.768832711  spfileunicom.ora
$ ll
ll: not found
$ ls =l
=l: No such file or directory
$ ls -l
total 1862152
-rw-------   1 root     root     47740177543 Dec  3 19:21 core
-rw-rw----   1 oracle   asmadmin    1544 Dec  3 19:27 hc_unicom2.dat
-rw-r--r--   1 oracle   oinstall    2851 Dec  2 00:55 init.ora
-rw-r-----   1 oracle   oinstall      43 Dec  2 12:39 initunicom2.ora
-rw-r-----   1 oracle   oinstall    1536 Dec  2 01:27 orapwunicom2
-rw-r--r--   1 oracle   oinstall    1949 Dec  3 19:29 pfileunicom.ora
-rw-r-----   1 oracle   oinstall    4608 Dec  3 19:27 spfile.262.768832711
-rw-r-----   1 oracle   oinstall    4608 Dec  3 19:28 spfileunicom.ora
$ vi spfileunicom.ora
"spfileunicom.ora" [Incomplete last line] 60 lines, 4608 characters (2572 null) 
unicom1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
*.audit_file_dest='/u01/app/oracle/admin/unicom/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DG01REDO/unicom/controlfile/current.256.768792603','+DG02REDO/unicom/controlfile/current.256.768792605'
*.db_block_size=32768
*.db_cache_size=10737418240
*.db_create_file_dest='+DG01DATA'
*.db_crC^AC"^D^A^D{Oeate_online_log_dest_1='+DG01REDO'
*.db_create_online_log_dest_2='+DG02REDO'
*.db_domain=''
*.db_files=4096
*.db_keep_cache_size=2147483648
*.db_name='unicom'
*.db_recovery_file_dest='+DG01REDO'
*.db_recovery_file_dest_size=5218762752
*.db_writer_processes=8
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=unicomXDB)'
*.hash_area_size=134217728
unicom2.instance_number=2
unicom1.instance_number=1
*.job_queue_processes=20
*.memory_max_target=47244640256
*.memoC^AC"^E^A^D^A8ry_target=47244640256
*.open_cursors=1000
*.parallel_force_local=TRUE
*.parallel_max_servers=94
*.parallel_min_servers=16
*.pga_aggregate_target=21474836480
*.processes=1000
*.remote_listener='rac-scan:1521'
:q!
$ ls
core                  hc_unicom2.dat        init.ora              initunicom2.ora       orapwunicom2          pfileunicom.ora       spfile.262.768832711  spfileunicom.ora
$ strings spfileunicom.ora > pfileunicom.ora
$ vi pfileunicom.ora
"pfileunicom.ora" 62 lines, 1949 characters 
unicom1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
*.audit_file_dest='/u01/app/oracle/admin/unicom/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DG01REDO/unicom/controlfile/current.256.768792603','+DG02REDO/unicom/controlfile/current.256.768792605'
*.db_block_size=32768
*.db_cache_size=10737418240
*.db_create_file_dest='+DG01DATA'
*.db_create_online_log_dest_1='+DG01REDO'
*.db_create_online_log_dest_2='+DG02REDO'
*.db_domain=''
*.db_files=4096
*.db_keep_cache_size=1024000000
*.db_name='unicom'
*.db_recovery_file_dest='+DG01REDO'
*.db_recovery_file_dest_size=5218762752
*.db_writer_processes=8
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=unicomXDB)'
*.hash_area_size=134217728
unicom2.instance_number=2
unicom1.instance_number=1
*.job_queue_processes=20
*.memory_max_target=26843545600
*.memory_target=26843545600
*.open_cursors=1000
*.parallel_force_local=TRUE
*.parallel_max_servers=94
*.parallel_min_servers=16
*.processes=1000
*.remote_listener='rac-scan:1521'
*.remote_login_passwordfile='exclusive'
"pfileunicom.ora" 42 lines, 1345 characters 
$ pwd
/u01/app/oracle/product/11.2.0/db_1/dbs
$ sqlplus / a^C
$ 
$ ipcs
IPC status from <running system> as of Sat Dec  3 19:38:30 CST 2011
T         ID      KEY        MODE        OWNER    GROUP
Message Queues:
Shared Memory:
m          5   0x375dba58 --rw-rw----     grid oinstall
Semaphores:
s         15   0xe438b514 --ra-ra----   oracle asmadmin
s         11   0xedb374bc --ra-ra----     grid oinstall
$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.2.0 Production on Sat Dec 3 19:38:37 2011


Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to an idle instance.


SQL> startup mount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/pfileunicom.ora';
ORACLE instance started.


Total System Global Area 2.6732E+10 bytes
Fixed Size                  2170944 bytes
Variable Size            9529466816 bytes
Database Buffers         1.7046E+10 bytes
Redo Buffers              154394624 bytes
Database mounted.
SQL>








--以上操作已经好了




### BEGIN LOG - DATE: 111203, TIME: 194542 ###




SQL> 
SQL> select name from v$asm_diskgroup;


NAME
------------------------------
DG01DATA
DG01REDO
DG02REDO
DGCRS


SQL> select na^C


SQL> 
SQL> 
SQL> 
SQL> create spfile='+DG01DATA' from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/pfileunicom.ora';


File created.


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
$ srvctl config database -d unicom
Database unique name: unicom
Database name: unicom
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DG01DATA/unicom/spfileunicom.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: unicom
Database instances: unicom1,unicom2
Disk Groups: DG01DATA,DG01REDO,DG02REDO
Mount point paths: 
Services: dataclient,dataldr
Type: RAC
Database is administrator managed
$ id
uid=1101(oracle) gid=1000(oinstall)
$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.2.0 Production on Sat Dec 3 19:53:09 2011


Copyright (c) 1982, 2010, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


SQL> create spfile='+DG01DATA/unicom/spfileunicom.ora' pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/pfileunicom.ora';
create spfile='+DG01DATA/unicom/spfileunicom.ora' pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/pfileunicom.ora'
                                                  *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected




SQL> create spfile='+DG01DATA/unicom/spfileunicom.ora' from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/pfileunicom.ora';


File created.


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
$ srvctl modify ^C
$ 
$ srvctl config database -d unicm
^C$ 
$ 
$ 
$ srvctl config database -d unicom
Database unique name: unicom
Database name: unicom
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DG01DATA/unicom/spfileunicom.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: unicom
Database instances: unicom1,unicom2
Disk Groups: DG01DATA,DG01REDO,DG02REDO
Mount point paths: 
Services: dataclient,dataldr
Type: RAC
Database is administrator managed
$ 
$ 
$ 
$ exit
root@edsm02 # ^C
root@edsm02 # 
root@edsm02 # id
uid=0(root) gid=0(root)
root@edsm02 # su - oracle
Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
export LOGNAME
export ORACLE_BASE
export ORACLE_HOME
export ORACLE_SID
export ORA_CRS_HOME
export PATH
$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.2.0 Production on Sat Dec 3 19:54:47 2011


Copyright (c) 1982, 2010, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


SQL> shutdown immediate
ORA-01109: database not open




Database dismounted.
ORACLE instance shut down.
SQL> startup




ORACLE instance started.


Total System Global Area 2.6732E+10 bytes
Fixed Size                  2170944 bytes
Variable Size            9730793408 bytes
Database Buffers         1.6844E+10 bytes
Redo Buffers              154394624 bytes
Database mounted.
Database opened.
SQL> SQL> SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
$ pwd
/export/home/oracle
$ ls
oradiag_oracle           phoenix_ln_20110609.log  script                   uphoenix_bk              uphoenixwy1103.dmp
phoenix_exp              phoenix_ln_20110609.sql  uphoenix0915z.dmp        uphoenixjc.dmp           ~
$ cd $ORACLE_HOME/dbs
$ ls
core                  hc_unicom2.dat        init.ora              initunicom2.ora       orapwunicom2          pfileunicom.ora       spfile.262.768832711  spfileunicom.ora
$ rm -^C
$ 
$ mv pfileunicom.ora pfileunicom.ora.bak
$ ls
core                  hc_unicom2.dat        init.ora              initunicom2.ora       orapwunicom2          pfileunicom.ora.bak   spfile.262.768832711  spfileunicom.ora
$ mv spfileunicom.ora spfileunicom.ora.bak
$ ls
core                  hc_unicom2.dat        init.ora              initunicom2.ora       orapwunicom2          pfileunicom.ora.bak   spfile.262.768832711  spfileunicom.ora.bak
$ rm spfile.262*
$ ls
core                  hc_unicom2.dat        init.ora              initunicom2.ora       orapwunicom2          pfileunicom.ora.bak   spfileunicom.ora.bak
$ ore^C
$ 
$ more initunicom2.ora
SPFILE='+DG01DATA/unicom/spfileunicom.ora'
$ 
$ 
$ 
$ 
老农民挖数据
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
oracle 无法启动 还原 spfile,修改SPFILE参数后ORACLE无法启动的解决方案
weixin_30345333的博客
04-14 324
2009-08-19CPU:Inte(R) Xeon(R) E7440 2.40GHZ(4CPU)内存(RAM):8GBOS:Windows Server 2008 64BitDB:Oracle Dabase 10g Enterprise Edition Release 10.2.0.3.0今天尝试着调整一下数据库的性能，由于疏忽没有做好备份(spfile.ora)，直接修改了SGA_MAX_SI...
ORACLE多次执行不完全恢复
谁伴我闯荡
07-23 826
昨天在做不完全恢复实验时，发现一个意思的现象，即可以多次执行不完全恢复，即使以resetlogs的方式打开数据库后，依然可以用之前的备份做不完全恢复，恢复到resetlogs之前或之后都可以。 下面演示以resetlogs打开数据库后再次用之前的备份做不完全恢复，恢复到resetlogs之前的时间。 首先看下备份的时间： RMAN&gt; list backup of database; ...
oracle修复失败怎么办,【案例】Oracle异常恢复 由于坏块和不恰当恢复引起各种ORA-600案例完整思路...
weixin_42628846的博客
04-05 904
天萃荷净运维DBA反映Oracle数据库无法Open正常打开，查看alert日志发现大量各种Ora-00600错误，分析原因为由于坏块和不恰当恢复引起1.故障后重启,无法启动主要表现在block坏块,引起的各种ORA-600等错误Mon Mar 02 16:09:27 2015ALTER DATABASE OPENBeginning crash recovery of 1 threadsparal...
跨resetlogs不完全恢复- oracle自动reset错误incarnation
weixin_30552811的博客
12-26 128
在做oracle跨resetlogs的不完全恢复时，如果未删除flashback area的控制文件自动备份，那么Oracle可能会从控制文件自动备份中自动探测到incarnation信息，并重置incarnation，从而导致恢复报错。(不完全恢复测试一) 在做oracle跨resetlogs的不完全恢复时，如果需要catalog归档日志，注意不要catalog不相关的归档日志，否则Oracl...
oracle启动时报归档目录满了,修复因归档日志满而无法启动Oracle的解决方案
weixin_36073697的博客
04-04 297
本文内容遵从CC版权协议, 可以随意转载, 但必须以超链接形式标明文章原始出处和作者信息及版权声明网址: http://www.penglixun.com/tech/database/repair_archive_logs_over_cause_cannot_start_oracle.html在Linux上，安装完成之后，在测试RMAN时可能会遇到如下错误：[oracle@smsdbrac1 or...
oracle异机恢复.docx|oracle异机恢复.docx
11-12
Oracle异机恢复 Oracle异机恢复是指在不同的机器上恢复Oracle数据库的过程。该过程需要准备好目标机器的环境，包括安装Oracle数据库软件、配置网络和存储等。下面是Oracle异机恢复的步骤和知识点： 1. 准备环境 ...
实战Oracle rman还原和恢复
最新发布
04-22
Oracle RMAN（Recovery Manager）是Oracle数据库管理系统中用于备份、恢复和维护的重要工具。它提供了全面的数据保护功能，能够帮助管理员在发生数据丢失或系统故障时迅速恢复数据。本篇将详细介绍Oracle RMAN的还原...
oracle 数据恢复 参考文档
06-02
这种方法的原理是当数据库服务启动时，会在 `%ORACLE_HOME%/database` 下找当前 SID 对应的参数文件（PFILE 或者 SPFILE）和密码文件，然后启动实例；接着根据参数文件记录的信息找到控制文件，读取控制文件的信息，...
关于系统重装后Oracle数据库完全恢复的解决办法
09-10
本篇文章将深入探讨系统重装后如何对Oracle数据库进行完全恢复，确保业务连续性。 首先，预防总是优于治疗。在系统重装之前，应确保有完整的数据库备份。Oracle数据库提供了多种备份策略，如物理备份（包括完整...
Oracle不完全恢复
u011868279的博客
01-01 358
Oracle不完全恢复
oracle rman备份spfile,RMAN备份恢复之SPFILE的恢复（一）
weixin_39779537的博客
04-13 728
缺少初始化文件，数据库是无法启动的。如果通过RMAN备份了初始化参数，那么可以通过RMAN对初始化参数进行恢复。这篇文章简单介绍CATALOG方式下初始化参数的恢复问题。初始化参数的丢失和损坏，并不会造成太严重的问题，即使是最坏的情况，导致无法进行恢复，也是可以通过手工编辑一个新的PFILE文件，来启动实例的。而且，在数据库的alert文件中包含了每次数据库启动使用的所有非默认值初始化参数，因此重...
Oracle 移植 失败,Oracle迁移导致sqlplus报告ora-15180错误信息
weixin_34547317的博客
04-14 226
Oracle 软件版本： 10.2.0.5Oracle安装目录：/u01通过lync方式把Oracle整个目录从源服务器拷贝到目标服务器。按理说，软件迁移不Oracle 软件版本： 10.2.0.5Oracle安装目录：/u01通过lync方式把Oracle整个目录从源服务器拷贝到目标服务器。按理说，，软件迁移不会导致很严重的错误，但是通过sqlplus连接到oracle，计划启动数据库的时候报告...
oracle. 还原pfile,如何恢复spfile 文件
weixin_35691715的博客
04-06 480
有完整的rman 备份，现在oracle 的所有数据文件都没有了，就需要恢复，但是如何先恢复spfile 或者pfile 文件呢？RMAN> connecttarget /;connected to target database (not started)RMAN> restore spfile from '/export/home/oracle/rmanbk/c-2839236...
oracle随记——spfile和pfile的区别，生成，加载和修复
热门推荐
奔跑的菜菜
04-13 2万+
oracle数据库的配置文件指的是系统在启动到“nomount”阶段需要加载的文件，也叫做pfile或者spfile，但是其实pfile和spfile是不同的文件。 不同的数据库配置文件是不同的，但是格式大体是近似的，默认地址是oracle安装目录下database 文件夹，例如：“c:\app\Administrator\product\11.2.0\dbhome_1\database”。 前
oracle 误删spfile,Oracle基础教程：关于spfile的恢复
weixin_28729205的博客
04-12 383
本实验是恢复spfile: SQLgt; shutdown immediate;Database closed.Database dismounted.Oracle instance shut down.SQLgt; sta本实验是恢复spfile:SQL> shutdown immediate;Database closed.Database dismounted.Oracle insta...
Oracle 11gR2修改内存参数后无法启动问题
新路的专栏
02-28 6457
Microsoft Windows [版本 6.1.7600] 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:\windows\system32>net start oracleserviceorcl OracleServiceORCL 服务正在启动 ...... OracleServiceORCL 服务已经启动成功。 C:\wi
oracle 重新启动及恢复
zqs520的专栏
08-20 342
-------linux oracle 重新启动   linux下重启oracle [oracle@dbOracle9i ~]$lsnrctl stop             ----------关闭监听 LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 10-OCT-2011 16:19:02   Cop...
Oracle DataGuard 备份恢复策略与实战
"Oracle DataGuard备份恢复最佳实践讨论了如何在备库上实施备份，以及在不同场景下DataGuard的备份恢复策略。该文档由鼎甲科技的高级技术顾问姚远撰写，他拥有丰富的Oracle和MySQL数据库经验及多项技术认证。课程...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值