Shulou(Shulou.com)05/31 Report--

This article mainly describes how to migrate the database in advance related parameters to modify, the text is very detailed, has a certain reference value, interested friends must read!

Open file

number of processes

undo interval

the cryptoperiod

Temporary Tablespace View to verify if rebuild is required. No need to rebuild this time.

*.log_archive_dest_1='location=E:\archivelog'

*.log_archive_format='arch_%t_%s_%r.log'

*.processes=500

*.sessions=555

*.undo_retention=3600

Restart Library

alter system set processes=500 scope=spfile;

alter system set sessions=555 scope=spfile;

--View password validity period

select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

--Set default profile password never expires, takes effect immediately, no need to restart library

alter profile default limit password_life_time unlimited;

View undo parameters

SQL> show parameter undo

--modify undo flashback parameters

alter system set undo_retention=3600 scope=both;

Temporary table space reconstruction

ALTER TABLESPACE TEMP ADD TEMPFILE 'E:\APP\ADMINISTRATOR\ORADATA\EMR\TEMP01.DBF'

SIZE 1866M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;

ALTER TABLESPACE EMR_TEMP ADD TEMPFILE 'E:\APP\ADMINISTRATOR\ORADATA\EMR\EMR_TEMP.DBF'

SIZE 52428800 REUSE AUTOEXTEND ON NEXT 52428800 MAXSIZE 20480M;

2. Set the archive path (you need to determine whether the default flashback recovery area path is enabled in the database)

SQL> show parameter db_recovery_file_dest --Confirm whether to open flashback recovery area path

1. There is a default flashback area. The following two methods are available.

Method 1

Use archive log path that can coexist with flashback area log_archive_dest_1='location

SQL> alter system set log_archive_dest_1='location=E:\archivelog' scope=spfile;

or Method 2

Leave the flashback field blank

SQL> alter system set db_recovery_file_dest='';

Set the archive log path again

SQL> alter system set log_archive_dest='E:\archivelog' scope=spfile;

II. No default flashback area, direct execution. The following two methods are available.

Method 1:

SQL> alter system set log_archive_dest='E:\archivelog' scope=spfile;

Method 2:

SQL> alter system set log_archive_dest_1='location=E:\archivelog' scope=spfile;

3. Set archive diary style

sql>alter system set log_archive_format="arch_%t_%s_%r.log" scope=spfile;

Close the database

sql> shutdown immediate;

5. Open the control file without opening the data file

sql> startup mount;

6. Switch the database to archive mode

sql> alter database archivelog;

7. Open the data file

sql> alter database open;

Confirm database status is OPEN

sql> select status from v$instance;

8. Check whether it is in archive mode at this time

sql> archive log list;

The above is "how to migrate the database in advance related parameters to modify" all the content of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.