SQL> shutdown immediate;
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open; 无法归档。导致不能归档模式备份。谢谢大家。我备份过一台服务器,行,但另一台不能归档了。谢谢大家
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open; 无法归档。导致不能归档模式备份。谢谢大家。我备份过一台服务器,行,但另一台不能归档了。谢谢大家
Thu Aug 19 02:00:04 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows NT Version V5.2 Service Pack 2
CPU : 8 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1940M/4084M, Ph+PgF:4016M/5953M, VA:1074M/2047M
Instance name: orclRedo thread mounted by this instance: 1Oracle process number: 146Windows thread id: 2368, image: ORACLE.EXE (SHAD)
*** ACTION NAME:(0000007 FINISHED92) 2010-08-19 02:00:04.968
*** SERVICE NAME:(SYS$USERS) 2010-08-19 02:00:04.968
*** SESSION ID:(6.36985) 2010-08-19 02:00:04.968
ORA-00258: NOARCHIVELOG 模式下的手动归档必须标识日志
日志。。
SQL> shutdown immediate;
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;