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

oracle 12cr1 异机恢复;

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

[root@uccpdb2 scripts]# cat backup_arc.sh
#!/bin/sh
su - oracle << EOF
rman target / cmdfile=/bak/orabakdata/scripts/archive.rcv log=/bak/orabakdata/scripts/archbackup.log append
[root@uccpdb2 scripts]# cat backup_db.sh
#!/bin/sh
su - oracle << EOF
rman target / cmdfile=/bak/orabakdata/scripts/full.rcv log=/bak/orabakdata/scripts/fullbackup0.log append
[root@uccpdb2 scripts]#
 
[root@uccpdb2 scripts]# cat backup_arc.sh
#!/bin/sh
su - oracle << EOF
rman target / cmdfile=/bak/orabakdata/scripts/archive.rcv log=/bak/orabakdata/scripts/archbackup.log append
[root@uccpdb2 scripts]# cat backup_db.sh
#!/bin/sh
su - oracle << EOF
rman target / cmdfile=/bak/orabakdata/scripts/full.rcv log=/bak/orabakdata/scripts/fullbackup0.log append


nbu只需把文件目录拉到带库。

恢复测试环境只需要用把备份文件目录拉到测试机存储里后实施恢复。

1 恢复参数文件并适当修改参数:
#RUN
#{
#  allocate channel c1 type disk format '/data01/bak/%d_%T_%U.bak';
#  SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data01/bak/%F';
#  RESTORE SPFILE
#    TO PFILE '/u01/app/oracle/product/12.1.0/db_1/dbs/initprod12c.ora'
#    FROM AUTOBACKUP;
#  SHUTDOWN ABORT;
#}
#
#
# restore spfile to pfile '/u01/app/oracle/product/12.1.0/db_1/dbs/initprd12cdb1.ora' from '/bak/orabakdata/controlfile/controlc-3299715205-20140528-00';
#

RUN
{
  allocate channel c1 type disk format '/data01/bak/controlfile/%d_%T_%U.bak';
  SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data01/bak/controlfile/%F';
  restore spfile to pfile '/u01/app/oracle/product/12.1.0/db_1/dbs/initprd12cdb1.ora' from '/data01/bak/controlfile/controlc-3299715205-20140528-00';
  release channel c1;
}

prd12cdb1.__data_transfer_cache_size=0
prd12cdb1.__data_transfer_cache_size=0
prd12cdb1.__db_cache_size=33554432000
prd12cdb1.__db_cache_size=33285996544
prd12cdb1.__java_pool_size=536870912
prd12cdb1.__java_pool_size=536870912
prd12cdb1.__large_pool_size=671088640
prd12cdb1.__large_pool_size=671088640
prd12cdb1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
prd12cdb1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
prd12cdb1.__pga_aggregate_target=13555990528
prd12cdb1.__pga_aggregate_target=13555990528
prd12cdb1.__sga_target=40667971584
prd12cdb1.__sga_target=40667971584
prd12cdb1.__shared_io_pool_size=536870912
prd12cdb1.__shared_io_pool_size=536870912
prd12cdb1.__shared_pool_size=5100273664
prd12cdb1.__shared_pool_size=5368709120
prd12cdb1.__streams_pool_size=0
prd12cdb1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/prd12cdb/adump'
*.audit_trail='none'
*.background_core_dump='partial'
*.backup_tape_io_slaves=FALSE
*.bitmap_merge_area_size=1048576
*.cell_offload_processing=TRUE
*.cluster_database=true
*.compatible='12.1.0.0.0'
*.control_files='/data01/current.261.844530693','/data01/current.256.844530693'
*.db_block_size=8192
*.db_create_file_dest='/data01'
*.db_create_online_log_dest_1='/data01'
*.db_create_online_log_dest_2='/data01'
*.db_domain=''
*.db_files=8192
*.db_flashback_retention_target=1440
*.db_name='prd12cdb'
*.db_recovery_file_dest='/data01'
*.db_recovery_file_dest_size=2047m
*.db_writer_processes=8
*.dbwr_io_slaves=0
*.ddl_lock_timeout=0
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=prd12cdbXDB)'
*.enable_pluggable_database=true
prd12cdb1.instance_number=2
prd12cdb1.instance_number=1
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=12900m
*.processes=8192
*.remote_login_passwordfile='exclusive'
*.sessions=9016
*.sga_target=38700m
prd12cdb1.thread=2
prd12cdb1.thread=1
prd12cdb1.undo_tablespace='UNDOTBS2'
prd12cdb1.undo_tablespace='UNDOTBS1'
cluster_database=false

2 nomount库恢复控制文件;

RUN
{
  allocate channel c1 type disk format '/data01/bak/controlfile/%d_%T_%U.bak';
  SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data01/bak/controlfile/%F';
   RESTORE CONTROLFILE FROM '/data01/bak/controlfile/controlc-3299715205-20140528-00';
  release channel c1;
}
 


RUN
{
  allocate channel c1 type disk format '/data01/bak/%d_%T_%U.bak';
   RESTORE CONTROLFILE FROM '/data01/bak/controlc-3377887405-20140526-00';
   release channel c1;
}

3 mount库注册备份集,恢复库:
RUN
{
  # allocate a channel to the tape device
    allocate channel c1 type disk format '/data01/bak/bak/%d_%T_%U.bak';
      allocate channel c2 type disk format '/data01/bak/bak/%d_%T_%U.bak';
        allocate channel c3 type disk format '/data01/bak/bak/%d_%T_%U.bak';
  # rename the data files and online redo logs
  set newname for database to '/data01/%f.dbf';
  # Do a SET UNTIL to prevent recovery of the online logs
  set until time "to_date('05/28/2014 17:00:00','mm/dd/yyyy hh24:mi:ss')";
  # restore the database and switch the data file names
  RESTORE DATABASE;
  SWITCH DATAFILE ALL;
  # recover the database
  RECOVER DATABASE;
       release channel disk1;
   release channel disk2;
   release channel disk3;
}

 

RUN
{
  # allocate a channel to the tape device
     allocate channel disk1 type disk format '/data01/bak/d-%T-%t-%s-%p.dbf';
   allocate channel disk2 type disk format '/data01/bak/d-%T-%t-%s-%p.dbf';
   allocate channel disk3 type disk format '/data01/bak/d-%T-%t-%s-%p.dbf';
   allocate channel disk4 type disk format '/data01/bak/d-%T-%t-%s-%p.dbf';
   allocate channel disk5 type disk format '/data01/bak/d-%T-%t-%s-%p.dbf';
   allocate channel disk6 type disk format '/data01/bak/d-%T-%t-%s-%p.dbf';
  # rename the data files and online redo logs
  # set newname for database to '/data01/%U.dbf';
  # Do a SET UNTIL to prevent recovery of the online logs
  set until time "to_date('05/26/2014 15:00:00','mm/dd/yyyy hh24:mi:ss')";
  # restore the database and switch the data file names
  #RESTORE DATABASE;
  #SWITCH DATAFILE ALL;
  # recover the database
  RECOVER DATABASE;
     release channel disk1;
   release channel disk2;
   release channel disk3;
   release channel disk4;
   release channel disk5;
   release channel disk6;
}

