how to changing the RAC 10g Database Archiving Mode
来源:互联网 发布:p2p理财安全吗 知乎 编辑:程序博客网 时间:2024/05/01 19:02
=== ODM Answer ===
Que:
how to changing the RAC 10g Database Archiving Mode?
Ans:
The following steps need to be taken to enable archive logging in a RAC database environment:
--1. set your log_archive_dest1 parameters to a shared location
SQL> conn / as sysdba
SQL> alter system set log_archive_dest_1='location=<ASM_DISKGROUP_NAME>' ;
--2. shutdown immediate all database instances
$ srvctl stop database -d <db_unique_name>
--3. startup database in mount mode
$ srvctl start database -d <db_unique_name> -o mount
--4. enable archvive logging
$ sqlplus / as sysdba
sql> alter database archivelog;
sql> exit;
--5. stop database
$ srvctl stop database -d <db_unique_name>
--6. restart all database instances
$ srvctl start database -d <db_unique_name>
--7. verify archiving is enabled by means of:
sql> archive log list;
=== ODM Answer ===
There's two questions:
1.Needn't set the parameter LOG_ARCHIVE_FORMAT?
==>LOG_ARCHIVE_FORMAT has the default value, so we need not set it, but if you want to change the archived log format, you can set this init parameter.
2.In the third step,is it just start mount one instance?
==>yes, change database to archivelog mode, which need in the mount status. This is the same with standalone database.
- how to changing the RAC 10g Database Archiving Mode
- Changing the Database Archiving Mode
- 第八章configuring the database archiving mode
- How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure
- How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure
- How to change single-instance database to RAC(10g)
- How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure [ID 747457.
- How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure (文档 ID 7474
- Convert 10g Single-Instance database to 10g RAC
- How to create a Oracle 11g RAC Database manually without DBCA ?
- how to clear CRS/RAC for 10/11g
- Changing the Favicon in PeopleSoft – The “How to”
- Changing the database characterset from US7ASCII to WE8MSWIN1252
- 72.You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG
- Tell you how to resolve Oracle 10g EM login problem: The database status is currently unavailable.
- Convert a Single Instance Database to Oracle RAC 10g on RHEL3
- Convert Oracle 9i Single-Instance database to 10g RAC .
- C# how to connect the database
- 事件处理
- Linux 随机起动
- 在已有网站下创建虚拟目录
- life小语11
- 发送邮件
- how to changing the RAC 10g Database Archiving Mode
- alter system/session set events详解
- udp包大小选折及原因(mtu)
- twaver flex学习及资料网站
- Linux命令行屏幕分辨率(console resolution)调整
- Javascript和CSS浏览器兼容总结
- 删除dataGridView中单元格数据(某列) 方法一
- Android UI开发专题——各种Drawable
- 黑马程序员 (9)JAVA高新技术 3