problem:
SQL> alter tablespace xxx begin backup;
alter tablespace xxx begin backup
*
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 13
Current log sequence 15
solution::
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 414298112 bytes
Fixed Size 1300296 bytes
Variable Size 335546552 bytes
Database Buffers 71303168 bytes
Redo Buffers 6148096 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 13
Next log sequence to archive 15
Current log sequence 15
SQL> alter tablespace xxx begin backup;
Tablespace altered.
SQL> alter tablespace xxx end backup;
Tablespace altered.
备注:这个主要是系统还没启动归档模式,所以无法进行热备份。
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24829399/viewspace-1048332/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24829399/viewspace-1048332/