How To Restore 12cR1DB to New Host File System using RMAN(二)

容器数据库(CDB$ROOT)包含system,sysaux,undo和temp表空间,控制文件和redofile;
而种子数据库(PDB$SEED)包含system,sysaux,temp,example表空间,用来作为一个临时模板来创建新的插件库;
临时表空间对于所有的容器库都是必需的,但是每个插件数据库都拥有自己local用户(In a multitenant container database (CDB),
any user that is not )的临时表空间。每个插件库拥有system,sysaux,temp表空间,同时包含应用用户创建的数据表空间;

并且按照应用需要在插件数据库内创建应用数据表空间;写信息到容器库的undo表空间和控制文件和redo文件。并且按照应用需要在插件数据库内创建应用数据表空间;
所有的在同一个容器库的插件库都共享归档模式。
每个容器库最多容纳253个插件数据库(包括种子库),512个service;

先看看备份:
RMAN> report schema;

using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name PRD12CDB

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    790      SYSTEM               ***     /data01/1.dbf     ----->container db
3    2730     SYSAUX               ***     /data01/3.dbf     ----->container db
4    260      UNDOTBS1             ***     /data01/4.dbf     ----->container db
5    260      PDB$SEED:SYSTEM      ***     /data01/5.dbf     ----->container db
6    5        USERS                ***     /data01/6.dbf     ----->container db
7    640      PDB$SEED:SYSAUX      ***     /data01/7.dbf     ----->container db
8    75       UNDOTBS2             ***     /data01/8.dbf     ----->container db
9    270      ZSKMSDB:SYSTEM       ***     /data01/9.dbf     ----->pdb
10   690      ZSKMSDB:SYSAUX       ***     /data01/10.dbf
11   5        ZSKMSDB:USERS        ***     /data01/11.dbf
12   270      OSSPORTALDB:SYSTEM   ***     /data01/12.dbf
13   690      OSSPORTALDB:SYSAUX   ***     /data01/13.dbf
16   10240    ZSKMSDB:RESALE_DATA  ***     /data01/16.dbf
17   100      ZSKMSDB:JTITSM       ***     /data01/17.dbf
18   100      OSSPORTALDB:JTITSM   ***     /data01/18.dbf
19   2048     ZSKMSDB:SYSTEM       ***     /data01/19.dbf
20   2048     ZSKMSDB:SYSAUX       ***     /data01/20.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    60       TEMP                 32767       /data01/PRD12CDB/datafile/o1_mf_temp_9rf9626t_.tmp
2    20       PDB$SEED:TEMP        32767       +SYSDATA/PRD12CDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/pdbseed_temp01.dbf
3    20       ZSKMSDB:TEMP         32767       /data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/datafile/o1_mf_temp_9rf96cpk_.tmp
4    20       OSSPORTALDB:TEMP     32767       /data01/PRD12CDB/F6ACE29ECAE0576BE0430254800A9CD6/datafile/o1_mf_temp_9rf96dmk_.tmp

完全cdb备份:
[oracle@orat3 ~]$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Jun 4 12:55:57 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRD12CDB (DBID=3299715205)

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE  ALL  INPUT; 


Starting backup at 04-JUN-14
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=9238 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=111 STAMP=849129262
input archived log thread=2 sequence=1 RECID=110 STAMP=848833726
input archived log thread=1 sequence=2 RECID=112 STAMP=849358461
input archived log thread=1 sequence=3 RECID=113 STAMP=849358565
channel ORA_DISK_1: starting piece 1 at 04-JUN-14
channel ORA_DISK_1: finished piece 1 at 04-JUN-14
piece handle=/data01/PRD12CDB/backupset/2014_06_04/o1_mf_annnn_TAG20140604T125605_9rx9q645_.bkp tag=TAG20140604T125605 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_06_01/o1_mf_1_1_9rp9s6v3_.arc RECID=111 STAMP=849129262
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_1_9rf95yqn_.arc RECID=110 STAMP=848833726
archived log file name=/data01/PRD12CDB/archivelog/2014_06_04/o1_mf_1_2_9rx9mqt7_.arc RECID=112 STAMP=849358461
archived log file name=/data01/PRD12CDB/archivelog/2014_06_04/o1_mf_1_3_9rx9q59t_.arc RECID=113 STAMP=849358565
Finished backup at 04-JUN-14