最终参数文件如下:
prod12c.__data_transfer_cache_size=0
prod12c.__db_cache_size=3925868544
prod12c.__db_cache_size=4362076160
prod12c.__java_pool_size=67108864
prod12c.__java_pool_size=67108864
prod12c.__large_pool_size=100663296
prod12c.__large_pool_size=100663296
prod12c.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
prod12c.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
prod12c.__pga_aggregate_target=3388997632
prod12c.__sga_target=10099884032
prod12c.__sga_target=10099884032
prod12c.__shared_io_pool_size=536870912
prod12c.__shared_io_pool_size=536870912
prod12c.__shared_pool_size=5402263552
prod12c.__shared_pool_size=4966055936
prod12c.__streams_pool_size=0
prod12c.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/prod12c/adump'
*.audit_trail='NONE'
*.cluster_database=true
*.compatible='12.1.0.0.0'
*.control_files='/data01/current.261.841255533','/data01/current.256.841255533'
*.db_block_size=8192
*.db_create_file_dest='/data01'
*.db_domain=''
*.db_files=8000
*.db_name='prod12c'
*.db_recovery_file_dest='/data01'
*.db_recovery_file_dest_size=322017689600
*.db_writer_processes=4
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=prod12cXDB)'
*.enable_pluggable_database=true
prod12c.instance_number=1
prod12c.instance_number=2
*.log_archive_format='%t_%s_%rCC"ou.dbf'
*.open_cursors=300
*.pga_aggregate_target=3210m
*.processes=4096
*.remote_login_passwordfile='exclusive'
*.sessions=4511
*.sga_target=9630m
prod12c.thread=1
prod12c.undo_tablespace='UNDOTBS1'
*.db_create_online_log_dest_1='/data01'
*.db_create_online_log_dest_2='/data01'

  cluster_database=false

[oracle@orat3 bak]$ cd control
controlc-3377887405-20140526-00  controlfile/                    
[oracle@orat3 bak]$ cd controlfile
[oracle@orat3 controlfile]$ ls
controlc-3299715205-20140528-00
[oracle@orat3 controlfile]$ pwd
[oracle@orat3 controlfile]$ cd ..
[oracle@orat3 bak]$ ls
archivebak                       d-20140525-848449842-263-1.dbf  d-20140525-848449851-274-1.dbf  d-20140525-848449862-285-1.dbf
backupdata                       d-20140525-848449842-264-1.dbf  d-20140525-848449852-275-1.dbf  d-20140525-848449862-286-1.dbf
controlc-3377887405-20140526-00  d-20140525-848449842-265-1.dbf  d-20140525-848449855-276-1.dbf  d-20140525-848449863-287-1.dbf
controlfile                      d-20140525-848449843-266-1.dbf  d-20140525-848449855-277-1.dbf  d-20140525-848449864-288-1.dbf
d-20140525-848449829-256-1.dbf   d-20140525-848449843-267-1.dbf  d-20140525-848449855-278-1.dbf  d-20140525-848449865-289-1.dbf
d-20140525-848449829-257-1.dbf   d-20140525-848449844-268-1.dbf  d-20140525-848449856-279-1.dbf  l-20140525-848449884-291-1.log
d-20140525-848449829-258-1.dbf   d-20140525-848449846-269-1.dbf  d-20140525-848449857-280-1.dbf  l-20140525-848449884-292-1.log
d-20140525-848449829-259-1.dbf   d-20140525-848449846-270-1.dbf  d-20140525-848449857-281-1.dbf  l-20140526-848536215-294-1.log
d-20140525-848449829-260-1.dbf   d-20140525-848449847-271-1.dbf  d-20140525-848449857-282-1.dbf  l-20140526-848536215-295-1.log
d-20140525-848449830-261-1.dbf   d-20140525-848449848-272-1.dbf  d-20140525-848449857-283-1.dbf  l-20140527-848622617-297-1.log
d-20140525-848449838-262-1.dbf   d-20140525-848449848-273-1.dbf  d-20140525-848449858-284-1.dbf  l-20140527-848622617-298-1.log
[oracle@orat3 bak]$ cd backupdata
[oracle@orat3 backupdata]$ ls
d-20140525-848449817-196-1.dbf  d-20140525-848449819-200-1.dbf  d-20140525-848449829-204-1.dbf  d-20140525-848449833-208-1.dbf
d-20140525-848449817-197-1.dbf  d-20140525-848449820-201-1.dbf  d-20140525-848449829-205-1.dbf  d-20140525-848449834-209-1.dbf
d-20140525-848449818-198-1.dbf  d-20140525-848449820-202-1.dbf  d-20140525-848449832-206-1.dbf
d-20140525-848449818-199-1.dbf  d-20140525-848449821-203-1.dbf  d-20140525-848449833-207-1.dbf

[oracle@orat3 backupdata]$
[oracle@orat3 backupdata]$
[oracle@orat3 backupdata]$ pwd
/data01/bak/backupdata
[oracle@orat3 backupdata]$ cd $ORACLE_HOME
[oracle@orat3 db_1]$ ls
addnode     cdata        ctx       deinstall    has            javavm  lib      nls     opmn         owm      QOpatch   root.sh       sqlpatch  usm
apex        cfgtoollogs  cv        demo         hs             jdbc    log      oc4j    oracore      perl     R         scheduler     sqlplus   utl
assistants  clone        dbhadoop  diagnostics  install        jdk     md       odbc    oraInst.loc  plsql    racg      slax          srvm      wwg
bin         crs          dbs       dmu          instantclient  jlib    mgw      olap    ord          plugins  rdbms     sqldeveloper  sysman    xdk
ccr         css          dc_ocm    dv           inventory      ldap    network  OPatch  oui          precomp  relnotes  sqlj          ucp
[oracle@orat3 db_1]$ cd dbs
[oracle@orat3 dbs]$ ls
a  b  hc_luocs12c1.dat  hc_prod12c.dat  initprod12c.ora  kk.ora  lkPROD12C  snapcf_prod12c.f  spfileprod12c.ora
[oracle@orat3 dbs]$ touch initprd12cdb.ora

[oracle@orat3 dbs]$ ls
a  b  hc_luocs12c1.dat  hc_prod12c.dat  initprd12cdb.ora  initprod12c.ora  kk.ora  lkPROD12C  snapcf_prod12c.f  spfileprod12c.ora
[oracle@orat3 dbs]$ cat initprod12c.ora

