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.
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