Starting backup at 04-JUN-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00016 name=/data01/16.dbf
input datafile file number=00019 name=/data01/19.dbf
input datafile file number=00020 name=/data01/20.dbf
input datafile file number=00010 name=/data01/10.dbf
input datafile file number=00009 name=/data01/9.dbf
input datafile file number=00017 name=/data01/17.dbf
input datafile file number=00011 name=/data01/11.dbf
channel ORA_DISK_1: starting piece 1 at 04-JUN-14
channel ORA_DISK_1: finished piece 1 at 04-JUN-14
piece handle=/data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9qzvy_.bkp tag=TAG20140604T125631 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/data01/3.dbf
input datafile file number=00001 name=/data01/1.dbf
input datafile file number=00004 name=/data01/4.dbf
input datafile file number=00008 name=/data01/8.dbf
input datafile file number=00006 name=/data01/6.dbf
channel ORA_DISK_1: starting piece 1 at 04-JUN-14
channel ORA_DISK_1: finished piece 1 at 04-JUN-14
piece handle=/data01/PRD12CDB/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9s32p_.bkp tag=TAG20140604T125631 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00013 name=/data01/13.dbf
input datafile file number=00012 name=/data01/12.dbf
input datafile file number=00018 name=/data01/18.dbf
channel ORA_DISK_1: starting piece 1 at 04-JUN-14
channel ORA_DISK_1: finished piece 1 at 04-JUN-14
piece handle=/data01/PRD12CDB/F6ACE29ECAE0576BE0430254800A9CD6/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9tt7l_.bkp tag=TAG20140604T125631 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/data01/7.dbf
input datafile file number=00005 name=/data01/5.dbf
channel ORA_DISK_1: starting piece 1 at 04-JUN-14
channel ORA_DISK_1: finished piece 1 at 04-JUN-14
piece handle=/data01/PRD12CDB/F6AC7D86579C49A9E0430254800A174B/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9v9c5_.bkp tag=TAG20140604T125631 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 04-JUN-14

Starting backup at 04-JUN-14
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=114 STAMP=849358712
channel ORA_DISK_1: starting piece 1 at 04-JUN-14
channel ORA_DISK_1: finished piece 1 at 04-JUN-14
piece handle=/data01/PRD12CDB/backupset/2014_06_04/o1_mf_annnn_TAG20140604T125832_9rx9vrml_.bkp tag=TAG20140604T125832 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_06_04/o1_mf_1_4_9rx9vrfy_.arc RECID=114 STAMP=849358712
Finished backup at 04-JUN-14

Starting Control File and SPFILE Autobackup at 04-JUN-14
piece handle=/bak/orabakdata/controlfile/controlc-3299715205-20140604-00 comment=NONE
Finished Control File and SPFILE Autobackup at 04-JUN-14

RMAN> BACKUP PLUGGABLE DATABASE ZSKMSDB  TAG '12cZSKMSDB_pdb';

Starting backup at 04-JUN-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00016 name=/data01/16.dbf
input datafile file number=00019 name=/data01/19.dbf
input datafile file number=00020 name=/data01/20.dbf
input datafile file number=00010 name=/data01/10.dbf
input datafile file number=00009 name=/data01/9.dbf
input datafile file number=00017 name=/data01/17.dbf
input datafile file number=00011 name=/data01/11.dbf
channel ORA_DISK_1: starting piece 1 at 04-JUN-14
channel ORA_DISK_1: finished piece 1 at 04-JUN-14
piece handle=/data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/backupset/2014_06_04/o1_mf_nnndf_12CZSKMSDB_PDB_9rxbfrgz_.bkp tag=12CZSKMSDB_PDB comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 04-JUN-14

Starting Control File and SPFILE Autobackup at 04-JUN-14
piece handle=/bak/orabakdata/controlfile/controlc-3299715205-20140604-01 comment=NONE
Finished Control File and SPFILE Autobackup at 04-JUN-14

 

RMAN>  LIST BACKUP OF DATABASE;


List of Backup Sets
===================


