- 论坛徽章:
- 0
|
我在进行oracle全备份时,为什么会找归档文件?
是用imp/exp还是RMAN作全备份?估计你应该是用的RMAN。在备份前应该打开ARCHIVELOG模式。如果ARCHIVE模式已经打开,备份仍然报错的话有可能是因为在你做ARCHIVELOG之前某些Archive已经丢失(可能是由于基于操作系统的删除所致),对于这种情况可以使用Rman的命令,将以前的Archivelog失效或者让Rman 识别目前那些ARchivelog是可用的。具体方法如下,仅供参考。
Change Archivelog All Crosscheck;
change archivelog all validate;
change archivelog '/test/u02/DATA/Archlogs/DATA_240.ARC' unavailable;
另外,如果不会开ARchivelog,请参见:
About how to create and enable the ARCHIVE LOG
Create
1. edit the initorasid.ora
log_archive_start = true
log_archive_dest =/dbscan/VTCC/
log_archive_format = "T%TS%S.ARC"
2. enable the archivelog in svrmgrl command prompt
2.1 first way
startup mount
svrmgrl>; startup mount
svrmgrl>; alter database archivelog
svrmgrl>; alter database open
2.2 second way
svrmgrl>; alter system set log_archive_dest_1='location=current destination'
2.3 third way
svrmgrl>; alter system archive log start to 'current destination'
Verify your database is now in archivelog mode
1. svrmgrl>; select NAME||''||VALUE from v$parameter
---------------------------------------------------------------------
log_archive_start TRUE
log_archive_dest
log_archive_duplex_dest
log_archive_dest_1 location=/u01/home/oracle/admin/PRD/arch/arc
log_archive_dest_2
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_state_1 enable
log_archive_dest_state_2 enable
log_archive_dest_state_3 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_max_processes 1
log_archive_min_succeed_dest 1
standby_archive_dest ?/dbs/arch
log_archive_format PRD_%T_%S.log
2. SVRMGRL>; archive log list;
Database log mode
Archive Mode
Automatic archival
Enabled
Archive destination for example: $ORACLE_HOME/dbs/arch
Oldest on-line log sequence 275
Next log sequence 277
Current log sequence 278
Archive all your redo logs at this point.
1. SVRMGRL>; archive log all
turn on and turn off the archivelog mode
1. Enabling Automatic Archiving After Instance Startup
SVRMGRL>; ALTER SYSTEM ARCHIVE LOG START
2. Automatic Archiving
2.1 at Instance Startup
set the "LOG_ARCHIVE_START" parameter of a database's parameter file to FALSE
LOG_ARCHIVE_START=FALSE
The new value takes effect the next time the database is started.
And, archive log list; command executed from SVRMGRL will show:
Automatic archival Disabled
2.2 after Instance Startup
SVRMGRL>; ALTER SYSTEM ARCHIVE LOG STOP;
2.3 SVRMGRL>; startup mount
SVRMGRL>; alter database noarchivelog;
SVRMGRL>; alter database open;
notes: 'Alter system archive log stop' will disable the automatic archiving of redo log file groups,
but it will not change the database from archivelog mode to noarchivelog mode.
Changing the database to run in noarchivelog mode will turn off archiving. |
|