| deleting archivelog files [message #62706] |
Tue, 10 August 2004 12:42  |
chetna
Messages: 21
Registered: July 2004
|
Junior Member |
|
|
can we deleting archivelog files to save space.
can we delete these files and open the database in NOarchivelog mode ?
Is there any damage to the database ?
Thanks
|
|
|
|
| Re: deleting archivelog files [message #62712 is a reply to message #62706] |
Tue, 10 August 2004 21:10  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Well i don't know why u want to shift from archivelog to noarchivelog, but it is true that any time you can shift from archivelog to noarchivelog or vice-versa. To do this follow the following steps :
First take a full backup for safety.
Shutdown the DB cleanly.
Mount the DB.
Issue ALTER DATABASE NOARCHIVELOG;
Open the DB.
Againg shutdown the DB cleanly.
Take a cold backup;
Open the DB.
Now ur DB is running in noarchivelog and u can delete that archivelogs also.
Best of Luck
Daljit Singh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