BS Key  Type LV Size
------- ---- -- ----------
196     Incr 0  2.04M
  List of Datafiles in backup set 196
  Container ID: 3, PDB Name: ZSKMSDB
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  17   0  Incr 7411633    25-MAY-14 /data01/17.dbf
  19   0  Incr 7411633    25-MAY-14 /data01/19.dbf

  Backup Set Copy #1 of backup set 196
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 196 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    196     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449818-198-1.dbf

  Backup Set Copy #2 of backup set 196
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 196 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    226     1   AVAILABLE   /data01/bak/bak/d-20140525-848449818-198-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
197     Incr 0  3.51M
  List of Datafiles in backup set 197
  Container ID: 3, PDB Name: ZSKMSDB
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  11   0  Incr 7411635    25-MAY-14 /data01/11.dbf
  20   0  Incr 7411635    25-MAY-14 /data01/20.dbf

  Backup Set Copy #1 of backup set 197
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 197 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    197     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449818-199-1.dbf

  Backup Set Copy #2 of backup set 197
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 197 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    230     1   AVAILABLE   /data01/bak/bak/d-20140525-848449818-199-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
198     Incr 0  672.11M
  List of Datafiles in backup set 198
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 7411637    25-MAY-14 /data01/1.dbf

  Backup Set Copy #1 of backup set 198
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:08     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 198 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    198     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449820-201-1.dbf

  Backup Set Copy #2 of backup set 198
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:08     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 198 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    231     1   AVAILABLE   /data01/bak/bak/d-20140525-848449820-201-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
199     Incr 0  69.59M
  List of Datafiles in backup set 199
  Container ID: 3, PDB Name: ZSKMSDB
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  16   0  Incr 7411631    25-MAY-14 /data01/16.dbf

  Backup Set Copy #1 of backup set 199
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:11     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 199 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    199     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449817-196-1.dbf

  Backup Set Copy #2 of backup set 199
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:11     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 199 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    229     1   AVAILABLE   /data01/bak/bak/d-20140525-848449817-196-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
200     Incr 0  548.52M
  List of Datafiles in backup set 200
  Container ID: 4, PDB Name: OSSPORTALDB
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  13   0  Incr 7411639    25-MAY-14 /data01/13.dbf

  Backup Set Copy #1 of backup set 200
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:11     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 200 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    200     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449820-202-1.dbf

  Backup Set Copy #2 of backup set 200
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:11     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 200 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    234     1   AVAILABLE   /data01/bak/bak/d-20140525-848449820-202-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
201     Incr 0  769.01M
  List of Datafiles in backup set 201
  Container ID: 3, PDB Name: ZSKMSDB
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9    0  Incr 7411636    25-MAY-14 /data01/9.dbf
  10   0  Incr 7411636    25-MAY-14 /data01/10.dbf

  Backup Set Copy #1 of backup set 201
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:14     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 201 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    201     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449819-200-1.dbf

  Backup Set Copy #2 of backup set 201
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:14     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 201 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    232     1   AVAILABLE   /data01/bak/bak/d-20140525-848449819-200-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
202     Incr 0  531.05M
  List of Datafiles in backup set 202
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7    0  Incr 1921022    10-APR-14 /data01/7.dbf

  Backup Set Copy #1 of backup set 202
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:12     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 202 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    202     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449821-203-1.dbf

  Backup Set Copy #2 of backup set 202
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:12     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 202 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    228     1   AVAILABLE   /data01/bak/bak/d-20140525-848449821-203-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
203     Incr 0  1.03M
  List of Datafiles in backup set 203
  Container ID: 4, PDB Name: OSSPORTALDB
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  18   0  Incr 7411656    25-MAY-14 /data01/18.dbf

  Backup Set Copy #1 of backup set 203
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 203 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    203     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449833-207-1.dbf

  Backup Set Copy #2 of backup set 203
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 203 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    243     1   AVAILABLE   /data01/bak/bak/d-20140525-848449833-207-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
204     Incr 0  209.90M
  List of Datafiles in backup set 204
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1921022    10-APR-14 /data01/5.dbf

  Backup Set Copy #1 of backup set 204
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 204 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    204     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449832-206-1.dbf

  Backup Set Copy #2 of backup set 204
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 204 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    246     1   AVAILABLE   /data01/bak/bak/d-20140525-848449832-206-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
205     Incr 0  15.74M
  List of Datafiles in backup set 205
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  8    0  Incr 7411657    25-MAY-14 /data01/8.dbf

  Backup Set Copy #1 of backup set 205
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 205 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    205     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449833-208-1.dbf

  Backup Set Copy #2 of backup set 205
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 205 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    227     1   AVAILABLE   /data01/bak/bak/d-20140525-848449833-208-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
206     Incr 0  1.34M
  List of Datafiles in backup set 206
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6    0  Incr 7411660    25-MAY-14 /data01/6.dbf

  Backup Set Copy #1 of backup set 206
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 206 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    206     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449834-209-1.dbf

  Backup Set Copy #2 of backup set 206
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 206 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    225     1   AVAILABLE   /data01/bak/bak/d-20140525-848449834-209-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
207     Incr 0  2.13G
  List of Datafiles in backup set 207
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 7411632    25-MAY-14 /data01/3.dbf

  Backup Set Copy #1 of backup set 207
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:19     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 207 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    207     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449817-197-1.dbf

  Backup Set Copy #2 of backup set 207
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:19     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 207 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    241     1   AVAILABLE   /data01/bak/bak/d-20140525-848449817-197-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
208     Incr 0  20.71M
  List of Datafiles in backup set 208
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 7411652    25-MAY-14 /data01/4.dbf

  Backup Set Copy #1 of backup set 208
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 208 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    208     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449829-205-1.dbf

  Backup Set Copy #2 of backup set 208
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 208 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    244     1   AVAILABLE   /data01/bak/bak/d-20140525-848449829-205-1.dbf

BS Key  Type LV Size
------- ---- -- ----------
209     Incr 0  216.70M
  List of Datafiles in backup set 209
  Container ID: 4, PDB Name: OSSPORTALDB
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  12   0  Incr 7411649    25-MAY-14 /data01/12.dbf

  Backup Set Copy #1 of backup set 209
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:08     25-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 209 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    209     1   EXPIRED     /bak/orabakdata/backupdata/d-20140525-848449829-204-1.dbf

  Backup Set Copy #2 of backup set 209
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:08     29-MAY-14       NO         HOT_DB_BK_LEVEL0

    List of Backup Pieces for backup set 209 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    242     1   AVAILABLE   /data01/bak/bak/d-20140525-848449829-204-1.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
