Oracle数据库的冷备及完全恢复
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
- [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 *
- [oracle@oracle11gR2 denver]$ cd /u01/oradata/md
- [oracle@oracle11gR2 md]$ cp /tmp/backup/cold/* .
|
评论暂时关闭