prod12c.__data_transfer_cache_size=0
prod12c.__db_cache_size=3925868544
prod12c.__db_cache_size=4362076160
prod12c.__java_pool_size=67108864
prod12c.__java_pool_size=67108864
prod12c.__large_pool_size=100663296
prod12c.__large_pool_size=100663296
prod12c.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
prod12c.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
prod12c.__pga_aggregate_target=3388997632
prod12c.__sga_target=10099884032
prod12c.__sga_target=10099884032
prod12c.__shared_io_pool_size=536870912
prod12c.__shared_io_pool_size=536870912
prod12c.__shared_pool_size=5402263552
prod12c.__shared_pool_size=4966055936
prod12c.__streams_pool_size=0
prod12c.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/prod12c/adump'
*.audit_trail='NONE'
*.cluster_database=true
*.compatible='12.1.0.0.0'
*.control_files='/data01/current.261.841255533','/data01/current.256.841255533'
*.db_block_size=8192
*.db_create_file_dest='/data01'
*.db_domain=''
*.db_files=8000
*.db_name='prod12c'
*.db_recovery_file_dest='/data01'
*.db_recovery_file_dest_size=322017689600
*.db_writer_processes=4
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=prod12cXDB)'
*.enable_pluggable_database=true
prod12c.instance_number=1
prod12c.instance_number=2
*.log_archive_format='%t_%s_%rCC"ou.dbf'
*.open_cursors=300
*.pga_aggregate_target=3210m
*.processes=4096
*.remote_login_passwordfile='exclusive'
*.sessions=4511
*.sga_target=9630m
prod12c.thread=1
prod12c.undo_tablespace='UNDOTBS1'
*.db_create_online_log_dest_1='/data01'
*.db_create_online_log_dest_2='/data01'

cluster_database=false

Recovery Manager complete.
[oracle@orat3 dbs]$ export ORACLE_SID=prd12cdb1
[oracle@orat3 dbs]$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Thu May 29 10:00:26 2014

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

connected to target database (not started)

RMAN> set dbid=3299715205;

executing command: SET DBID

RMAN>

RMAN> startup nomount force;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0/db_1/dbs/initprd12cdb1.ora'

starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started

Total System Global Area    1068937216 bytes

Fixed Size                     2296576 bytes
Variable Size                293602560 bytes
Database Buffers             767557632 bytes
Redo Buffers                   5480448 bytes


RMAN> show all;

RMAN configuration parameters for database with db_unique_name DUMMY are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default


RMAN> RUN
2> {
3>   allocate channel c1 type disk format '/data01/bak/controlfile/%d_%T_%U.bak';
4>   SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data01/bak/controlfile/%F';
5>   restore spfile to pfile '/u01/app/oracle/product/12.1.0/db_1/dbs/initprd12cdb1.ora' from '/data01/bak/controlfile/controlc-3299715205-20140528-00';
6>   release channel c1;
7> }

allocated channel: c1
channel c1: SID=789 device type=DISK

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

Starting restore at 29-MAY-14

channel c1: restoring spfile from AUTOBACKUP /data01/bak/controlfile/controlc-3299715205-20140528-00
channel c1: SPFILE restore from AUTOBACKUP complete
Finished restore at 29-MAY-14

released channel: c1

RMAN>

RMAN> shutdown immediate;

Oracle instance shut down

RMAN>  startup nomount;

Oracle instance started

Total System Global Area   40486408192 bytes

Fixed Size                     2692048 bytes
Variable Size               6979324976 bytes
Database Buffers           33420214272 bytes
Redo Buffers                  84176896 bytes

RMAN> create spfile from pfile='/u01/app/oracle/product/12.1.0/db_1/dbs/initprd12cdb1.ora';

Statement processed


Recovery Manager complete.
[oracle@orat3 dbs]$ export ORACLE_SID=prd12cdb1
[oracle@orat3 dbs]$ rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Thu May 29 10:27:43 2014

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

connected to target database: PRD12CDB (not mounted)

RMAN> RUN
2> {
3>   allocate channel c1 type disk format '/data01/bak/controlfile/%d_%T_%U.bak';
4>   SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data01/bak/controlfile/%F';
5>    RESTORE CONTROLFILE FROM '/data01/bak/controlfile/controlc-3299715205-20140528-00';
6>   release channel c1;
7> }

 using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=4 device type=DISK

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

Starting restore at 29-MAY-14

channel c1: restoring control file
channel c1: restore complete, elapsed time: 00:00:03
output file name=/data01/current.261.844530693
output file name=/data01/current.256.844530693
Finished restore at 29-MAY-14

released channel: c1

RMAN>

RMAN>

RMAN> alter database mount;

Statement processed

RMAN> report schema;

Starting implicit crosscheck backup at 29-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4 device type=DISK
Crosschecked 29 objects
Finished implicit crosscheck backup at 29-MAY-14

Starting implicit crosscheck copy at 29-MAY-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-MAY-14

searching for all files in the recovery area
cataloging files...

 

no files cataloged

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name PRD12CDB

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     +SYSDATA/PRD12CDB/DATAFILE/system.258.844530577
3    0        SYSAUX               ***     +SYSDATA/PRD12CDB/DATAFILE/sysaux.257.844530511
4    0        UNDOTBS1             ***     +SYSDATA/PRD12CDB/DATAFILE/undotbs1.260.844530643
5    0        PDB$SEED:SYSTEM      ***     +SYSDATA/PRD12CDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/system.267.844530717
6    0        USERS                ***     +SYSDATA/PRD12CDB/DATAFILE/users.259.844530643
7    0        PDB$SEED:SYSAUX      ***     +SYSDATA/PRD12CDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/sysaux.266.844530717
8    0        UNDOTBS2             ***     +SYSDATA/PRD12CDB/DATAFILE/undotbs2.269.844531237
9    0        ZSKMSDB:SYSTEM       ***     +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/system.274.844531545
10   0        ZSKMSDB:SYSAUX       ***     +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/sysaux.273.844531543
11   0        ZSKMSDB:USERS        ***     +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/users.276.844531567
12   0        OSSPORTALDB:SYSTEM   ***     +SYSDATA/PRD12CDB/F6ACE29ECAE0576BE0430254800A9CD6/DATAFILE/system.277.844532409
13   0        OSSPORTALDB:SYSAUX   ***     +SYSDATA/PRD12CDB/F6ACE29ECAE0576BE0430254800A9CD6/DATAFILE/sysaux.278.844532409
16   0        ZSKMSDB:RESALE_DATA  ***     +ZSKDATA/xxx_01.dbf
17   0        ZSKMSDB:JTITSM       ***     +ZSKDATA/itsm_data01.dbf
18   0        OSSPORTALDB:JTITSM   ***     +OSSPTLDATA/itsm_data01.dbf
19   0        ZSKMSDB:SYSTEM       ***     +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/system02.dbf
20   0        ZSKMSDB:SYSAUX       ***     +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/sysaux02.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    60       TEMP                 32767       +SYSDATA/PRD12CDB/TEMPFILE/temp.265.844530711
2    20       PDB$SEED:TEMP        32767       +SYSDATA/PRD12CDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/pdbseed_temp01.dbf
3    20       ZSKMSDB:TEMP         32767       +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/TEMPFILE/temp.275.844531547
4    20       OSSPORTALDB:TEMP     32767       +SYSDATA/PRD12CDB/F6ACE29ECAE0576BE0430254800A9CD6/TEMPFILE/temp.279.844532411