229     Full    845.80M    DISK        00:00:32     04-JUN-14     
        BP Key: 253   Status: AVAILABLE  Compressed: NO  Tag: TAG20140604T125631
        Piece Name: /data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9qzvy_.bkp
  List of Datafiles in backup set 229
  Container ID: 3, PDB Name: ZSKMSDB
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9       Full 8216714    04-JUN-14 /data01/9.dbf
  10      Full 8216714    04-JUN-14 /data01/10.dbf
  11      Full 8216714    04-JUN-14 /data01/11.dbf
  16      Full 8216714    04-JUN-14 /data01/16.dbf
  17      Full 8216714    04-JUN-14 /data01/17.dbf
  19      Full 8216714    04-JUN-14 /data01/19.dbf
  20      Full 8216714    04-JUN-14 /data01/20.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
230     Full    3.03G      DISK        00:00:54     04-JUN-14     
        BP Key: 254   Status: AVAILABLE  Compressed: NO  Tag: TAG20140604T125631
        Piece Name: /data01/PRD12CDB/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9s32p_.bkp
  List of Datafiles in backup set 230
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 8216727    04-JUN-14 /data01/1.dbf
  3       Full 8216727    04-JUN-14 /data01/3.dbf
  4       Full 8216727    04-JUN-14 /data01/4.dbf
  6       Full 8216727    04-JUN-14 /data01/6.dbf
  8       Full 8216727    04-JUN-14 /data01/8.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
231     Full    766.41M    DISK        00:00:13     04-JUN-14     
        BP Key: 255   Status: AVAILABLE  Compressed: NO  Tag: TAG20140604T125631
        Piece Name: /data01/PRD12CDB/F6ACE29ECAE0576BE0430254800A9CD6/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9tt7l_.bkp
  List of Datafiles in backup set 231
  Container ID: 4, PDB Name: OSSPORTALDB
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  12      Full 8216749    04-JUN-14 /data01/12.dbf
  13      Full 8216749    04-JUN-14 /data01/13.dbf
  18      Full 8216749    04-JUN-14 /data01/18.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
232     Full    740.93M    DISK        00:00:14     04-JUN-14     
        BP Key: 256   Status: AVAILABLE  Compressed: NO  Tag: TAG20140604T125631
        Piece Name: /data01/PRD12CDB/F6AC7D86579C49A9E0430254800A174B/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9v9c5_.bkp
  List of Datafiles in backup set 232
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 1921022    10-APR-14 /data01/5.dbf
  7       Full 1921022    10-APR-14 /data01/7.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
235     Full    845.90M    DISK        00:00:11     04-JUN-14     
        BP Key: 259   Status: AVAILABLE  Compressed: NO  Tag: 12CZSKMSDB_PDB
        Piece Name: /data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/backupset/2014_06_04/o1_mf_nnndf_12CZSKMSDB_PDB_9rxbfrgz_.bkp
  List of Datafiles in backup set 235
  Container ID: 3, PDB Name: ZSKMSDB-----这里就是pdb ZSKMSDB的备份!
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9       Full 8220311    04-JUN-14 /data01/9.dbf
  10      Full 8220311    04-JUN-14 /data01/10.dbf
  11      Full 8220311    04-JUN-14 /data01/11.dbf
  16      Full 8220311    04-JUN-14 /data01/16.dbf
  17      Full 8220311    04-JUN-14 /data01/17.dbf
  19      Full 8220311    04-JUN-14 /data01/19.dbf
  20      Full 8220311    04-JUN-14 /data01/20.dbf

通过guid类识别:
SQL> SET LINES 150
SQL> SELECT CON_ID, DBID, CON_UID, GUID, NAME FROM v$pdbs;

    CON_ID       DBID    CON_UID GUID                             NAME
---------- ---------- ---------- -------------------------------- ------------------------------
         2 4087144141 4087144141 F6AC7D86579C49A9E0430254800A174B PDB$SEED
         3 3158352855 3158352855 F6ACAF06A0755467E0430254800A2839 ZSKMSDB
         4 2712832312 2712832312 F6ACE29ECAE0576BE0430254800A9CD6 OSSPORTALDB

备份某个pdb的表空间:
RMAN> BACKUP TABLESPACE  ZSKMSDB:system,sysaux;  

Starting backup at 04-JUN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3088 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/data01/3.dbf
channel ORA_DISK_1: starting piece 1 at 04-JUN-14
channel ORA_DISK_1: finished piece 1 at 04-JUN-14
piece handle=/data01/PRD12CDB/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T132426_9rxcdbdg_.bkp tag=TAG20140604T132426 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00019 name=/data01/19.dbf
input datafile file number=00009 name=/data01/9.dbf
channel ORA_DISK_1: starting piece 1 at 04-JUN-14
channel ORA_DISK_1: finished piece 1 at 04-JUN-14
piece handle=/data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T132426_9rxcffkz_.bkp tag=TAG20140604T132426 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 04-JUN-14

Starting Control File and SPFILE Autobackup at 04-JUN-14
piece handle=/bak/orabakdata/controlfile/controlc-3299715205-20140604-02 comment=NONE
Finished Control File and SPFILE Autobackup at 04-JUN-14

