启动归档模式:
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
查看归档模式:
archive log list
关闭归档模式:
shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
查看归档文件:
show parameter db_recovery;
路径
D:\app\Administrator\flash_recovery_area\ops$storep
备份归档文件:
backup archivelog all;
删除归档文件:
1. rman target / 或者 rman target user/password@tns
list archive all;
crosscheck archivelog all;
list expired archivelog all;
delete expired archivelog all;
2. rman target /
delete archivelog all completed before 'sysdate-7';
3.backup first
backup format '/tmp/arch-%T_%s_%U' archivelog all delete input;
或者 backup database plus archivelog;
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
查看归档模式:
archive log list
关闭归档模式:
shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
查看归档文件:
show parameter db_recovery;
路径
D:\app\Administrator\flash_recovery_area\ops$storep
备份归档文件:
backup archivelog all;
删除归档文件:
1. rman target / 或者 rman target user/password@tns
list archive all;
crosscheck archivelog all;
list expired archivelog all;
delete expired archivelog all;
2. rman target /
delete archivelog all completed before 'sysdate-7';
3.backup first
backup format '/tmp/arch-%T_%s_%U' archivelog all delete input;
或者 backup database plus archivelog;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30633998/viewspace-1965915/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
expdp、impdp
请登录后发表评论
登录
全部评论
