System doesn't respond to forced log switch
> QUESTION POSED on: 12 July 2004
I am backing up all the tablespaces in my database. When I get to the process of forcing a log switch and issue alter system switch logfile, the system does not respond or it hangs.I don't really know what is responsible for this and how I can move further.
> EXPERT RESPONSE
Is this a new problem that used to work correctly? The most likely case to me is that you do not have archiving turned on. Make sure that your initialization parameters are set for archiving and that when you issue ARCHIVE LOG LIST, the output says that you are in Archive Log mode. Also verify that your archive log destination has enough space for the archived redo log files.
'오라클' 카테고리의 다른 글
| Can't connect to Oracle after running alter statement (0) | 2007.02.16 |
|---|---|
| View to determine backup status of tablespace (0) | 2007.02.16 |
| Sequential log of executed SQL statements (0) | 2007.02.14 |
| Buffer busy waits on primary key index (0) | 2007.02.14 |
| Import of dump file took 20 hours (0) | 2007.02.14 |