RMAN>
RMAN>
RMAN>
RMAN> catalog start with '/datao1/bak/bak';

searching for all files that match the pattern /datao1/bak/bak
no files found to be unknown to the database

RMAN> catalog start with '/data01/bak/bak';

searching for all files that match the pattern /data01/bak/bak

List of Files Unknown to the Database
=====================================
File Name: /data01/bak/bak/d-20140525-848449834-209-1.dbf
File Name: /data01/bak/bak/d-20140525-848449818-198-1.dbf
File Name: /data01/bak/bak/d-20140525-848449833-208-1.dbf
File Name: /data01/bak/bak/d-20140525-848449821-203-1.dbf
File Name: /data01/bak/bak/d-20140525-848449817-196-1.dbf
File Name: /data01/bak/bak/d-20140525-848449818-199-1.dbf
File Name: /data01/bak/bak/d-20140525-848449820-201-1.dbf
File Name: /data01/bak/bak/d-20140525-848449819-200-1.dbf
File Name: /data01/bak/bak/l-20140528-848712615-224-1.log
File Name: /data01/bak/bak/d-20140525-848449820-202-1.dbf
File Name: /data01/bak/bak/l-20140525-848453414-214-1.log
File Name: /data01/bak/bak/controlfile/controlc-3299715205-20140528-00
File Name: /data01/bak/bak/l-20140525-848449855-211-1.log
File Name: /data01/bak/bak/l-20140525-848449855-212-1.log
File Name: /data01/bak/bak/l-20140527-848626214-220-1.log
File Name: /data01/bak/bak/l-20140528-848712615-223-1.log
File Name: /data01/bak/bak/d-20140525-848449817-197-1.dbf
File Name: /data01/bak/bak/d-20140525-848449829-204-1.dbf
File Name: /data01/bak/bak/d-20140525-848449833-207-1.dbf
File Name: /data01/bak/bak/d-20140525-848449829-205-1.dbf
File Name: /data01/bak/bak/l-20140525-848453414-215-1.log
File Name: /data01/bak/bak/d-20140525-848449832-206-1.dbf
File Name: /data01/bak/bak/l-20140526-848539814-217-1.log
File Name: /data01/bak/bak/l-20140527-848626214-221-1.log
File Name: /data01/bak/bak/l-20140526-848539814-218-1.log

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /data01/bak/bak/d-20140525-848449834-209-1.dbf
File Name: /data01/bak/bak/d-20140525-848449818-198-1.dbf
File Name: /data01/bak/bak/d-20140525-848449833-208-1.dbf
File Name: /data01/bak/bak/d-20140525-848449821-203-1.dbf
File Name: /data01/bak/bak/d-20140525-848449817-196-1.dbf
File Name: /data01/bak/bak/d-20140525-848449818-199-1.dbf
File Name: /data01/bak/bak/d-20140525-848449820-201-1.dbf
File Name: /data01/bak/bak/d-20140525-848449819-200-1.dbf
File Name: /data01/bak/bak/l-20140528-848712615-224-1.log
File Name: /data01/bak/bak/d-20140525-848449820-202-1.dbf
File Name: /data01/bak/bak/l-20140525-848453414-214-1.log
File Name: /data01/bak/bak/controlfile/controlc-3299715205-20140528-00
File Name: /data01/bak/bak/l-20140525-848449855-211-1.log
File Name: /data01/bak/bak/l-20140525-848449855-212-1.log
File Name: /data01/bak/bak/l-20140527-848626214-220-1.log
File Name: /data01/bak/bak/l-20140528-848712615-223-1.log
File Name: /data01/bak/bak/d-20140525-848449817-197-1.dbf
File Name: /data01/bak/bak/d-20140525-848449829-204-1.dbf
File Name: /data01/bak/bak/d-20140525-848449833-207-1.dbf
File Name: /data01/bak/bak/d-20140525-848449829-205-1.dbf
File Name: /data01/bak/bak/l-20140525-848453414-215-1.log
File Name: /data01/bak/bak/d-20140525-848449832-206-1.dbf
File Name: /data01/bak/bak/l-20140526-848539814-217-1.log
File Name: /data01/bak/bak/l-20140527-848626214-221-1.log
File Name: /data01/bak/bak/l-20140526-848539814-218-1.log

RMAN> restore database preview;

Starting restore at 29-MAY-14
using channel ORA_DISK_1

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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
198     Incr 0  672.11M    DISK        00:00:08     25-MAY-14     
        BP Key: 231   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449820-201-1.dbf
  List of Datafiles in backup set 198
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 7411637    25-MAY-14 +SYSDATA/PRD12CDB/DATAFILE/system.258.844530577

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
207     Incr 0  2.13G      DISK        00:00:19     25-MAY-14     
        BP Key: 241   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449817-197-1.dbf
  List of Datafiles in backup set 207
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 7411632    25-MAY-14 +SYSDATA/PRD12CDB/DATAFILE/sysaux.257.844530511

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
208     Incr 0  20.71M     DISK        00:00:07     25-MAY-14     
        BP Key: 244   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449829-205-1.dbf
  List of Datafiles in backup set 208
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 7411652    25-MAY-14 +SYSDATA/PRD12CDB/DATAFILE/undotbs1.260.844530643

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
204     Incr 0  209.90M    DISK        00:00:02     25-MAY-14     
        BP Key: 246   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449832-206-1.dbf
  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 +SYSDATA/PRD12CDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/system.267.844530717

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
206     Incr 0  1.34M      DISK        00:00:01     25-MAY-14     
        BP Key: 225   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449834-209-1.dbf
  List of Datafiles in backup set 206
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6    0  Incr 7411660    25-MAY-14 +SYSDATA/PRD12CDB/DATAFILE/users.259.844530643

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
202     Incr 0  531.05M    DISK        00:00:12     25-MAY-14     
        BP Key: 228   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449821-203-1.dbf
  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 +SYSDATA/PRD12CDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/sysaux.266.844530717

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
205     Incr 0  15.74M     DISK        00:00:01     25-MAY-14     
        BP Key: 227   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449833-208-1.dbf
  List of Datafiles in backup set 205
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  8    0  Incr 7411657    25-MAY-14 +SYSDATA/PRD12CDB/DATAFILE/undotbs2.269.844531237

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
201     Incr 0  769.01M    DISK        00:00:14     25-MAY-14     
        BP Key: 232   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449819-200-1.dbf
  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 +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/system.274.844531545
  10   0  Incr 7411636    25-MAY-14 +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/sysaux.273.844531543

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
197     Incr 0  3.51M      DISK        00:00:02     25-MAY-14     
        BP Key: 230   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449818-199-1.dbf
  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 +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/users.276.844531567
  20   0  Incr 7411635    25-MAY-14 +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/sysaux02.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
