18.4 manage physical backup Databases

1. Start the physical backup database

2. Start application redo

3. Close the physical backup database

4. Open the physical standby database in read-only mode

5. Activate the physical backup database

C: \> sqlplus sys/orcl @ standby2 as sysdba

SQL * Plus: Release 10.2.0.1.0-production on Tuesday February 17 14:55:37 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Already connected to the idle routine.

SQL> startup Mount
The Oracle routine has been started.

Total system global area 603979776 bytes
Fixed size 1250380 bytes
Variable Size 163580852 bytes
Database buffers 432013312 bytes
Redo buffers 7135232 bytes
The database has been loaded.
SQL> alter database recover managed standby database disconnect from session;

The database has been changed.

SQL> select process, status from V $ managed_standby;

Process status
---------------------
Arch connected
Arch connected
Mrp0 applying_log

SQL> select process, status from V $ managed_standby;

Process status
---------------------
Arch connected
Arch connected
Mrp0 wait_for_log

SQL> alter database recover managed standby database cancel;

The database has been changed.

SQL> shutdown immediate
ORA-01109: the database is not open

The database has been detached.
The Oracle routine has been disabled.
SQL> startup
The Oracle routine has been started.

Total system global area 603979776 bytes
Fixed size 1250380 bytes
Variable Size 163580852 bytes
Database buffers 432013312 bytes
Redo buffers 7135232 bytes
The database has been loaded.
The database has been opened.
SQL> select * from test;

C
----------
1
3

SQL> insert into test values (4 );
Insert into test values (4)
*
Row 3 has an error:
ORA-16000: Open the database for read-only access

SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-01531: Instance opened database

SQL> alter database Activate standby database;
Alter database Activate standby Database
*
Row 3 has an error:
ORA-01577: unable to add Log File 'd: \ standby2 \ redo01.log'-the file is part of the database

SQL> shutdown immediate
ORA-01109: the database is not open

The database has been detached.
The Oracle routine has been disabled.

SQL> startup
The Oracle routine has been started.

Total system global area 603979776 bytes
Fixed size 1250380 bytes
Variable Size 163580852 bytes
Database buffers 432013312 bytes
Redo buffers 7135232 bytes
The database has been loaded.
The database has been opened.
SQL> alter database Activate standby database;

The database has been changed.