RMAN>

恢复测试:
[root@orat3 ~]# cd /data01
[root@orat3 data01]# ls
10.dbf  12.dbf  16.dbf  18.dbf  1.dbf   3.dbf  5.dbf  7.dbf  9.dbf  current.256.844530693  lost+found  PROD12C
11.dbf  13.dbf  17.dbf  19.dbf  20.dbf  4.dbf  6.dbf  8.dbf  bak    current.261.844530693  PRD12CDB
[root@orat3 data01]# rm 9.dbf
rm: remove regular file `9.dbf'? y
[root@orat3 data01]# rm 10.dbf
rm: remove regular file `10.dbf'? y
[root@orat3 data01]#
[root@orat3 data01]#
[root@orat3 data01]# ls
11.dbf  13.dbf  17.dbf  19.dbf  20.dbf  4.dbf  6.dbf  8.dbf  current.256.844530693  lost+found  PROD12C
12.dbf  16.dbf  18.dbf  1.dbf   3.dbf   5.dbf  7.dbf  bak    current.261.844530693  PRD12CDB
[root@orat3 data01]#

SQL> shut abort
startupORACLE instance shut down.

SQL>


ORACLE instance started.

Total System Global Area 4.0486E+10 bytes
Fixed Size                  2692048 bytes
Variable Size            6979324976 bytes
Database Buffers         3.3420E+10 bytes
Redo Buffers               84176896 bytes


Database mounted.
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/data01/9.dbf'


SQL> SQL> SQL> SQL> SQL> SQL>
SQL>
SQL> show padbs;
SP2-0158: unknown SHOW option "padbs"
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 ZSKMSDB                        MOUNTED
         4 OSSPORTALDB                    MOUNTED
SQL> alter PLUGGABLE database all open;
alter PLUGGABLE database all open
*
ERROR at line 1:
ORA-01109: database not open


SQL>

恢复:

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Jun 4 13:31:08 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRD12CDB (DBID=3299715205, not open)

RMAN>  RESTORE TABLESPACE system;;

Starting restore at 04-JUN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /data01/1.dbf
channel ORA_DISK_1: reading from backup piece /data01/PRD12CDB/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9s32p_.bkp
channel ORA_DISK_1: piece handle=/data01/PRD12CDB/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T125631_9rx9s32p_.bkp tag=TAG20140604T125631
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
Finished restore at 04-JUN-14

RMAN> recover tablespace system;

Starting recover at 04-JUN-14
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 04-JUN-14

RMAN> RESTORE TABLESPACE sysaux;

Starting restore at 04-JUN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1543 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /data01/3.dbf
channel ORA_DISK_1: reading from backup piece /data01/PRD12CDB/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T132426_9rxcdbdg_.bkp
 recover tablespace sysaux;

 

channel ORA_DISK_1: piece handle=/data01/PRD12CDB/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T132426_9rxcdbdg_.bkp tag=TAG20140604T132426
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 04-JUN-14

RMAN>
Starting recover at 04-JUN-14
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 04-JUN-14

报错仍然:
startup
SQL>
ORACLE instance started.

Total System Global Area 4.0486E+10 bytes
Fixed Size                  2692048 bytes
Variable Size            6979324976 bytes
Database Buffers         3.3420E+10 bytes
Redo Buffers               84176896 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/data01/9.dbf'
---这里默认是恢复的容器库的表空间。
加pdbname重新恢复:
RMAN> RESTORE TABLESPACE  ZSKMSDB:system,sysaux; 

Starting restore at 04-JUN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /data01/3.dbf
channel ORA_DISK_1: reading from backup piece /data01/PRD12CDB/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T132426_9rxcdbdg_.bkp
channel ORA_DISK_1: piece handle=/data01/PRD12CDB/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T132426_9rxcdbdg_.bkp tag=TAG20140604T132426
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00009 to /data01/9.dbf
channel ORA_DISK_1: restoring datafile 00019 to /data01/19.dbf
channel ORA_DISK_1: reading from backup piece /data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T132426_9rxcffkz_.bkp
channel ORA_DISK_1: piece handle=/data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/backupset/2014_06_04/o1_mf_nnndf_TAG20140604T132426_9rxcffkz_.bkp tag=TAG20140604T132426
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 04-JUN-14

RMAN> recover  TABLESPACE  ZSKMSDB:system,sysaux; 

Starting recover at 04-JUN-14
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 04-JUN-14

RMAN>

RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-03135: connection lost contact
Process ID: 30684
Session ID: 10775 Serial number: 11

RMAN>

RMAN>

RMAN> exit


Recovery Manager complete.
[oracle@orat3 ~]$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Wed Jun 4 13:43:10 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRD12CDB (DBID=3299715205, not open)

RMAN> RESTORE TABLESPACE  ZSKMSDB:sysaux; 

