put a database in ARCHIVELOG
600670Oct 23 2007 — edited Oct 23 2007Could anybody tell me if these are the steps for putting the database in ARCHIVELOG (the database is running in NOARCHIVELOG mode, and is using pfile)?
1) modify the pfile for archiving
2) stop the listener (not to permit another connection)
3) shutdown immediate
4) startup mount
5) alter database archivelog
6) alter database open
7) alter system switch logfile
8) shutdown immediate
9) take a cold backup (the new archive file created at the swich will be deleted and is not a part of backup)
10) startup
thanks,
D.