Standby database on Oracle 8i

Adding Tablespaces or Datafiles to the Primary Database

To add a tablespace or datafile to the primary database and create the datafile in the standby database:

1. Create a tablespace on the primary database as usual. For example, to create new datafile t_db2.f in tablespace tbs_2, issue:

SQL> CREATE TABLESPACE tbs_2 DATAFILE 't_db2.f' SIZE 2M; 

4. Switch redo logs on the primary database to initiate redo archival to the standby database:

SQL> ALTER SYSTEM SWITCH LOGFILE;

If the recovery process on the standby database tries to apply the redo containing the CREATE TABLESPACE statement, it stops because the new datafile does not exist on the standby site.

5. Either wait for the standby database to cancel recovery because it cannot find the new datafile, or manually cancel managed recovery:

SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;

5. Note that CREATE TABLESPACE redo adds the new filename to the standby control file. The following alert.log entry is generated:

WARNING! Recovering datafile 2 from a fuzzy file. If not the current file it

might be an online backup taken without entering the begin backup command.

Successfully added datafile 2 to media recovery

Datafile #2: '/private1/stby/t_db2.f'

6. Create the datafile on the standby database. For example, issue:

SQL> ALTER DATABASE CREATE DATAFILE '/private1/stby/t_db2.f'

                                 AS '/private1/stby/t_db2.f';

7. Place the standby database in managed recovery mode:

SQL> RECOVER MANAGED STANDBY DATABASE;

Continue normal processing on the primary database. The primary and standby databases are now synchronized.