Oraclec操作步骤.docVIP

Oraclec操作步骤 切换服务器归档模式 %sqlplus /nolog SQL conn / as sysdba sqlalter system set log_archive_start=true scope=spfile; sql create pfile from spfile; sql alter system set log_archive_format=%S_%T_%R.log scope=spfile; //修改归档日志的格式 sqlalter system set log_archive_dest_1=location=d::\backup1 scope=spfile; //修改归档日志存放的位置 sqlshutdown immediate; SQLstartup mount; SQLalter database archivelog; SQLalter database open; SQL exit 2、 rman target=rman/rman@rmant 3、 RMAN configure default device type to disk; RMAN configure device type disk parallelism 2; RMAN configure channel 1 device type disk format d:\backup1\backup_%U; RMAN configure channel 2 device type disk format d:\backup1\backup_%U; RMAN configure controlfile autobackup on; RMAN configure controlfile autobackup format for device type disk to d:\backup1\ctl_%F; RMAN show all 4、备份全库： RMAN backup database plus archivelog delete input; (备份全库及控制文件、服务器参数文件与所有归档的重做日志，并删除旧的归档日志) 5、备份归档日志： RMAN backup archivelog all delete input; 6、验证备份： RMAN validate backupset 3; 7、查看备份文件 7、从自动备份中恢复服务器参数文件： RMAN shutdown immediate; (立即关闭数据库) RMAN startup nomount; (启动实例) RMAN restore spfile to pfile /backup1/mydb.ora from autobackup; 8、从自动备份中恢复控制文件： RMAN shutdown immediate; (立即关闭数据库) RMAN startup nomount; (启动实例) RMAN restore controlfile to /backup1 from autobackup; 9、恢复和复原全数据库： RMAN shutdown immediate; (立即关闭数据库) RMAN exit (退出) %mv /oracle/dbs/tbs_12.f /oracle/dbs/tbs_12.bak (将数据文件重命名) %mv /oracle/dbs/tbs_13.f /oracle/dbs/tbs_13.bak (将数据文件重命名) %mv /oracle/dbs/tbs_14.f /oracle/dbs/tbs_14.bak (将数据文件重命名) %mv /oracle/dbs/tbs_15.f /oracle/dbs/tbs_15.bak (将数据文件重命名) 9、%rman target=rman/rman@mydb (启动恢复管理器) RMAN startup pfile=/oracle/admin/mydb/pfile/initmydb.ora (指定初始化参数文件启动数据库) RMAN restore database; (还原数据库) RMAN recover database; (恢复数据库) RMAN alter database open; (打开数据库) 10、恢复和复原表空间： RMAN sql alter tablespace users offline immediate; (将表空间脱机) RMAN exit (退出恢复管理器) %mv /or