Starting restore at 04-JUN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00010 to /data01/10.dbf
channel ORA_DISK_1: restoring datafile 00020 to /data01/20.dbf
channel ORA_DISK_1: reading from backup piece /data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/backupset/2014_06_04/o1_mf_nnndf_12CZSKMSDB_PDB_9rxbfrgz_.bkp
channel ORA_DISK_1: piece handle=/data01/PRD12CDB/F6ACAF06A0755467E0430254800A2839/backupset/2014_06_04/o1_mf_nnndf_12CZSKMSDB_PDB_9rxbfrgz_.bkp tag=12CZSKMSDB_PDB
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 04-JUN-14

RMAN>  recover  TABLESPACE  ZSKMSDB:sysaux;

Starting recover at 04-JUN-14
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 04-JUN-14

RMAN>


SQL> startup force;
ORACLE instance started.

Total System Global Area 4.0486E+10 bytes
Fixed Size                  2692048 bytes
Variable Size            6979324976 bytes
Database Buffers         3.3420E+10 bytes
Redo Buffers               84176896 bytes
Database mounted.
Database opened.
SQL>
Pdb数据文件恢复同上,这里不再说明,现在看看整个pdb的恢复:
删除pdb:
SQL> drop PLUGGABLE database ZSKMSDB;

Pluggable database dropped.
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         4 OSSPORTALDB                    MOUNTED
SQL>
只能全容器库恢复了:

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13750068/viewspace-1176187/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-1176187/

Ubuntu 14.04下MongoDB备份避坑指南:为什么不能用cp/rsync MongoDB备份本质是获取数据库在某一时刻的一致性状态,而非简单复制文件。其核心原理依赖存储引擎(如mmapv1)的事务日志(journal)与数据文件强一致性,以及oplog机制保障副本集数据同步。技术价值在于实现RPO≈0的可靠恢复能力,避免静默数据丢失。典型应用场景包括老旧系统(如Ubuntu 14.04)迁移、灾备演练和生产环境定期备份。本文聚焦mmapv1引擎下cp/rsync导致journal错位、索引损坏等风险,并详解mongodump/mongorestore配合--oplog、--dro 阅读详情

相关推荐

龙芯3B6000平台部署Docker 29.5.1:从环境准备到生产实践

在龙芯 3B6000 这样的国产自主 CPU 架构上部署 Docker,尤其是安装较新的 29.5.1 版本,会遇到与 x86_64 或 ARM64 平台截然不同的依赖、包管理和兼容性问题。龙芯平台基于 MIPS64 架构,其软件生态主要依赖 Loongnix、UOS、Kylin 等国产操作系统,这些系统通常使用 RPM 包管理。直接从 Docker 官方仓库下载的二进制包或通用 RPM 包往往无法直接运行,需要寻找或编译适配龙芯架构的版本。本文将详细讲解在龙芯 3B6000 平台上,如何从零开始准备环境、

weixin_33700350的博客 460

Oracle如何实现创建数据库、备份数据库及数据导出导入的一条龙操作

Oracle中对数据对象和数据的管理,无疑都是使用PL/SQL Developer来进行管理,该工具也提供给我们很多方便、快捷的操作,使得我们不再为Oracle本身丑陋、难用的UI而抱怨。由于我们一般都是建建表、查查数据的操作居多,较少会考虑系统的整个Oracle的完整备份操作。但是在我们一些发布操作中,我们必须考虑如何把Oracle的对象、表数据导出到Sql脚本中,并且把创建Oracle表空间、...

weixin_33863087的博客 1510

Claude-Code CLI:本地化AI编程助手的工程化实践

命令行AI编程工具正从‘交互玩具’迈向可嵌入CI/CD的工程基础设施。其核心在于将大模型能力封装为符合POSIX规范的CLI程序,依托MCP(Model Communication Protocol)实现模型与工具解耦,并通过Rust编译的Native Binary保障跨平台启动性能与环境隔离性。这类工具不再依赖浏览器或IDE插件,而是以标准输入输出、确定性退出码和管道流支持自动化流水线集成,适用于代码审查、技术债扫描、Git Hooks增强等真实开发场景。Claude-Code CLI正是这一范式的典型代

aqc802886的博客 465

奇怪的事情又来了--从sqlplus里不能启动oracle.

奇怪的事情又来了--从sqlplus里不能启动oracle.什么原因?

henrybai的专栏--大亨利白--大码 2729

龙芯3B6000+AnolisOS 23.4部署Docker实战:从安装到容器创建深度排错

在实际国产化替代和信创项目中,龙芯平台上的软件适配与部署是开发者必须面对的关键环节。龙芯 3B6000 作为新一代国产处理器,搭配 AnolisOS 23.4(一个兼容 CentOS/RHEL 生态的国产操作系统),构成了一个典型的生产环境。然而,当开发者试图通过系统默认仓库安装 Docker 并创建容器时,往往会遇到一系列意料之外的障碍,例如依赖冲突、内核模块缺失、容器启动失败等。这些问题并非简单的命令错误,而是涉及底层架构适配、软件源兼容性、内核配置等多个层面的综合挑战。 本文旨在为需要在龙芯 3B60

weixin_34413103的博客 404

