{"id":310,"date":"2020-10-27T16:30:36","date_gmt":"2020-10-27T08:30:36","guid":{"rendered":"http:\/\/www.821121.com\/?p=310"},"modified":"2020-12-11T10:16:33","modified_gmt":"2020-12-11T02:16:33","slug":"%e6%96%b0%e7%89%b9%e6%80%a7%ef%bc%9acdb-pdb%e7%9a%84%e7%bb%b4%e6%8a%a4%e5%91%bd%e4%bb%a4%ef%bc%9a%e5%a4%87%e4%bb%bd%e4%b8%8e%e6%81%a2%e5%a4%8d%ef%bc%883%ef%bc%89%e5%a4%87%e4%bb%bd%e6%8e%a7%e5%88%b6","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=310","title":{"rendered":"\u65b0\u7279\u6027\uff1aCDB\/PDB\u7684\u7ef4\u62a4\u547d\u4ee4\uff1a\u5907\u4efd\u4e0e\u6062\u590d\uff083\uff09\u5907\u4efd\u63a7\u5236\u6587\u4ef6"},"content":{"rendered":"<h2>\u5907\u4efd\u63a7\u5236\u6587\u4ef6<\/h2>\n<pre><code class=\"language-sql\">[oracle@cat1 ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon May 2 22:20:21 2005\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL&gt; alter database backup controlfile to trace;\n\nDatabase altered.\n\nSQL&gt; select tracefile from v$process where addr in (\n  2  select paddr from v$session where sid = (select sid from v$mystat where rownum = 1));\n\nTRACEFILE\n--------------------------------------------------------------------------------\n\/u01\/app\/oracle\/diag\/rdbms\/whs1\/whs11\/trace\/whs11_ora_47143.trc\n\nSQL&gt; exit\nDisconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0<\/code><\/pre>\n<h2>\u67e5\u770b\u5907\u4efd\u5185\u5bb9<\/h2>\n<pre><code class=\"language-sql\">[oracle@cat1 trace]$ more \/u01\/app\/oracle\/diag\/rdbms\/whs1\/whs11\/trace\/whs11_ora_47143.trc\nTrace file \/u01\/app\/oracle\/diag\/rdbms\/whs1\/whs11\/trace\/whs11_ora_47143.trc\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\nBuild label:    RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417\nORACLE_HOME:    \/u01\/app\/oracle\/product\/19.3.0\/db_1\nSystem name:    Linux\nNode name:      cat1\nRelease:        3.10.0-957.el7.x86_64\nVersion:        #1 SMP Thu Oct 4 20:48:51 UTC 2018\nMachine:        x86_64\nInstance name: whs11\nRedo thread mounted by this instance: 1\nOracle process number: 71\nUnix process pid: 47143, image: oracle@cat1 (TNS V1-V3)\n\n*** 2005-05-02T22:49:15.238056+08:00 (CDB$ROOT(1))\n*** SESSION ID:(411.21562) 2005-05-02T22:49:15.238086+08:00\n*** CLIENT ID:() 2005-05-02T22:49:15.238090+08:00\n*** SERVICE NAME:(SYS$USERS) 2005-05-02T22:49:15.238094+08:00\n*** MODULE NAME:(sqlplus@cat1 (TNS V1-V3)) 2005-05-02T22:49:15.238097+08:00\n*** ACTION NAME:() 2005-05-02T22:49:15.238100+08:00\n*** CLIENT DRIVER:(SQL*PLUS) 2005-05-02T22:49:15.238102+08:00\n*** CONTAINER ID:(1) 2005-05-02T22:49:15.238105+08:00\n\n-- The following are current System-scope REDO Log Archival related\n-- parameters and can be included in the database initialization file.\n--\n-- LOG_ARCHIVE_DEST=''\n-- LOG_ARCHIVE_DUPLEX_DEST=''\n--\n-- LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf\n--\n-- DB_UNIQUE_NAME=\"whs1\"\n--\n-- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'\n-- LOG_ARCHIVE_MAX_PROCESSES=4\n-- STANDBY_FILE_MANAGEMENT=MANUAL\n-- FAL_CLIENT=''\n-- FAL_SERVER=''\n--\n-- LOG_ARCHIVE_DEST_1='LOCATION=+DATA1'\n-- LOG_ARCHIVE_DEST_1='MANDATORY NOREOPEN NODELAY'\n-- LOG_ARCHIVE_DEST_1='ARCH AFFIRM NOVERIFY SYNC'\n-- LOG_ARCHIVE_DEST_1='NOREGISTER'\n-- LOG_ARCHIVE_DEST_1='NOALTERNATE'\n-- LOG_ARCHIVE_DEST_1='NODEPENDENCY'\n-- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME'\n-- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'\n-- LOG_ARCHIVE_DEST_STATE_1=ENABLE\n--\n-- Below are two sets of SQL statements, each of which creates a new\n-- control file and uses it to open the database. The first set opens\n-- the database with the NORESETLOGS option and should be used only if\n-- the current versions of all online logs are available. The second\n-- set opens the database with the RESETLOGS option and should be used\n-- if online logs are unavailable.\n-- The appropriate set of statements can be copied from the trace into\n-- a script file, edited as necessary, and executed when there is a\n-- need to re-create the control file.\n--\n--     Set #1. NORESETLOGS case\n--\n-- The following commands will create a new control file and use it\n-- to open the database.\n-- Data used by Recovery Manager will be lost.\n-- Additional logs may be required for media recovery of offline\n-- Use this only if the current versions of all online logs are\n-- available.\n-- After mounting the created controlfile, the following SQL\n-- statement will place the database in the appropriate\n-- protection mode:\n--  ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE\nSTARTUP NOMOUNT\nCREATE CONTROLFILE REUSE DATABASE \"WHS1\" NORESETLOGS  ARCHIVELOG\n    MAXLOGFILES 192\n    MAXLOGMEMBERS 3\n    MAXDATAFILES 1024\n    MAXINSTANCES 32\n    MAXLOGHISTORY 292\nLOGFILE\n  GROUP 1 '+DATA1\/WHS1\/ONLINELOG\/group_1.262.1057318081'  SIZE 200M BLOCKSIZE 512,\n  GROUP 2 '+DATA1\/WHS1\/ONLINELOG\/group_2.263.1057318081'  SIZE 200M BLOCKSIZE 512,\n  GROUP 3 '+DATA1\/WHS1\/ONLINELOG\/group_3.270.1057318741'  SIZE 200M BLOCKSIZE 512,\n  GROUP 4 '+DATA1\/WHS1\/ONLINELOG\/group_4.271.1057318743'  SIZE 200M BLOCKSIZE 512\n-- STANDBY LOGFILE\nDATAFILE\n  '+DATA1\/WHS1\/DATAFILE\/system.257.1057317971',\n  '+DATA1\/WHS1\/DATAFILE\/sysaux.258.1057318005',\n  '+DATA1\/WHS1\/DATAFILE\/undotbs1.259.1057318021',\n  '+DATA1\/WHS1\/86B637B62FE07A65E053F706E80A27CA\/DATAFILE\/system.265.1057318247',\n  '+DATA1\/WHS1\/86B637B62FE07A65E053F706E80A27CA\/DATAFILE\/sysaux.266.1057318247',\n  '+DATA1\/WHS1\/DATAFILE\/users.260.1057318021',\n  '+DATA1\/WHS1\/86B637B62FE07A65E053F706E80A27CA\/DATAFILE\/undotb\n  ............................<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5907\u4efd\u63a7\u5236\u6587\u4ef6 [oracle@cat1 ~]$ s<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-310","post","type-post","status-publish","format-standard","hentry","category-oracle-12c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/310","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=310"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/310\/revisions"}],"predecessor-version":[{"id":311,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/310\/revisions\/311"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=310"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}