209     Incr 0  216.70M    DISK        00:00:08     25-MAY-14     
        BP Key: 242   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449829-204-1.dbf
  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 +SYSDATA/PRD12CDB/F6ACE29ECAE0576BE0430254800A9CD6/DATAFILE/system.277.844532409

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
200     Incr 0  548.52M    DISK        00:00:11     25-MAY-14     
        BP Key: 234   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449820-202-1.dbf
  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 +SYSDATA/PRD12CDB/F6ACE29ECAE0576BE0430254800A9CD6/DATAFILE/sysaux.278.844532409

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
199     Incr 0  69.59M     DISK        00:00:11     25-MAY-14     
        BP Key: 229   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449817-196-1.dbf
  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 +ZSKDATA/xxx_01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
196     Incr 0  2.04M      DISK        00:00:02     25-MAY-14     
        BP Key: 226   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449818-198-1.dbf
  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 +ZSKDATA/itsm_data01.dbf
  19   0  Incr 7411633    25-MAY-14 +SYSDATA/PRD12CDB/F6ACAF06A0755467E0430254800A2839/DATAFILE/system02.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
203     Incr 0  1.03M      DISK        00:00:01     25-MAY-14     
        BP Key: 243   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0
        Piece Name: /data01/bak/bak/d-20140525-848449833-207-1.dbf
  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 +OSSPTLDATA/itsm_data01.dbf


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


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
211     9.50K      DISK        00:00:00     25-MAY-14     
        BP Key: 237   Status: AVAILABLE  Compressed: NO  Tag: TAG20140525T003055
        Piece Name: /data01/bak/bak/l-20140525-848449855-211-1.log

  List of Archived Logs in backup set 211
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    44      7411550    25-MAY-14 7411748    25-MAY-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
212     3.00K      DISK        00:00:01     25-MAY-14     
        BP Key: 238   Status: AVAILABLE  Compressed: NO  Tag: TAG20140525T003055
        Piece Name: /data01/bak/bak/l-20140525-848449855-212-1.log

  List of Archived Logs in backup set 212
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    47      7411554    25-MAY-14 7411744    25-MAY-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
214     5.21M      DISK        00:00:00     25-MAY-14     
        BP Key: 235   Status: AVAILABLE  Compressed: NO  Tag: TAG20140525T013014
        Piece Name: /data01/bak/bak/l-20140525-848453414-214-1.log

  List of Archived Logs in backup set 214
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    48      7411744    25-MAY-14 7433608    25-MAY-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
215     34.66M     DISK        00:00:00     25-MAY-14     
        BP Key: 245   Status: AVAILABLE  Compressed: NO  Tag: TAG20140525T013014
        Piece Name: /data01/bak/bak/l-20140525-848453414-215-1.log

  List of Archived Logs in backup set 215
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    45      7411748    25-MAY-14 7433612    25-MAY-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
217     135.35M    DISK        00:00:01     26-MAY-14     
        BP Key: 247   Status: AVAILABLE  Compressed: NO  Tag: TAG20140526T013014
        Piece Name: /data01/bak/bak/l-20140526-848539814-217-1.log

  List of Archived Logs in backup set 217
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    49      7433608    25-MAY-14 7579635    26-MAY-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
218     237.28M    DISK        00:00:01     26-MAY-14     
        BP Key: 249   Status: AVAILABLE  Compressed: NO  Tag: TAG20140526T013014
        Piece Name: /data01/bak/bak/l-20140526-848539814-218-1.log

  List of Archived Logs in backup set 218
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    46      7433612    25-MAY-14 7579641    26-MAY-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
220     142.25M    DISK        00:00:01     27-MAY-14     
        BP Key: 239   Status: AVAILABLE  Compressed: NO  Tag: TAG20140527T013014
        Piece Name: /data01/bak/bak/l-20140527-848626214-220-1.log

  List of Archived Logs in backup set 220
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    50      7579635    26-MAY-14 7712599    27-MAY-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
221     193.44M    DISK        00:00:01     27-MAY-14     
        BP Key: 248   Status: AVAILABLE  Compressed: NO  Tag: TAG20140527T013014
        Piece Name: /data01/bak/bak/l-20140527-848626214-221-1.log

  List of Archived Logs in backup set 221
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    47      7579641    26-MAY-14 7712594    27-MAY-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
224     193.30M    DISK        00:00:01     28-MAY-14     
        BP Key: 240   Status: AVAILABLE  Compressed: NO  Tag: TAG20140528T013014
        Piece Name: /data01/bak/bak/l-20140528-848712615-223-1.log

  List of Archived Logs in backup set 224
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    48      7712594    27-MAY-14 7838443    28-MAY-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
223     150.74M    DISK        00:00:01     28-MAY-14     
        BP Key: 233   Status: AVAILABLE  Compressed: NO  Tag: TAG20140528T013014
        Piece Name: /data01/bak/bak/l-20140528-848712615-224-1.log

  List of Archived Logs in backup set 223
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    51      7712599    27-MAY-14 7838440    28-MAY-14


^C
user interrupt received
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/29/2014 10:43:48
ORA-01013: user requested cancel of current operation

RMAN>

RMAN> exit

[oracle@orat3 dbs]$ export ORACLE_SID=prd12cdb1
[oracle@orat3 dbs]$ sqlplus '/ as sysdba'

SQL*Plus: Release 12.1.0.1.0 Production on Thu May 29 10:24:14 2014

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>
SQL>
SQL> show parameter control_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /data01/current.261.844530693,
                                                  /data01/current.256.844530693
SQL> show parameter dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u01/app/oracle/diag/rdbms/prd
                                                 12cdb/prd12cdb1/trace
core_dump_dest                       string      /u01/app/oracle/diag/rdbms/prd
                                                 12cdb/prd12cdb1/cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      partial
user_dump_dest                       string      /u01/app/oracle/diag/rdbms/prd
                                                 12cdb/prd12cdb1/trace
