这两句是什么意思(不应该没人会呀，怎么没人帮忙）

tomer

alter system archive log current

backup archivelog all delete input

[ 本帖最后由 tomer 于 2007-9-9 13:49 编辑 ]

liu_jian110

alter system archive log current 更改数据库为归档模式
backup archivelog all delete input 备份归档日志

tomer

原帖由 liu_jian110 于 2007-9-9 20:03 发表
alter system archive log current 更改数据库为归档模式
backup archivelog all delete input 备份归档日志

alter system archive就是更改更改数据库为归档模式 ,为什么要加个 log current

backup archivelog all delete input 备份归档日志,其中delete input是删掉什么

numenhuang

原帖由 tomer 于 2007-9-10 00:36 发表



alter system archive就是更改更改数据库为归档模式 ,为什么要加个 log current

backup archivelog all delete input 备份归档日志,其中delete input是删掉什么

1. archive log current 不是更改数据库为归档模式


官方文档中已经阐述的很清楚：
CURRENT Clause

Specify CURRENT to manually archive the current redo log file group of the specified thread, forcing a log switch. If you omit the THREAD parameter, then Oracle Database archives all redo log file groups from all enabled threads, including logs previous to current logs. You can specify CURRENT only when the database is open.

2. delete input意思就是备份完archivelog以后，自动将其删除（只是删除一个dest的archived log，如果要删除所有dest的archived log
应该使用delete all input

官方文档中已经阐述的很清楚：
4.3.7.1.2 Using BACKUP ARCHIVELOG with DELETE INPUT or DELETE ALL INPUT

You can specify the DELETE INPUT or DELETE ALL INPUT clauses for the BACKUP ARCHIVELOG command to delete archived logs after they are backed up, eliminating the separate step of manually deleting the archived redo logs. With DELETE INPUT, RMAN only deletes the specific copy of the archived redo log chosen for the backup set. With DELETE ALL INPUT, RMAN will delete each backed-up archived redo log file from all log archiving destinations.

For example, assume that you archive to /arc_dest1, /arc_dest2, and /arc_dest3, and you run the following command:

BACKUP DEVICE TYPE sbt
  ARCHIVELOG ALL
  DELETE ALL INPUT;


In this case RMAN backs up only one copy of each log sequence number in these directories, and then deletes all copies of any log that it backed up from the archiving destinations. If you had specified DELETE INPUT rather than DELETE ALL INPUT, then RMAN would only delete the specific archived redo log files that it backed up (for example, it would delete the archived redo log files in /arc_dest1 if those were the files used as the source of the backup, but it would leave the contents of the /arc_dest2 and /arc_dest3 intact) .

If you issue BACKUP ARCHIVELOG ALL or BACKUP ARCHIVELOG LIKE '...', and there are no archived redo log files to back up, then RMAN does not signal an error.

tomer

没太明白，是删除备份集里的archivelog,还是原来路径下的archivelog

numenhuang

原文件

tomer

哦,就是备份完,就把原来的删掉了

谢谢