3,490
社区成员
发帖
与我相关
我的任务
分享
alter database begin backup;
host cp/copy 数据文件 备份
alter database end backup;
alter database backup controlfile to 备份;
create pfile=备份 from spfile;
alter system archive log current;
C:\Documents and Settings\user.HQ-TEXT>rman target sys/admin nocatalog
恢复管理器: Release 10.2.0.1.0 - Production on 星期一 8月 31 16:09:23 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到目标数据库: TEST (DBID=1992325518)
使用目标数据库控制文件替代恢复目录
RMAN> show all;
RMAN 配置参数为:
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 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S
NCFTEST.ORA'; # default
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP on;
RMAN> backup database;
启动 backup 于 31-8月 -09
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=144 devtype=DISK