How to configure Database in Archivelog Mode.

How to configure Database in Archivelog Mode

Step-1

create pfile from spfile.

Step-2

Shutdown the Database.

Step-3

Create a mount point and also directory.
Enter archive parameter in pfile.

log_archive_dest_1='location=/u02/oraprod/PROD/archive'
log_archive_start=TRUE
LOG_ARCHIVE_FORMAT=’PROD%t_%s_%r.arc’

Step-4

Startup the database pfile in mount mode.

SQL> alter datababase archivelog;
SQL>alter database open;
SQL> archive log list;

Step-5

Check the archive file is generating and not.

No comments:

Post a Comment