Oracle数据库的冷备及完全恢复

实验环境：CentOS5.0+Oracle11gR2.0实验目的：练习Oracle数据库在NOACRHIVE模式下的冷备及complete Recovery。原文件的位置：/u01/oradata/denver，恢复到/u01/oradata/md目录中实验步骤：第一步：将数据库设置为noarchivelog模式，并进行冷备[sql]

sys@DENVER> startup mount
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 314575232 bytes
Database Buffers 100663296 bytes
Redo Buffers 6094848 bytes
Database mounted.
sys@DENVER> alter database noarchivelog
2 /
Database altered.
sys@DENVER> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/admin/denver/archdest
Oldest online log sequence 1
Current log sequence 1
sys@DENVER> alter database open;
Database altered.
sys@DENVER> @coldbackup

coldbackup.sql脚本内容如下： [sql]

[oracle@oracle11gR2 ~]$ more coldbackup.sql
Remark Set SQL*Plus variables to manipulate output
set feedback off heading off verify off trimspool off
set pagesize 0 linesize 200
Remark set SQL*Plus user variable used in this script
define dir="/tmp/backup/cold/"
define fil="/tmp/closed_backup_commands.sql"
prompt *** Spooling to &fil
Remark Create a command file with file backup commands
spool &fil
select "host cp "|| name ||" &dir" from v$datafile order by 1;
select "host cp "|| member ||" &dir" from v$logfile order by 1;
select "host cp "|| name ||" &dir" from v$controlfile order by 1;
select "host cp "|| name ||" &dir" from v$tempfile order by 1;
select "host cp "|| destination ||"/* &dir" from v$archive_dest where dest_id=1;
spool off;
Remark Shutdown the database cleanly
shutdown immediate;
Rmemark Run the copy file commands from the operating system
@&fil
Remark Start the database again
Startup;

第二步：模拟磁盘损坏：remove data file、control file and redo file [sql]

[oracle@oracle11gR2 ~]$ cd /u01/oradata/denver
[oracle@oracle11gR2 denver]$ rm -f *

第三步：在数据库关闭的情况下，将备份文件restore到md目录下 [sql]

[oracle@oracle11gR2 denver]$ cd /u01/oradata/md
[oracle@oracle11gR2 md]$ cp /tmp/backup/cold/* .

Linux下使用裸设备存储选项安装OracleUser Management Complete Recovery in ARCHIVELOG Mode相关资讯 oracle数据库教程

Oracle raw数据类型介绍（01/29/2013 10:05:53）
监听器注册与ORA-12514 错误分析（11/13/2012 14:30:08）
Oracle SQL的cursor理解（11/13/2012 14:16:17）

Oracle 如何强制刷新Buffer Cache （01/29/2013 10:02:46）
dblink致Oracle库的SCN变成两库的（11/13/2012 14:24:41）
Linux操作系统下完全删除Oracle数（11/13/2012 08:25:52）

本文评论查看全部评论（0）