OCM_Session1_9_Database Backup and Availability

zyllf2009

9. Database Backup and Availability 9.1 Backup the database to prepare for complete recovery under all circumstances. 9.2 Open the database.

• 9.1 Backup the database to prepare for complete recovery under all circumstances.
  

没有说明如何备份数据库。建议冷备份和热备份一起。
1.创建备份的目录[oracle@ocm1 ~]$ cd $ORACLE_BASE/oradata/PROD/Disk5[oracle@ocm1 Disk5]$ lltotal 0[oracle@ocm1 Disk5]$ mkdir bak[oracle@ocm1 Disk5]$ lltotal 4drwxr-xr-x 2 oracle oinstall 4096 Mar 19 15:02 bak[oracle@ocm1 Disk5]$ cd bak[oracle@ocm1 bak]$ pwd/u01/app/oracle/oradata/PROD/Disk5/bak
2.将数据库改变为归档模式SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started.
Total System Global Area  524288000 bytesFixed Size                  1220360 bytesVariable Size             163578104 bytesDatabase Buffers          356515840 bytesRedo Buffers                2973696 bytesDatabase mounted.SQL> alter database archivelog;  
Database altered.
3.rman备份
[oracle@ocm1 ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Mar 19 15:08:31 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: PROD (DBID=254361867, not open)
RMAN> backup as compressed backupset database format '/u01/app/oracle/oradata/PROD/Disk5/bak/PROD_%U.bak';
Starting backup at 19-MAR-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=285 devtype=DISKchannel ORA_DISK_1: starting compressed full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00004 name=/u01/app/oracle/oradata/PROD/Disk1/example01.dbfinput datafile fno=00001 name=/u01/app/oracle/oradata/PROD/Disk1/system01.dbfinput datafile fno=00003 name=/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbfinput datafile fno=00002 name=/u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbfinput datafile fno=00007 name=/u01/app/oracle/oradata/PROD/Disk1/users01.dbfinput datafile fno=00008 name=/u01/app/oracle/oradata/PROD/Disk1/oltp01.dbfinput datafile fno=00005 name=/u01/app/oracle/oradata/PROD/Disk1/indx01.dbfinput datafile fno=00006 name=/u01/app/oracle/oradata/PROD/Disk1/tools01.dbfchannel ORA_DISK_1: starting piece 1 at 19-MAR-14channel ORA_DISK_1: finished piece 1 at 19-MAR-14piece handle=/u01/app/oracle/oradata/PROD/Disk5/bak/PROD_01p3iuaf_1_1.bak tag=TAG20140319T151005 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:02:07channel ORA_DISK_1: starting compressed full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 19-MAR-14channel ORA_DISK_1: finished piece 1 at 19-MAR-14piece handle=/u01/app/oracle/oradata/PROD/Disk5/bak/PROD_02p3iuee_1_1.bak tag=TAG20140319T151005 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03Finished backup at 19-MAR-14
RMAN>

• 9.2 Open the database.
  

RMAN> alter database open;
database opened
SQL> select open_mode from v$database;
OPEN_MODE----------READ WRITE         版权声明：本文为博主原创文章，未经博主允许不得转载。