SQL> show parameter create

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
create_bitmap_area_size              integer     8388608
create_stored_outlines               string
db_create_file_dest                  string      /data01
db_create_online_log_dest_1          string      /data01
db_create_online_log_dest_2          string      /data01
db_create_online_log_dest_3          string
db_create_online_log_dest_4          string
db_create_online_log_dest_5          string
SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /data01
db_recovery_file_dest_size           big integer 2047M
recovery_parallelism                 integer     0
SQL> shut abort
startup nomount;
ORACLE 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
SQL>

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

Recovery Manager: Release 12.1.0.1.0 - Production on Thu May 29 10:43:58 2014

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

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

RMAN>
RMAN>
RMAN>
RMAN> RUN
2> {
3>   # allocate a channel to the tape device
4>     allocate channel c1 type disk format '/data01/bak/bak/%d_%T_%U.bak';
      allocate channel c2 type disk format '/data01/bak/bak/%d_%T_%U.bak';
        allocate channel c3 type disk format '/data01/bak/bak/%d_%T_%U.bak';
  # rename the data files and online redo logs
  set newname for database to '/data01/%f.dbf';
  # Do a SET UNTIL to prevent recovery of the online logs
  set until time "to_date('05/28/2014 17:00:00','mm/dd/yyyy hh24:mi:ss')";
  # restore the database and switch the data file names
  RESTORE DATABASE;
  SWITCH DATAFILE ALL;
  # recover the database
  RECOVER DATABASE;
       release channel disk1;
   release channel disk2;
   release channel disk3;
}5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19>

allocated channel: c1
channel c1: SID=4 device type=DISK

allocated channel: c2
channel c2: SID=9239 device type=DISK

allocated channel: c3
channel c3: SID=10778 device type=DISK

executing command: SET NEWNAME

executing command: SET until clause

Starting restore at 29-MAY-14

 

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00011 to /data01/11.dbf
channel c1: restoring datafile 00020 to /data01/20.dbf
channel c1: reading from backup piece /data01/bak/bak/d-20140525-848449818-199-1.dbf
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00017 to /data01/17.dbf
channel c2: restoring datafile 00019 to /data01/19.dbf
channel c2: reading from backup piece /data01/bak/bak/d-20140525-848449818-198-1.dbf
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00001 to /data01/1.dbf
channel c3: reading from backup piece /data01/bak/bak/d-20140525-848449820-201-1.dbf

 

channel c1: piece handle=/data01/bak/bak/d-20140525-848449818-199-1.dbf tag=HOT_DB_BK_LEVEL0
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:35
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00016 to /data01/16.dbf
channel c1: reading from backup piece /data01/bak/bak/d-20140525-848449817-196-1.dbf


channel c2: piece handle=/data01/bak/bak/d-20140525-848449818-198-1.dbf tag=HOT_DB_BK_LEVEL0
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:01:00
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00013 to /data01/13.dbf
channel c2: reading from backup piece /data01/bak/bak/d-20140525-848449820-202-1.dbf
channel c3: piece handle=/data01/bak/bak/d-20140525-848449820-201-1.dbf tag=HOT_DB_BK_LEVEL0
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:01:00
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00007 to /data01/7.dbf
channel c3: reading from backup piece /data01/bak/bak/d-20140525-848449821-203-1.dbf
channel c1: piece handle=/data01/bak/bak/d-20140525-848449817-196-1.dbf tag=HOT_DB_BK_LEVEL0
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:02:00
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00009 to /data01/9.dbf
channel c1: restoring datafile 00010 to /data01/10.dbf
channel c1: reading from backup piece /data01/bak/bak/d-20140525-848449819-200-1.dbf
channel c3: piece handle=/data01/bak/bak/d-20140525-848449821-203-1.dbf tag=HOT_DB_BK_LEVEL0
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:01:42
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00005 to /data01/5.dbf
channel c3: reading from backup piece /data01/bak/bak/d-20140525-848449832-206-1.dbf
channel c1: piece handle=/data01/bak/bak/d-20140525-848449819-200-1.dbf tag=HOT_DB_BK_LEVEL0
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:22
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00008 to /data01/8.dbf
channel c1: reading from backup piece /data01/bak/bak/d-20140525-848449833-208-1.dbf
channel c3: piece handle=/data01/bak/bak/d-20140525-848449832-206-1.dbf tag=HOT_DB_BK_LEVEL0
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:15
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00018 to /data01/18.dbf
channel c3: reading from backup piece /data01/bak/bak/d-20140525-848449833-207-1.dbf
channel c1: piece handle=/data01/bak/bak/d-20140525-848449833-208-1.dbf tag=HOT_DB_BK_LEVEL0
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00006 to /data01/6.dbf
channel c1: reading from backup piece /data01/bak/bak/d-20140525-848449834-209-1.dbf
channel c2: piece handle=/data01/bak/bak/d-20140525-848449820-202-1.dbf tag=HOT_DB_BK_LEVEL0
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:01:58
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00003 to /data01/3.dbf
channel c2: reading from backup piece /data01/bak/bak/d-20140525-848449817-197-1.dbf
channel c1: piece handle=/data01/bak/bak/d-20140525-848449834-209-1.dbf tag=HOT_DB_BK_LEVEL0
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00004 to /data01/4.dbf
channel c1: reading from backup piece /data01/bak/bak/d-20140525-848449829-205-1.dbf
channel c3: piece handle=/data01/bak/bak/d-20140525-848449833-207-1.dbf tag=HOT_DB_BK_LEVEL0
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:03
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00012 to /data01/12.dbf
channel c3: reading from backup piece /data01/bak/bak/d-20140525-848449829-204-1.dbf
channel c1: piece handle=/data01/bak/bak/d-20140525-848449829-205-1.dbf tag=HOT_DB_BK_LEVEL0
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:07
channel c3: piece handle=/data01/bak/bak/d-20140525-848449829-204-1.dbf tag=HOT_DB_BK_LEVEL0
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:07
channel c2: piece handle=/data01/bak/bak/d-20140525-848449817-197-1.dbf tag=HOT_DB_BK_LEVEL0
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:47
Finished restore at 29-MAY-14


datafile 1 switched to datafile copy
input datafile copy RECID=20 STAMP=848833091 file name=/data01/1.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=21 STAMP=848833091 file name=/data01/3.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=22 STAMP=848833091 file name=/data01/4.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=23 STAMP=848833091 file name=/data01/5.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=24 STAMP=848833091 file name=/data01/6.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=25 STAMP=848833091 file name=/data01/7.dbf


datafile 8 switched to datafile copy
input datafile copy RECID=26 STAMP=848833091 file name=/data01/8.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=27 STAMP=848833091 file name=/data01/9.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=28 STAMP=848833091 file name=/data01/10.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=29 STAMP=848833091 file name=/data01/11.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=30 STAMP=848833091 file name=/data01/12.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=31 STAMP=848833091 file name=/data01/13.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=32 STAMP=848833091 file name=/data01/16.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=33 STAMP=848833091 file name=/data01/17.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=34 STAMP=848833091 file name=/data01/18.dbf


