<menu id="ycqsw"></menu><nav id="ycqsw"><code id="ycqsw"></code></nav>
<dd id="ycqsw"><menu id="ycqsw"></menu></dd>
  • <nav id="ycqsw"></nav>
    <menu id="ycqsw"><strong id="ycqsw"></strong></menu>
    <xmp id="ycqsw"><nav id="ycqsw"></nav>
  • oralce是什么軟件(oracle數據庫菜鳥教程)


    Oracle 數據庫一個大企業經常使用的一種數據.下面我們來學習一下Oralce的RMAN備份

    操作環境:CentOS 6.5

    Oralce 版本:Oracle 11g

    Oralce數據庫:Oracle數據庫的RMAN備份(一)

    一、Oracle 數據庫的歸檔

    1、查看是否歸檔

    SQL> archive log list;

    Database log mode No Archive Mode

    Automatic archival Disabled

    Archive destination USE_DB_RECOVERY_FILE_DEST

    Oldest online log sequence 61

    Current log sequence 63

    2、開啟歸檔

    SQL> shutdown immediate;

    Database closed.

    Database dismounted.

    ORACLE instance shut down.

    SQL> startup mount;

    ORACLE instance started.

    Total System Global Area 780824576 bytes

    Fixed Size 2257312 bytes

    Variable Size 511708768 bytes

    Database Buffers 264241152 bytes

    Redo Buffers 2617344 bytes

    Database mounted.

    SQL> alter database archivelog;

    Database altered.

    SQL> archive log list;

    Database log mode Archive Mode

    Automatic archival Enabled

    Archive destination USE_DB_RECOVERY_FILE_DEST

    Oldest online log sequence 61

    Next log sequence to archive 63

    Current log sequence 63

    SQL> alter database open;

    Database altered.

    SQL>

    二、開啟rman 備份

    [oracle@dbaul01 rman]$ rman target /

    Recovery Manager: Release 11.2.0.4.0 – Production on Fri OCT 9 00:06:54 2017

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

    connected to target database: ORCL (DBID=1457544464)

    RMAN> show all;

    using target database control file instead of recovery catalog

    RMAN configuration parameters for database with db_unique_name ORCL 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 ARCHIVELOG DELETION POLICY TO NONE; # default

    CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/product/db/dbs/snapcf_orcl.f’; # default

    RMAN> backup database;

    Starting backup at 09-OCT-17

    allocated channel: ORA_DISK_1

    channel ORA_DISK_1: SID=36 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=00006 name=/u01/app/oradata/rman/an.dbf

    input datafile file number=00001 name=/u01/app/oradata/orcl/system01.dbf

    input datafile file number=00002 name=/u01/app/oradata/orcl/sysaux01.dbf

    input datafile file number=00003 name=/u01/app/oradata/orcl/undotbs01.dbf

    input datafile file number=00005 name=/u01/app/oradata/rm/rm02.dbf

    input datafile file number=00004 name=/u01/app/oradata/orcl/users01.dbf

    channel ORA_DISK_1: starting piece 1 at 09-OCT-17

    channel ORA_DISK_1: finished piece 1 at 09-OCT-17

    piece handle=/u01/app/fast_recovery_area/ORCL/backupset/2017_10_09/o1_mf_nnndf_TAG20171009T000843_d4m1dgsq_.bkp tag=TAG20171009T000843 comment=NONE

    channel ORA_DISK_1: backup set complete, elapsed time: 00:04:21

    channel ORA_DISK_1: starting full datafile backup set

    channel ORA_DISK_1: specifying datafile(s) in backup set

    including current control file in backup set

    including current SPFILE in backup set

    channel ORA_DISK_1: starting piece 1 at 09-OCT-17

    channel ORA_DISK_1: finished piece 1 at 09-OCT-17

    piece handle=/u01/app/fast_recovery_area/ORCL/backupset/2017_10_09/o1_mf_ncsnf_TAG20171009T000843_d4m1nqrf_.bkp tag=TAG20171009T000843 comment=NONE

    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

    Finished backup at 09-OCT-17

    三、備份完畢

    版權聲明:本文內容由互聯網用戶自發貢獻,該文觀點僅代表作者本人。本站僅提供信息存儲空間服務,不擁有所有權,不承擔相關法律責任。如發現本站有涉嫌抄襲侵權/違法違規的內容, 請發送郵件至 舉報,一經查實,本站將立刻刪除。

    發表評論

    登錄后才能評論
    国产精品区一区二区免费