做备份恢复时，把undo改小一点
SQL>CREATE UNDO TABLESPACE undo1
DATAFILE 'D:\oracle\oradata\ora\undo01.dbf'
SIZE 4M AUTOEXTEND ON;
SQL>ALTER SYSTEM SET UNDO_TABLESPACE=UNDO1;
SQL>DROP TABLESPACE UNDOTBS;
1) SQL> create pfile from spfile;
2) shutdown immediate
3) 用写字板打开initora.ora 编辑这个静态参数文件
加三行代码
log_archive_start=true
log_archive_dest='d:\oracle\oradata\ora\'
log_archive_format='awu%s.arc'
OS保存
SQL> startup pfile='d:\oracle\ora90\database\initora.ora'
4) SQL> create spfile from pfile;
5) SQL> startup mount
6) SQL> alter database archivelog
7) SQL> alter database open;
8) SQL> archive log list;
9) 创建scott用户，供实验用
SQL> @D:\oracle\ora90\rdbms\admin\scott.sql
10) SQL> shutdown immediate
11) 做一个完全的冷备份，OS下，将文件(D:\oracle\oradata\ora\...) 复制到D:\oracle\oradata\backupora\...)
阅读(2190) | 评论(0) | 转发(0) |