【信息科学与工程学】信息科学领域工程——第十一篇 数据库基础101 数据库内核02

OceanBase、GaussDB、PolarDB 三家对比,新增 15 个编号(OB‑171 至 OB‑185),覆盖 LSM-Tree 优化、MOT 内存表、Serverless 弹性连接池、并行 DDL、AI 原生优化器、HTAP 行列混合、全局索引在线维护、自适应日志压缩、分布式快照隔离、异步索引创建、智能参数调优、跨地域灾备、并行聚集、SQL 防火墙增强、向量化窗口函数等模块。严格保持 10 列格式,每项含逐步数学推导和 C/C++/Rust 伪代码。编号类型领域数据库产品及版本内核类型内核中的函

weixin_49199313的博客 23

spfile rman时找不到,重建办法

---spfile 重启自动改变----

jnrjian的博客 1031

【信息科学与工程学】信息科学领域工程——第十一篇 数据库基础101 数据库内核01

让修改聚集:通过 Range 分区(按时间)+ Hash 二级分区,让增量数据在物理上聚集,最小化 ρ让复用生效:确保使用增量合并(默认),避免不必要的全量合并;DDL 操作后使用渐进合并让节奏匹配:根据业务负载调整,并启用自适应合并让迁移智能:使用 OMS + 旁路导入 + 分区交换,迁移期间临时删索引、打散 Leader让架构帮忙:在 V4.x 共享存储架构下,利用宏块级重用 + 基线数据共享,从架构层面消除迁移写放大。

weixin_49199313的博客 25

Oracle 12c Data Guard 搭建

Oracle 12c 的DataGuard 是在CDB 级别进行的,所以我们的配置都是从CDB角度出发。 测试里主备库的数据库CDB名称相同。 1 环境说明 OS Version: [root@dg1 yum.repos.d]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.3 (Maipo) [root...

leo__1990的博客 1054

【信息科学与工程学】【数据中心】第三十五篇 云计算数据中心的学科知识04

编号学科(课程)核心知识点在云计算/云存储/云网络/云安全/云MaaS中的作用代表教材/资料/论文 + 数学方程式列表工业界应用D1421​云原生数据库:TiDB​HTAP(混合事务/分析处理)、分布式SQL、水平扩展、强一致(Raft)、自动故障恢复、与MySQL兼容、TiFlash列式引擎提供弹性扩展的分布式数据库;支撑高并发在线交易与实时分析教材:《TiDB in Action》PingCAP(2020) 论文:《TiDB: A Raft-based HTAP Database》(2017)

weixin_49199313的博客 417

【信息科学与工程学】计算机科学与自动化-——第十五篇云计算 12 公有云里的“多Region + 多AZ“ 02 运营算法01

算法逐步思考推理思考(含数学方程式、对象、资源、任务、进程/协程/线程及对应的代数、约束、目标函数/传递函数/依赖函数、参数及参数的数值范围及边界条件、逐步推理的数学方程式列表、上下文切换、并发/串行/随机/乱序/顺序)算法逐步思考推理思考(含数学方程式、对象、资源、任务、进程/协程/线程及对应的代数、约束、目标函数/传递函数/依赖函数、参数及参数的数值范围及边界条件、逐步推理的数学方程式列表、上下文切换、并发/串行/随机/乱序/顺序)云厂商提高闲置资源利用率。算法复杂度为O(N),N为实例数量。

weixin_49199313的博客 287

How To Restore 12cR1DB to New Host File System using RMAN(一)

oracle 12cr1 异机恢复; oracle 12cr1备份目前nbu不支持,所以主机写sh包含rman,然后放到crontab里变定期跑备份到本地文件目录; [root@uccpdb2...

173

【信息科学与工程学】计算机科学与自动化——第三百零四篇 高性能系统开发指南06

376: 分布式配置中心+配置加密+密钥管理+自动轮换+审计+回滚+健康检查+灰度+多集群+多租户+配置漂移检测+自动修复+合规+联邦学习+混沌工程+事件驱动+多语言SDK+配置可视化+配置模板+变量替换+配置对比+差异可视化+配置导入导出+配置订阅+WebHook+配置权限管理+RBAC+配置标签+配置搜索+配置依赖图+配置影响分析+配置历史趋势+配置预测+配置自动生成+配置推荐+配置健康评分+配置自愈+配置拓扑+配置热加载。故障恢复时,从上一个完成的checkpoint恢复,未提交的文件被丢弃。

weixin_49199313的博客 266

龙芯3B6000服务器安装Docker 29.5.1全攻略:从源码编译到生产部署

在国产化替代和信创浪潮下,龙芯平台的应用部署成为许多开发者和运维工程师必须面对的课题。Docker 作为现代应用部署的基石,其高版本(如 29.5.1)带来了性能提升、安全加固和新特性支持,但在龙芯 3B6000 这类 LoongArch 架构的平台上,通过官方仓库直接安装 Docker 通常无法获取到最新版本,甚至可能没有预编译的二进制包。本文将手把手带你完成在龙芯 3B6000 服务器上,通过 RPM 包离线或在线方式,成功安装 Docker Engine 29.5.1 版本的全过程,涵盖从环境准备、依

472

【信息科学与工程学】计算机科学与自动化 第二百三十三篇 凤凰架构01

编号类型领域系统软件/硬件或系统集成方案及系统架构模块子模块函数名称/算法名称算法的数学分析及计算机体系架构及数据结构与算法详细设计及参数列表及数值范围设计关联知识1共识算法分布式基石状态机复制架构:Proposer/Acceptor/Learner 多节点角色模型,基于操作转移(Operation Transfer)分布式共识PaxosPaxos 协议(Prepare/Promise/Accept/Accepted 两阶段)数学基础:多数派(Quorum)投票,基于鸽巢原理保证 W+R>N 时读写集合必有

weixin_49199313的博客 268

il2cpp分析-gobal-metadata.dat解密

打开ida,把libil2cpp拖到ida中按快捷键Shift+F12等待字符串分析完后,搜索global-metadata.dat。ida中双击sub_57EE7C进入,VS code中也跳转到LoadMetadataFile函数。VSCode打开il2cpp源代码,全局搜索global-metadata.dat。工具:010Editor,IDA 7.5,Jadx,VS Code。判断加密逻辑为根据文件的长度循环读取字节码做亦或加密。双击搜索出来的结果,切记要选il2cpp目录下的。

Android_machong的博客 8026

WebGoat2026年版本(全10个模块另附其他模块)通关教程

本文简要介绍了WebGoat安全测试平台的部署和使用方法。主要内容包括:1)环境配置(Java23+Maven3.9.11)和启动步骤;2)HTTP基础任务,通过BurpSuite抓包分析POST请求;3)HTTP代理任务,要求修改请求方法和添加特定头信息;4)开发者工具任务,使用控制台获取随机数和网络请求中的数值;5)CIA三要素测验题。文章提供了具体操作截图和Python请求示例,帮助读者完成各项安全测试任务,适合作为Web应用安全测试的实操参考手册。

