------------------------------------------------------------ /oracle1/oradata/ora10g/system01.dbf /oracle1/oradata/ora10g/undotbs01.dbf /oracle1/oradata/ora10g/sysaux01.dbf /oracle1/oradata/ora10g/users01.dbf /oracle1/oradata/ora10g/test01.dbf +DSKGRP1/ora10g/datafile/tspace1.256.647700289 SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ ---------- ------- ------- ---------------------------------------- --- 1 ONLINE /oracle1/oradata/ora10g/redo01.log NO 2 STALE ONLINE /oracle1/oradata/ora10g/redo02.log NO 3 ONLINE /oracle1/oradata/ora10g/redo03.log NO 6.2 修改数据库为归档模式
SQL> alter system set db_recovery_file_dest_size=500M; SQL> alter system set db_recovery_file_dest='/oracle1/flasharea/ora10g'; SQL> shutdown immediate SQL> startup mount; SQL> alter database archivelog; SQL> alter database open; SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 50 Next log sequence to archive 52 Current log sequence 52 - 16 -
6.3 备份数据库
6.3.1 备份数据文件
[oracle1@server ~]$ rman target / nocatalog Recovery Manager: Release 10.2.0.2.0 - Production on Tue Feb 26 19:51:28 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: ORA10G (DBID=3966404995) using target database control file instead of recovery catalog RMAN> show all; RMAN configuration parameters 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 ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle1/app/oracle/product/10.2/dbs/snapcf_ora10g.f'; # default RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
- 17 -
run { allocate channel dev1 type disk; allocate channel dev2 type disk; allocate channel dev3 type disk; allocate channel dev4 type disk; BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE FORMAT '+DSKGRP1' TAG 'ORA_ASM_MIGRATION'; } allocated channel: dev1 channel dev1: sid=138 devtype=DISK allocated channel: dev2 channel dev2: sid=137 devtype=DISK allocated channel: dev3 channel dev3: sid=136 devtype=DISK allocated channel: dev4 channel dev4: sid=135 devtype=DISK Starting backup at 26-FEB-08 channel dev1: starting datafile copy input datafile fno=00002 name=/oracle1/oradata/ora10g/undotbs01.dbf channel dev2: starting datafile copy input datafile fno=00001 name=/oracle1/oradata/ora10g/system01.dbf channel dev3: starting datafile copy input datafile fno=00004 name=/oracle1/oradata/ora10g/users01.dbf channel dev4: starting datafile copy input datafile fno=00003 name=/oracle1/oradata/ora10g/sysaux01.dbf
- 18 -
output filename=+DSKGRP1/ora10g/datafile/sysaux.258.647726823 tag=ORA_ASM_MIGRATION recid=7 stamp=647726917 channel dev4: datafile copy complete, elapsed time: 00:01:46 channel dev4: starting datafile copy input datafile fno=00005 name=/oracle1/oradata/ora10g/test01.dbf output filename=+DSKGRP1/ora10g/datafile/users.261.647726827 tag=ORA_ASM_MIGRATION recid=8 stamp=647726970 channel dev3: datafile copy complete, elapsed time: 00:02:35 channel dev3: starting datafile copy input datafile fno=00006 name=+DSKGRP1/ora10g/datafile/tspace1.256.647700289 output filename=+DSKGRP1/ora10g/datafile/system.259.647726825 tag=ORA_ASM_MIGRATION recid=9 stamp=647726992 channel dev2: datafile copy complete, elapsed time: 00:03:00 output filename=+DSKGRP1/ora10g/datafile/test.262.647726933 tag=ORA_ASM_MIGRATION recid=10 stamp=647726993 channel dev4: datafile copy complete, elapsed time: 00:01:11 output filename=+DSKGRP1/ora10g/datafile/undotbs.260.647726825 tag=ORA_ASM_MIGRATION recid=12 stamp=647727013 channel dev1: datafile copy complete, elapsed time: 00:03:15 output filename=+DSKGRP1/ora10g/datafile/tspace1.263.647726977 tag=ORA_ASM_MIGRATION recid=11 stamp=647727013 channel dev3: datafile copy complete, elapsed time: 00:00:40 Finished backup at 26-FEB-08 Starting Control File and SPFILE Autobackup at 26-FEB-08 piece handle=/oracle1/flasharea/ora10g/ORA10G/autobackup/2008_02_26/o1_mf_s_647727017_3w80fd1z_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 26-FEB-08 released channel: dev1
- 19 -
released channel: dev2 released channel: dev3 released channel: dev4 切换当前日志 RMAN> sql 'alter system archive log current'; 6.3.2 备份spfile
RMAN> run { BACKUP AS BACKUPSET SPFILE; RESTORE SPFILE TO \} Starting backup at 26-FEB-08 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=149 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including current SPFILE in backupset channel ORA_DISK_1: starting piece 1 at 26-FEB-08 channel ORA_DISK_1: finished piece 1 at 26-FEB-08 piece handle=/oracle1/flasharea/ora10g/ORA10G/backupset/2008_02_26/o1_mf_nnsnf_TAG20080226T200104_3w7zw1bt_.bkp tag=TAG20080226T200104 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 26-FEB-08 Starting Control File and SPFILE Autobackup at 26-FEB-08 piece handle=/oracle1/flasharea/ora10g/ORA10G/autobackup/2008_02_26/o1_mf_s_647726466_3w7zw2yj_.bkp comment=NONE
- 20 -