datafile 19 switched to datafile copy
input datafile copy RECID=35 STAMP=848833091 file name=/data01/19.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=36 STAMP=848833091 file name=/data01/20.dbf

Starting recover at 29-MAY-14

 

starting media recovery

channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=44
channel c1: reading from backup piece /data01/bak/bak/l-20140525-848449855-211-1.log
channel c2: starting archived log restore to default destination
channel c2: restoring archived log
archived log thread=2 sequence=47
channel c2: reading from backup piece /data01/bak/bak/l-20140525-848449855-212-1.log
channel c3: starting archived log restore to default destination
channel c3: restoring archived log
archived log thread=2 sequence=48
channel c3: reading from backup piece /data01/bak/bak/l-20140525-848453414-214-1.log
channel c1: piece handle=/data01/bak/bak/l-20140525-848449855-211-1.log tag=TAG20140525T003055
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:00
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=45
channel c1: reading from backup piece /data01/bak/bak/l-20140525-848453414-215-1.log
channel c2: piece handle=/data01/bak/bak/l-20140525-848449855-212-1.log tag=TAG20140525T003055
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:00
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_47_9rf8yd6v_.arc thread=2 sequence=47
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_1_44_9rf8yd62_.arc thread=1 sequence=44
channel default: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_47_9rf8yd6v_.arc RECID=101 STAMP=848833484
channel c2: starting archived log restore to default destination
channel c2: restoring archived log
archived log thread=2 sequence=49
channel c2: reading from backup piece /data01/bak/bak/l-20140526-848539814-217-1.log
channel c3: piece handle=/data01/bak/bak/l-20140525-848453414-214-1.log tag=TAG20140525T013014
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:00
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_48_9rf8yd7t_.arc thread=2 sequence=48
channel default: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_1_44_9rf8yd62_.arc RECID=100 STAMP=848833484
channel c3: starting archived log restore to default destination
channel c3: restoring archived log
archived log thread=1 sequence=46
channel c3: reading from backup piece /data01/bak/bak/l-20140526-848539814-218-1.log
channel c1: piece handle=/data01/bak/bak/l-20140525-848453414-215-1.log tag=TAG20140525T013014
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_1_45_9rf8ydf0_.arc thread=1 sequence=45
channel default: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_48_9rf8yd7t_.arc RECID=102 STAMP=848833484
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=2 sequence=50
channel c1: reading from backup piece /data01/bak/bak/l-20140527-848626214-220-1.log
channel c2: piece handle=/data01/bak/bak/l-20140526-848539814-217-1.log tag=TAG20140526T013014
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:07
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_49_9rf8ydtv_.arc thread=2 sequence=49
channel default: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_1_45_9rf8ydf0_.arc RECID=103 STAMP=848833485
channel c2: starting archived log restore to default destination
channel c2: restoring archived log
archived log thread=1 sequence=47
channel c2: reading from backup piece /data01/bak/bak/l-20140527-848626214-221-1.log
channel c3: piece handle=/data01/bak/bak/l-20140526-848539814-218-1.log tag=TAG20140526T013014
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:06
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_1_46_9rf8yf7b_.arc thread=1 sequence=46
channel default: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_49_9rf8ydtv_.arc RECID=104 STAMP=848833487
channel c3: starting archived log restore to default destination
channel c3: restoring archived log
archived log thread=1 sequence=48
channel c3: reading from backup piece /data01/bak/bak/l-20140528-848712615-223-1.log
channel c1: piece handle=/data01/bak/bak/l-20140527-848626214-220-1.log tag=TAG20140527T013014
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:09
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_50_9rf8ym51_.arc thread=2 sequence=50
channel default: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_1_46_9rf8yf7b_.arc RECID=105 STAMP=848833490
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=2 sequence=51
channel c1: reading from backup piece /data01/bak/bak/l-20140528-848712615-224-1.log
channel c2: piece handle=/data01/bak/bak/l-20140527-848626214-221-1.log tag=TAG20140527T013014
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:10
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_1_47_9rf8ymc6_.arc thread=1 sequence=47
channel default: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_1_47_9rf8ymc6_.arc RECID=107 STAMP=848833495
channel c1: piece handle=/data01/bak/bak/l-20140528-848712615-224-1.log tag=TAG20140528T013014
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:06
channel c3: piece handle=/data01/bak/bak/l-20140528-848712615-223-1.log tag=TAG20140528T013014
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:07
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_1_48_9rf8ywsl_.arc thread=1 sequence=48
channel default: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_50_9rf8ym51_.arc RECID=106 STAMP=848833493
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_51_9rf8yx4t_.arc thread=2 sequence=51
channel default: deleting archived log(s)
archived log file name=/data01/PRD12CDB/archivelog/2014_05_29/o1_mf_2_51_9rf8yx4t_.arc RECID=109 STAMP=848833502
unable to find archived log
archived log thread=2 sequence=52

 

released channel: c1
released channel: c2
released channel: c3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/29/2014 11:05:14
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 52 and starting SCN of 7838440

RMAN>
RMAN>
RMAN>
RMAN>

RMAN> sql 'alter database open resetlogs';

sql statement: alter database open resetlogs

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

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

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

相关推荐

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

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

aqc802886的博客 465

SMR & RMAN的基本操作zt

本文解释 SMR & RMAN的基本操作。由于RMAN具有极大的灵活性,这里先只涉及其基本功能。更多的信息请参见 《Oracle8 Server Backup & Recovery Guide》。更复杂的例子请...

cuiti6357的博客 430

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

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

weixin_34413103的博客 404

RMAN 备份与恢复 实例

1. 检查数据库模式:   sqlplus /nolog    conn /as sysdba   archive log list (查看数据库是否处于归档模式中)   若为非归档,则修改数据库归档模式。   startup mount   alter database archivelog   alter database open2.连接到target数据库命令: connect

David Dai -- Focus on Oracle 8万+

Docker容器回顾之运维篇

背景 接上一篇《Docker复习之部署篇》,本文继续对Docker之日常维护常用操作做回顾总结。 操作命令 2.1 Docker 容器查看 首先,管理员对docker做日常维护,需要了解现有环境有多少docker实例,并连接进入docker实例虚拟机进行对应的管理维护; 我们执行 docker ps 命令来查看容器名称:docker ps -a或docker ps //显示当前正在运行的容器,输出如下: 参数概览: 示例: 1)显示最后被创建的容器:docker ps -l //相当于 dock

企业实战系列集 ●●● https://ximenjianxue.blog.youkuaiyun.com 2886

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

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

