Dataguard Common Administration commands

Management mode and read-only mode for standby servers

1.1 Repository Boot to admin recovery mode

Sql>shutdown immediate;

Sql>startup Nomount;

Sql>alter database mount standby database;

Sql>alter database recover managed standby database disconnect from session;

1.2 Reserve Library boot to read-only mode

Sql>shutdown immediate;

Sql>startup Nomount;

Sql>alter database mount standby database;

Sql>alter database open Read only;

1.3 From management recovery mode to read-only mode

Sql>recover managed standby database cancel;

Sql>alter database open Read only;

This time, you can add temporary data files to the database (this is not backed up during hot backup) such as

Alter tablespace temp add tempfile '/u02/oradata/boss/temp01.dbf ' size 100M;

Note, however, that there are two ways to manage the files in DG mode (show parameter standby can), automatic and manual management, and if it is automated management, it is impossible to add and rename operations.

For example, the article I sent yesterday

sql> ALTER DATABASE rename file '/bak/datafile/namin_data.dbf ' to '/usr/datafile/namin_data.dbf ';

Alter DATABASE rename file '/bak/datafile/namin_data.dbf ' to '/usr/datafile/namin_data.dbf '

*

ERROR at line 1:

Ora-01511:error in renaming log/data files

Ora-01275:operation RENAME is isn't allowed if standby file management is

Automatic.

Oracle check, in DG Mode, the file has two kinds of management (show parameter standby can check), automatic and manual management, if it is automatic management, can not be renamed, need to be changed to manual mode.

Sql> Show Parameter Standby

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Standby_archive_dest string?/dbs/arch

Standby_file_management string AUTO

Sql> alter system set standby_file_management=manual;

System altered.

Sql> Show Parameter Standby

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Standby_archive_dest string?/dbs/arch

Standby_file_management string MANUAL

sql> ALTER DATABASE rename file '/bak/datafile/namin_data.dbf ' to '/usr/datafile/namin_data.dbf ';

Database altered.