Přepnutí cluster databáze do archívního módu

C:\Documents and Settings\solar>srvctl status database -d racdb
Instance racdb1 is running on node node-one
Instance racdb2 is running on node node-two

C:\Documents and Settings\solar>srvctl stop database -d racdb -o immediate

C:\Documents and Settings\solar>srvctl start database -d racdb -o mount

C:\Documents and Settings\solar>sqlplus sys@racdb as sysdba

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination D:\oracle\product\10.2.0\db\RDBMS
Oldest online log sequence 33250
Current log sequence 33251
SQL> show parameter reco

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
db_recovery_file_dest string
db_recovery_file_dest_size big integer 0
recovery_parallelism integer 0
SQL> alter system set db_recovery_file_dest_size = '400G' scope=both sid='*';

System altered.

SQL> alter system set db_recovery_file_dest = '+DATA0' scope=both sid='*';

System altered.

SQL> alter database archivelog;

Database altered.

SQL> select LOG_MODE from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> show parameter reco

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
db_recovery_file_dest string +DATA0
db_recovery_file_dest_size big integer 400G
recovery_parallelism integer 0
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 33250
Next log sequence to archive 33251
Current log sequence 33251

C:\Documents and Settings\solar>srvctl stop database -d racdb -o immediate

C:\Documents and Settings\solar>srvctl start database -d racdb -o open

C:\Documents and Settings\solar>srvctl status database -d racdb
Instance racdb1 is running on node node-one
Instance racdb2 is running on node node-two

C:\Documents and Settings\solar>sqlplus sys@racdb as sysdba

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL>

Komentáře