--Archive file location
SQL> alter system set log_archive_dest_1='location=/ora/oracle/archive1/' scope=spfile;
system altered.
--Archive file format
SQL> alter system set log_archive_format='arch_%t_%s_%r.arc' scope=spfile;
system altered.
--stop the database
$ srvctl stop database -d racdb1
--start the database in mount
$ srvctl start database -d racdb1 -o mount
--enable the archivelog
sql> alter database archivelog;
--stop the database.
$ srvctl stop database -d racdb1
--start all database
$ srvctl start database -d racdb1
--check the database
sql> archive log list;
database log mode Archive Mode
Automatic archiveal Enabled
Archive Destination /ora/oracle/archive1
oldert online log sequence 9
Next log sequence to archive 10
current log sequence 10
SQL> alter system set log_archive_dest_1='location=/ora/oracle/archive1/' scope=spfile;
system altered.
--Archive file format
SQL> alter system set log_archive_format='arch_%t_%s_%r.arc' scope=spfile;
system altered.
--stop the database
$ srvctl stop database -d racdb1
--start the database in mount
$ srvctl start database -d racdb1 -o mount
--enable the archivelog
sql> alter database archivelog;
--stop the database.
$ srvctl stop database -d racdb1
--start all database
$ srvctl start database -d racdb1
--check the database
sql> archive log list;
database log mode Archive Mode
Automatic archiveal Enabled
Archive Destination /ora/oracle/archive1
oldert online log sequence 9
Next log sequence to archive 10
current log sequence 10
No comments:
Post a Comment