weixin_49199313的博客 418

RMAN 备份管理-下集

RMAN(Recover Manager) 接着RMAN管理-上集延伸,上集内容我们主要介绍RMAN三种备份模式的实践以及备份过程中的步骤和注意事项⚠️,本章主要阐述的就是怎么利用RMAN所产出的备份文件进行恢复,全程会有理论概述以及实践阶段,感谢各位读阅???? 在《用户管理》章节有介绍过关于恢复的两个名词,巩固一下: Restore :如果文件丢失了,那我们就将备份的文件复制到原来文件丢失的位置 Recover :介质恢复,恢复通过备份文件还原后的数据空窗期 RMAN恢复控制文件 首先我们先将控制

m0_38036502的博客 995

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

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

weixin_49199313的博客 287

oracle 03002,RMAN-03002 RMAN-06091 错误解决方法

RMAN-03002 RMAN-06091 错误解决方法客户自从使用nbu 以来一直报这个错误。因为以前一直都是正常的。所以晚上先让停止了nbu的备份。单独使用以前的脚本正常。报错信息一样。所以怀疑是不是脚本的问题。查询网上分析原因如下:SymptomsWhen attempting to delete obsolete backups from RMAN using the following ...

weixin_36373860的博客 2572

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

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

weixin_49199313的博客 266

【信息科学与工程学】计算机科学与自动化——第一百八十九篇 计算机硬件 系列一 微处理器01

在金融行业CDN流推送场景中,结合WebRTC over SD-RTN与SD-WAN Branch方案,需兼顾​​要求。

weixin_49199313的博客 1059

Using RMAN in Achivelog

rman target / RMAN> START MOUNT RMAN> RESTORE DATABASE RMAN> RECOVER DATABSE RMAN>ALTER DATABASE OPEN 联机重做日志丢失,是一种不完全恢复. 非归档模式永远是一种不完全恢复;非归档模式下的备份是一种冷备,恢复的时候将冷备的内容拷贝一下,就恢复了;冷备发生后...

weixin_30437337的博客 144

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

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

weixin_49199313的博客 268

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

容器数据库(CDB$ROOT)包含system,sysaux,undo和temp表空间,控制文件和redofile; 而种子数据库(PDB$SEED)包含system,sysaux,temp,example表空间,用来作...

154

嘉立创EDA vs Altium Designer:新手如何选择?从界面到实战全对比

本文全面对比了嘉立创EDA与Altium Designer(AD)两大PCB设计工具,从设计哲学、界面交互、封装库管理、设计规则引擎、协作功能到成本生态六大维度进行深入分析。嘉立创EDA以极简设计和云端协作为特色,适合学生和创客快速上手;而AD则凭借专业级精准控制,成为高端电子设计的行业标准。通过实战案例和详细对比表格,帮助新手根据项目需求选择合适的EDA工具。

weixin_30296405的博客 722

网工实验笔记:SNMP的配置

简单网络管理协议SNMP(Simple Network Management Protocol)是广泛应用于TCP/IP网络的网络管理标准协议。SNMP提供了一种通过运行网络管理软件的中心计算机(即网络管理工作站)来管理设备的方法。

2301_76170756的博客 2116

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

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

472

Dify + mem0插件实战:如何让AI记住你的饮食习惯(附完整代码)

本文通过Dify平台与mem0插件实战,详细演示了如何为AI助手构建长期记忆系统,使其能记住并理解用户的复杂饮食习惯(如过敏源、饮食偏好)。文章提供了完整的工作流配置与Python代码示例,帮助开发者实现跨会话的个性化饮食建议,解决AI对话中的“健忘”问题。

lg888的博客 1097

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

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

csdnkazusa的博客 1373

DaVinci Configurator实战:从DBC导入到通信栈配置全解析

本文详细解析了如何使用Vector DaVinci Configurator工具,从导入行业标准DBC文件开始,高效完成AutoSAR通信栈(包括COM、PduR、CanIf等模块)的自动化与精细化配置。文章通过实战步骤,重点阐述了DBC导入、与EB MCAL协同、核心模块参数调整及诊断标定服务集成等关键环节,旨在帮助汽车电子工程师快速掌握这一核心工具,提升开发效率与准确性。

weixin_29159127的博客 598

PTPX功耗分析实战——从脚本配置到报告解读

本文详细介绍了PTPX功耗分析的全流程,从脚本配置到报告解读,帮助工程师快速掌握芯片设计中的功耗估算技术。文章涵盖了环境搭建、波形文件处理、功耗报告解析等关键环节,并提供了实战经验和优化建议,特别适合需要提升PTPX功耗分析效率的开发者。

weixin_29248313的博客 283

K8s 核心组件使用指南

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

nRks5Qp11的博客 216

Spring Boot日志可视化实战:5分钟搞定Promtail采集与Grafana查询(避坑指南)

本文详细介绍了如何通过Promtail和Grafana实现Spring Boot日志的可视化查询,提供从日志采集到高效查询的全流程实战指南,重点解决部署中的常见问题。内容包括Logback配置、Promtail日志采集、Grafana的LogQL查询技巧及生产环境优化建议,帮助开发者快速定位和解决日志问题。

weixin_42526015的博客 108

Git 使用笔记

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

weixin_47059239的博客 752

告别轮询!手把手教你用S32K3的FlexCAN Enhanced FIFO+DMA实现高效CAN FD数据接收

本文详细介绍了如何利用S32K3芯片的FlexCAN Enhanced FIFO与DMA组合方案,实现高效CAN FD数据接收,彻底告别传统轮询和中断模式。通过深度缓冲、智能过滤和DMA联动技术,该方案在5Mbps高负载场景下将CPU占用率从42%降至3%以下,显著提升系统实时性和吞吐量。

weixin_30906185的博客 504

Linux故障排查和性能优化面试题及参考答案

在 Linux 系统中,负载(Load Average)是衡量系统繁忙程度的一个重要指标,它表示系统在特定时间间隔内运行队列中的平均进程数。负载值反映了系统当前的工作压力,主要包括 CPU 等待运行的进程数量和处于不可中断睡眠状态(通常是等待 I/O 操作完成)的进程数量。负载平均值通常有三个数值,分别代表过去 1 分钟、5 分钟和 15 分钟内的系统平均负载。例如,在使用uptime命令或查看文件时,会看到类似这样的输出,这三个数值依次表示过去 1 分钟、5 分钟和 15 分钟的负载平均值。

大模型大数据攻城狮的专栏 1083
上一篇: RECOVERING FROM A LOST DATAFILE IN A UNDO TABLESPACE (文档 ID 1013221.6)
下一篇: How To Restore 12cR1DB to New Host File System using RMAN(二)
cppg67031
博客等级 码龄12年 2粉丝 0原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明:

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

余额充值