csdnkazusa的博客 1373

TSMC40nmLP版图实战:从Design Rule解读到Cadence高效布局布线

本文详细解析了TSMC40nmLP工艺的版图设计实战,从Design Rule解读到Cadence高效布局布线技巧。重点介绍了40nm工艺中的关键设计规则,如最小线宽、间距规则和深N阱规则,并分享了Cadence Virtuoso中的高效工作流和射频模块设计技巧,帮助工程师提升版图设计效率和质量。

weixin_29250403的博客 380

K8s 核心组件使用指南

Kubeadm是一个提供了和的工具, 作为创建Kubernetes集群的 “快捷途径” 的最佳实践。kubeadm通过执行必要的操作来启动和运行最小可用集群。按照设计,它只关注启动引导,而非配置机器。同样的, 安装各种 “锦上添花” 的扩展,例如 Kubernetes Dashboard、 监控方案、以及特定云平台的扩展,都不在讨论范围内。相反,k8s官方希望在kubeadm之上构建更高级别以及更加合规的工具, 理想情况下,使用kubeadm作为所有部署工作的基准将会更加易于创建一致性集群。

nRks5Qp11的博客 216

【重启后nvidia-smi 命令出现错误】

NVIDIA-SMI has failed because it couldn't communicate with the NVIDIA driver. Make sure that the latest NVIDIA driver is installed and running.

qq_44769377的博客 5217

手把手教你用C语言给STM32写一个Modbus RTU从机库(含完整项目源码)

在工业自动化领域,Modbus RTU协议因其简单可靠的特点,成为RS485总线通信的事实标准。对于嵌入式开发者而言,为STM32等微控制器实现一个高效的Modbus RTU从机协议栈,是开发智能传感器、执行器等设备的必备技能。Modbus RTU从机的核心是一个状态机,需要处理帧接收、CRC校验、功能码解析和响应生成等环节。工业现场总会遇到意想不到的干扰情况,一个健壮的协议栈应该能够优雅地处理各种异常场景,而不是简单地崩溃或死锁。工业现场环境复杂,协议栈必须具备完善的异常处理机制。

weixin_30561425的博客 518

Git 使用笔记

或者按住shift加鼠标右键有个 `在此处打开Powershell窗口`,都可以直接 使用git命令。在你创建仓库文件夹内鼠标右键有个 Git Bash Here打开就好,

weixin_47059239的博客 752

从零开始:HLW8110电能计量IC的硬件设计与软件调试全攻略

本文详细介绍了HLW8110电能计量IC的硬件设计与软件调试全流程,涵盖核心特性、抗干扰设计、UART通信协议及校准方法。通过实战案例和优化技巧,帮助工程师快速掌握高精度交流测量技术,适用于智能插座、充电桩等应用场景。

p5l2m9n4o6q的博客 580
上一篇: How To Restore 12cR1DB to New Host File System using RMAN(一)
下一篇: 12c-Say goodbye to your backup when dropping your PDB
cppg67031
博客等级 码龄12年 2粉丝 0原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明:

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

余额充值