{"id":1376,"date":"2018-02-22T14:22:13","date_gmt":"2018-02-22T06:22:13","guid":{"rendered":"http:\/\/www.821121.com\/?p=1376"},"modified":"2021-03-02T10:51:00","modified_gmt":"2021-03-02T02:51:00","slug":"oracle%e4%bf%ae%e6%94%b9dbname%e5%92%8cdbid","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1376","title":{"rendered":"Oracle\u4fee\u6539dbname\u548cdbid"},"content":{"rendered":"
DBID\u662fDataBase IDentifier\u7684\u7f29\u5199\uff0c\u610f\u601d\u5c31\u662f\u6570\u636e\u5e93\u7684\u552f\u4e00\u6807\u8bc6\u7b26\u3002\u8fd9\u4e2aDBID\u5728\u6570\u636e\u6587\u4ef6\u5934\u548c\u63a7\u5236\u6587\u4ef6\u90fd\u662f\u5b58\u5728\u7684\uff0c\u53ef\u4ee5\u7528\u4e8e\u6807\u793a\u6570\u636e\u6587\u4ef6\u7684\u5f52\u5c5e\u3002 \u5bf9\u4e8e\u4e0d\u540c\u6570\u636e\u5e93\u6765\u8bf4\uff0cDBID\u5e94\u5f53\u4e0d\u540c\uff0c\u800cdb_name\u5219\u53ef\u80fd\u662f\u76f8\u540c\u7684.\n\u5173\u4e8edbid:\n1,dbnewid \u53ef\u4ee5\u66f4\u6539\u7684\u5185\u5bb9\n*\u6570\u636e\u5e93dbid\n*\u6570\u636e\u5e93dbname\n*\u540c\u65f6\u66f4\u6539\u6570\u636e\u5e93\u4e2d\u7684dbid\u548cdbname\n2.\u66f4\u6539dbid\u548cdbname\u7684\u5f71\u54cd\na\u3001\u4fee\u6539 dbid \u7b49\u540c\u4e8e\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u6570\u636e\u5e93\uff0c\u4e0d\u540c\u7684\u662f\u6570\u636e\u5df2\u7ecf\u5b58\u5728\u4e8e\u6570\u636e\u6587\u4ef6\u3002\u8fd9\u662f\u7531 dbid \u7684\u552f\u4e00\u6027\u51b3\u5b9a\u7684\u3002\u4fee\u6539\u4e4b\u540e\u6240\u6709\u4e4b\u524d\u7684\u5907\u4efd\u4e0e\u5f52\u6863\u65e5\u5fd7\u5c06\u4e0d\u53ef\u7528\uff0c\u56e0\u4e3a\u5728\u6062\u590d\u65f6\u4f1a\u68c0\u6d4b dbid\uff0c\u7531\u4e8e\u4e0d\u5339\u914d\uff0c\u5219\u6240\u6709\u5907\u4efd\u65e0\u6548\u3002\u4fee\u6539\u4e4b\u540e\u9700\u8981\u4f7f\u7528 open resetlogs \u6253\u5f00\u6570\u636e\u5e93\uff0c\u4e00\u4e2a\u65b0\u7684 incarnation \u4f1a\u88ab\u521b\u5efa\uff0c\u4e14 sequence\u88ab\u7f6e\u4e3a1\u3002\u4fee\u6539\u4e4b\u540e\u4e14\u6210\u529f open \u7684\u60c5\u5f62\u4e0b\uff0c\u5efa\u8bae\u4e00\u81f4\u6027\u5173\u95ed\u6570\u636e\u5e93\uff0c\u91cd\u542f\u5e76\u505a\u4e00\u4e2a\u5b8c\u6574\u7684\u5907\u4efd\u3002\nb\u3001\u4fee\u6539 dbname \u4fee\u6539\u4e4b\u540e\uff0c\u65e0\u9700\u4f7f\u7528 open resetlogs \u6253\u5f00\u6570\u636e\u5e93\u3002(\u6ce8 dbname \u4e0d\u5177\u6709\u552f\u4e00\u6027\uff0cglobal name \u5219\u5177\u6709\u552f\u4e00\u6027)\u3002\u4fee\u6539\u4e4b\u540e\uff0c\u6240\u6709\u7684\u5907\u4efd\u5373\u5f52\u6863\u65e5\u5fd7\u4f9d\u65e7\u53ef\u7528\u3002\u4fee\u6539\u4e4b\u540e\uff0c\u9700\u8981\u4fee\u6539 pfile\/spfile \u4e2d\u5bf9\u5e94\u7684 db_name \u53c2\u6570\u4ee5\u53ca\u91cd\u5efa\u76f8\u5e94\u7684 Oracle \u5bc6\u7801\u6587\u4ef6\u3002\u5982\u679c\u9700\u8981\u4f7f\u7528\u65e7\u7684\u63a7\u5236\u6587\u4ef6\u6062\u590d\u6570\u636e\u5e93\uff0c\u5e94\u5f53\u4f7f\u7528\u4fee\u6539\u4e4b\u524d\u7684 pfile\/spfile \u4ee5\u53ca\u5bc6\u7801\u6587\u4ef6\u542f\u52a8\u6570\u636e\u5e93\u518d\u8fdb\u884c\u6062\u590d\u3002\nc\u3001\u540c\u65f6\u4fee\u6539 dbid \u53ca dbname \u5982\u679c\u540c\u65f6\u4fee\u6539\uff0c\u5219\u662f\u4e0a\u8ff0\u4e24\u79cd\u60c5\u5f62\u7684\u7efc\u5408\uff0c\u4fee\u6539\u5b8c\u6bd5\u540e\u9700\u8981 open resetlogs \u4ee5\u53ca\u4fee\u6539 pfile\/spifle\uff0c\u5bc6\u7801\u6587\u4ef6\uff0c\u5168\u5907\u6570\u636e\u5e93\n3.\u66f4\u6539dbid\u548cdbname\u8bed\u6cd5\n*\u66f4\u6539dbid\ncmd> nid target=sys\/password@test_db ---\u66f4\u6539dbid\u5fc5\u987b\u5b9a\u4e49\u4e00\u4e2a\u5177\u6709sysdba\u6743\u9650\u7684\u7528\u6237\n*\u66f4\u6539dbid\u540c\u65f6\u66f4\u6539dbname\ncmd>nid target=sys\/password@test_db dbname=name\n*\u53ea\u66f4\u6539dbname\ncmd>nid target=sys\/password@test_db dbname=name setname=yes\n4.\u5176\u4ed6\u8bf4\u660e\n\u4e0d\u5e72\u51c0\u7684\u5173\u95ed\u6570\u636e\u5e93\u540e\u4f7f\u7528dbnewid\u66f4\u6539\u6570\u636e\u5e93dbid\u4f1a\u5bfc\u81f4\u62a5\u9519,\u6709\u4e00\u4e2a\u540e\u52a8\u7ebf\u7a0b\u5728\u4f7f\u7528.<\/code><\/pre>\n
\u65b9\u68481\uff1a\u4f7f\u7528nid\u4fee\u6539\u6539\u547d\u4ee4\u4fee\u6539 dbname \u53ca \u53ca dbid-- \u4e0d\u80fd\u4fee\u6539\u4e3a\u6307\u5b9a\u7684 dbid\n\u5de5\u4f5c\u4e2d\u4e0d\u53ef\u907f\u514d\u5730\u78b0\u5230\u9700\u8981\u4fee\u6539 dbname \u4ee5\u53ca dbid \u7684\u60c5\u5f62\uff0c\u5982\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u540c\u4e00\u53f0\u673a\u5668\u7684\u60c5\u5f62\u662f\u5176\u4e2d\u4e4b\u4e00\u3002\u4f46 dbname \u4ee5\u53ca dbid \u662f\u7528\u4e8e\u6807\u8bc6\u6570\u636e\u5e93\u7684\u91cd\u8981\u6807\u5fd7\u4e4b\u4e00\uff0c\u5c24\u5176\u662f dbid\uff0c\u5177\u6709\u552f\u4e00\u6027\uff0c\u56e0\u6b64\u5bf9\u5176\u4fee\u6539\u5e94\n\u614e\u91cd\u5904\u7406\u3002\u672c\u6587\u63cf\u8ff0\u4e86\u4fee\u6539 dbname \u4ee5\u53ca dbid \u7684\u6b65\u9aa4\u5e76\u7ed9\u51fa\u793a\u4f8b\u3002nid \u5de5\u5177\u6267\u884c\u7684\u547d\u4ee4\u5b9e\u9645\u4e5f\u662f\u8c03\u7528 DBMS_BACKUP_RESTORE \u5305\u76f8\u5e94\u7684\u5b58\u50a8\u8fc7\u7a0b\u5b9e\u73b0\u7684\u3002\n\n\u4fee\u6539\u6b65\u9aa4\uff1a\na\u3001\u5168\u5907\u6570\u636e\u5e93\uff0c\u5982\u679c\u662f\u70ed\u5907(rman or os)\u5e94\u786e\u4fdd\u6240\u6709\u7684\u5f52\u6863\u65e5\u5fd7\u4ee5\u53ca\u8054\u673a\u65e5\u5fd7\u53ef\u7528\nb\u3001\u5220\u9664 dbconsole([ID 863800.1]\u6709\u6b64\u8981\u6c42\uff0c\u5982\u7528\u5230 dbconsole\uff0c\u5e94\u8003\u8651\u6309\u6b64\u64cd\u4f5c)\nc\u3001\u542f\u52a8\u9700\u8981\u4fee\u6539\u7684\u6570\u636e\u5e93\u5230 mount \u72b6\u6001(startup mount\uff09\nd\u3001\u5982\u679c\u4f7f\u7528 spfile \u6587\u4ef6\u542f\u52a8\u6570\u636e\u5e93\uff0c\u5907\u4efd spfile \u6587\u4ef6\u5230 pfile \u7528\u4e8e\u540e\u7eed\u4fee\u6539 db_name\ne\u3001\u53d1\u5e03 nid \u547d\u4ee4\nnid target=sys\/password #\u6b64\u65b9\u5f0f\u662f\u4ec5\u4ec5\u4fee\u6539 dbid\nnid target=\/ dbname=new_dbname [setname=yes]# \/ \u8868\u660e\u8fde\u63a5\u5230\u5f53\u524d\u73af\u5883\u7684 sid\uff0c\u4e14\u4f7f\u7528\u64cd\u4f5c\u7cfb\u7edf\u8ba4\u8bc1\nnid target=sys\/password dbname=new_dbname [setname=yes] # setname=yes \u4ec5\u4ec5\u4fee\u6539\u6570\u636e\u5e93\u540d\u5b57\uff0c\u5982\u679c\u7701\u7565\uff0c\u5219\u4e24\u8005\u540c\u65f6\u4fee\u6539\nnid target=sys\/pwdd@conn_string dbname=new_dbname [setname=yes] #\u4f7f\u7528\u8fde\u63a5\u4e32\u8fde\u63a5\u5230\u8fdc\u7a0b\u4e3b\u673a\u5e76\u4fee\u6539\nf\u3001\u4fee\u6539 Oracle \u53c2\u6570\u6587\u4ef6 pfile(\u4f7f\u7528\u5148\u524d\u4ece spfile \u5907\u4efd\u7684)\u4e2d\u7684\u53c2\u6570 db_name\uff0c\u5982\u679c\u4ec5\u4ec5\u4fee\u6539 dbid\uff0c\u8df3\u8fc7\u6b64\u6b65\u9aa4\ng\u3001\u4f7f\u7528\u65b0\u7684\u53c2\u6570\u6587\u4ef6 pfile \u542f\u52a8\u5230 mount \u72b6\u6001(\u5982\u679c\u4fee\u6539\u4e86 dbname\uff0c\u5982\u679c\u4ec5\u4ec5\u662f dbid\uff0c\u5219\u76f4\u63a5\u4f7f\u7528\u539f\u6765\u7684 pfile \u6216 spfile \u542f\u52a8)\nh\u3001\u4f7f\u7528 open resetlogs \u65b9\u5f0f\u6253\u5f00\u6570\u636e\u5e93(\u4fee\u6539\u975e dbid\uff0c\u76f4\u63a5\u6253\u5f00\u5373\u53ef)\ni\u3001\u91cd\u5efa\u5f53\u524d\u6570\u636e\u5e93\u7684 Oralce \u5bc6\u7801\u6587\u4ef6\u53ca\u5c06 pfile \u6587\u4ef6\u8f6c\u6362\u6210 spfile \u6587\u4ef6\nj\u3001\u4fee\u6539\u76f8\u5e94\u7684\u76d1\u542c\u5668\u7684\u914d\u503c\uff0c\u5305\u62ec listener.ora \u4ee5\u53ca tnsnames.ora\nk\u3001\u4fee\u6539\u5168\u5c40 dbname\uff0c\u5982\u679c\u6709\u7528\u5230\u7684\u8bdd\u3002ALTER DATABASE RENAME GLOBAL_NAME TO <newname>.<domain>;\nl\u3001\u91cd\u5efa dbconsole $ emca -config dbcontrol db -repos recreate\nm\u3001\u5168\u5907\u6570\u636e\u5e93\n<\/code><\/pre>\n
1. \u4fee\u6539dbid<\/h1>\n
1.1 nid\u547d\u4ee4\u89e3\u6790<\/h2>\n
[oracle@oracle dbs]$ nid\n\nDBNEWID: Release 11.2.0.4.0 - Production on Tue Jan 12 00:11:55 2021\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nKeyword     Description                    (Default)\n----------------------------------------------------\nTARGET      Username\/Password              (NONE)\nDBNAME      New database name              (NONE)\nLOGFILE     Output Log                     (NONE)\nREVERT      Revert failed change           NO\nSETNAME     Set a new database name only   NO\nAPPEND      Append to output log           NO\nHELP        Displays these messages        NO<\/code><\/pre>\n
1.2.\u4fee\u6539dbid<\/h2>\n
s```sql
\nhutdown immediate
\nstartup mount
\nSQL>  select dbid,name,open_mode from v$database
\n2  ;<\/p>\n
  DBID NAME      OPEN_MODE<\/code><\/pre>\n
\n
1583927885 ORCL      MOUNTED<\/p>\n
[oracle@oracle dbs]$ nid target=sys\/123456<\/p>\n
DBNEWID: Release 11.2.0.4.0 - Production on Tue Jan 12 00:30:32 2021<\/p>\n
Copyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.<\/p>\n
Connected to database ORCL (DBID=1583927885)<\/p>\n
Connected to server version 11.2.0<\/p>\n
Control Files in database:
\n\/u01\/app\/oracle\/oradata\/orcl\/control01.ctl
\n\/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl<\/p>\n
Change database ID of database ORCL? (Y\/[N]) => y<\/p>\n
Proceeding with operation
\nChanging database ID from 1583927885 to 1589396777
\nControl File \/u01\/app\/oracle\/oradata\/orcl\/control01.ctl - modified
\nControl File \/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl - modified
\nDatafile \/u01\/app\/oracle\/oradata\/orcl\/system01.db - dbid changed
\nDatafile \/u01\/app\/oracle\/oradata\/orcl\/sysaux01.db - dbid changed
\nDatafile \/u01\/app\/oracle\/oradata\/orcl\/undotbs01.db - dbid changed
\nDatafile \/u01\/app\/oracle\/oradata\/orcl\/users01.db - dbid changed
\nDatafile \/u01\/app\/oracle\/oradata\/orcl\/temp01.db - dbid changed
\nControl File \/u01\/app\/oracle\/oradata\/orcl\/control01.ctl - dbid changed
\nControl File \/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl - dbid changed
\nInstance shut down<\/p>\n
Database ID for database ORCL changed to 1589396777.
\nAll previous backups and archived redo logs for this database are unusable.
\nDatabase is not aware of previous backups and archived logs in Recovery Area.
\nDatabase has been shutdown, open database with RESETLOGS option.
\nSuccesfully changed database ID.
\nDBNEWID - Completed succesfully.<\/p>\n
\n## 1.3.\u4f7f\u7528open resetlogs\u542f\u52a8\u6570\u636e\u5e93\n```sql\nSQL> startup mount\nORACLE instance started.\n\nTotal System Global Area  776646656 bytes\nFixed Size                  2257272 bytes\nVariable Size             507514504 bytes\nDatabase Buffers          264241152 bytes\nRedo Buffers                2633728 bytes\nDatabase mounted.\nSQL> alter database open;\nalter database open\n*\nERROR at line 1:\nORA-01589: must use RESETLOGS or NORESETLOGS option for database open\n\nSQL> alter database open resetlogs;\n\nDatabase altered.\n\nSQL> archive log list;\nDatabase log mode              Archive Mode\nAutomatic archival             Enabled\nArchive destination            USE_DB_RECOVERY_FILE_DEST\nOldest online log sequence     1\nNext log sequence to archive   1\nCurrent log sequence           1<\/code><\/pre>\n
2.\u4fee\u6539dbname<\/h1>\n
2.1\u5168\u5907\u6570\u636e\u5e93<\/h2>\n
rman backup<\/code><\/pre>\n
2.2\u5907\u4efdspfile\u5230pfile<\/h2>\n
create pfile='\/tmp\/aaa.ora' from spfile;<\/code><\/pre>\n
2.3\u5c06\u6570\u636e\u5e93\u7f6e\u4e8emount\u72b6\u6001<\/h2>\n
startup mount<\/code><\/pre>\n
2.4\u67e5\u770b\u5f53\u524d\u6570\u636e\u7684dbid\u548cdbname<\/h2>\n
SQL> select dbid,name,open_mode from v$database;\n\n      DBID NAME      OPEN_MODE\n---------- --------- --------------------\n1589396777 ORCL      MOUNTED<\/code><\/pre>\n
2.5 \u4fee\u6539dbname<\/h2>\n
nid target=sys\/123456 dbname=COCO setname=yes\n[oracle@oracle dbs]$ nid target=sys\/123456 dbname=COCO setname=yes\n\nDBNEWID: Release 11.2.0.4.0 - Production on Tue Jan 12 01:03:02 2021\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nConnected to database ORCL (DBID=1589396777)\n\nConnected to server version 11.2.0\n\nControl Files in database:\n    \/u01\/app\/oracle\/oradata\/orcl\/control01.ctl\n    \/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl\n\nChange database name of database ORCL to COCO? (Y\/[N]) => y\n\nProceeding with operation\nChanging database name from ORCL to COCO\n    Control File \/u01\/app\/oracle\/oradata\/orcl\/control01.ctl - modified\n    Control File \/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl - modified\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/system01.db - wrote new name\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/sysaux01.db - wrote new name\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/undotbs01.db - wrote new name\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/users01.db - wrote new name\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/temp01.db - wrote new name\n    Control File \/u01\/app\/oracle\/oradata\/orcl\/control01.ctl - wrote new name\n    Control File \/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl - wrote new name\n    Instance shut down\n\nDatabase name changed to COCO.\nModify parameter file and generate a new password file before restarting.\nSuccesfully changed database name.\nDBNEWID - Completed succesfully.<\/code><\/pre>\n
2.6\u4fee\u6539pfile<\/h2>\n
db_name=coco<\/code><\/pre>\n
2.7\u4f7f\u7528pifle\u542f\u52a8\u6570\u636e\u5e93<\/h2>\n
SQL> startup mount pfile='aaa.ora';\nORACLE instance started.\n\nTotal System Global Area  776646656 bytes\nFixed Size                  2257272 bytes\nVariable Size             507514504 bytes\nDatabase Buffers          264241152 bytes\nRedo Buffers                2633728 bytes\nDatabase mounted.\nSQL> alter database open; \n\nDatabase altered.<\/code><\/pre>\n
2.8\u67e5\u770b\u9a8c\u8bc1\u5f53\u524d\u6570\u636e\u7684dbid\u548cdbname<\/h2>\n
SQL> select dbid,name,open_mode from v$database;\n\n      DBID NAME      OPEN_MODE\n---------- --------- --------------------\n1589396777 COCO      READ WRITE\n--\u6821\u9a8c\u4fee\u4f3d\u540e\u7684\u72b6\u6001\uff0cdbid \u672a\u53d1\u751f\u53d8\u5316\uff0c\u4f46 dbname \u5df2\u7ecf\u88ab\u4fee\u6539<\/code><\/pre>\n
2.9\u91cd\u5efaspfile<\/h2>\n
create spfile from pfile='aaa.ora';<\/code><\/pre>\n
3.\u540c\u65f6\u4fee\u6539 dbname \u4ee5\u53ca dbid<\/h1>\n
3.1\u5168\u5907\u6570\u636e\u5e93<\/h2>\n
rman backup<\/code><\/pre>\n
3.2\u5907\u4efdspfile\u5230pfile<\/h2>\n
create pfile='\/tmp\/aaa.ora' from spfile;<\/code><\/pre>\n
3.3\u5c06\u6570\u636e\u5e93\u7f6e\u4e8emount\u72b6\u6001<\/h2>\n
startup mount<\/code><\/pre>\n
3.4\u67e5\u770b\u5f53\u524d\u6570\u636e\u7684dbid\u548cdbname<\/h2>\n
SQL> select dbid,name,open_mode from v$database;\n\n      DBID NAME      OPEN_MODE\n---------- --------- --------------------\n1589396777 COCO      MOUNTED<\/code><\/pre>\n
3.5 \u4fee\u6539dbname\u548cdbid<\/h2>\n
nid target=\/ dbname=CYB\n\n[oracle@oracle ~]$ nid target=\/ dbname=CYB\n\nDBNEWID: Release 11.2.0.4.0 - Production on Tue Jan 12 01:22:13 2021\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nConnected to database COCO (DBID=1589396777)\n\nConnected to server version 11.2.0\n\nControl Files in database:\n    \/u01\/app\/oracle\/oradata\/orcl\/control01.ctl\n    \/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl\n\nChange database ID and database name COCO to CYB? (Y\/[N]) => y\n\nProceeding with operation\nChanging database ID from 1589396777 to 2991861189\nChanging database name from COCO to CYB\n    Control File \/u01\/app\/oracle\/oradata\/orcl\/control01.ctl - modified\n    Control File \/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl - modified\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/system01.db - dbid changed, wrote new name\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/sysaux01.db - dbid changed, wrote new name\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/undotbs01.db - dbid changed, wrote new name\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/users01.db - dbid changed, wrote new name\n    Datafile \/u01\/app\/oracle\/oradata\/orcl\/temp01.db - dbid changed, wrote new name\n    Control File \/u01\/app\/oracle\/oradata\/orcl\/control01.ctl - dbid changed, wrote new name\n    Control File \/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl - dbid changed, wrote new name\n    Instance shut down\n\nDatabase name changed to CYB.\nModify parameter file and generate a new password file before restarting.\nDatabase ID for database CYB changed to 2991861189.\nAll previous backups and archived redo logs for this database are unusable.\nDatabase is not aware of previous backups and archived logs in Recovery Area.\nDatabase has been shutdown, open database with RESETLOGS option.\nSuccesfully changed database name and ID.\nDBNEWID - Completed succesfully.\n<\/code><\/pre>\n
3.6\u4fee\u6539pfile<\/h2>\n
db_name=cyb<\/code><\/pre>\n
3.7\u4f7f\u7528pifle\u542f\u52a8\u6570\u636e\u5e93<\/h2>\n
SQL> startup mount pfile='aaa.ora';\nORACLE instance started.\n\nTotal System Global Area  776646656 bytes\nFixed Size                  2257272 bytes\nVariable Size             507514504 bytes\nDatabase Buffers          264241152 bytes\nRedo Buffers                2633728 bytes\nDatabase mounted.\nSQL> alter database open\n  2  ;\nalter database open\nERROR at line 1:\nORA-01589: must use RESETLOGS or NORESETLOGS option for database open\n\nSQL> alter database open resetlogs;\nDatabase altered.<\/code><\/pre>\n
3.8\u67e5\u770b\u9a8c\u8bc1\u5f53\u524d\u6570\u636e\u7684dbid\u548cdbname<\/h2>\n
SQL> select dbid,name,open_mode from v$database;\n\n      DBID NAME      OPEN_MODE\n---------- --------- --------------------\n2991861189 CYB       READ WRITE\n--\u6821\u9a8c\u4fee\u4f3d\u540e\u7684\u72b6\u6001\uff0cdbid \u672a\u53d1\u751f\u53d8\u5316\uff0c\u4f46 dbname \u5df2\u7ecf\u88ab\u4fee\u6539<\/code><\/pre>\n
3.9\u91cd\u5efaspfile<\/h2>\n
create spfile from pfile;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
DBID\u662fDataBase IDentifier\u7684<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1376","post","type-post","status-publish","format-standard","hentry","category-oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1376"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1376\/revisions"}],"predecessor-version":[{"id":1377,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1376\/revisions\/1377"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1376"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}