您当前的位置:首页 > 淘宝百科

oralce是什么软件(oracle数据库菜鸟教程)

时间:2023-01-06 13:01:12

oralce是什么软件(oracle数据库菜鸟教程)

Oracle 数据库一个大企业经常使用的一种数据.下面我们来学习一下Oralce的RMAN备份

操作环境:CentOS 6.5

Oralce 版本:Oracle 11g

一、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

三、备份完毕

备份

最新文章