Pages

Monday, July 25, 2011

Data Guard - 1 ( Physical Standby )

Standby databases may be set up in two ways.
1. Physical
2. Logical

The characteristics and pros n cons can be discussed in parallel with setup details.

Physical Standby :- Its a physical copy of the primary database. Till 10g the physical standby is kept open in "mount" mode so of actually no use other then a disaster recovery. But 11g onwards the physical standby database can also be used for queries and reporting as the open mode for the standby database can be "read_only".

For creating standby using RMAN, below can be the steps.
( Primary database is ORCL and standby is STANDBY in below example which is the db_unique_name for them, while ORACLE_SID and the DB_NAME is same i.e.ORCL)

Monday, July 4, 2011

Drop Database

To Drop a database we can directly use oracle command "Drop database". And this makes it easy enough clearing all the data and control files.

To drop the database we need to start the database in mount restricted mode.

The sequence of commands is as follows:-

Friday, July 1, 2011

Rename datafiles

Renaming may mostly mean moving a datafile. Moving a datafile may be a need of some scenario where the OS mount/drive is running out of space (as the datafile name involves the complete path), or files management etc.
For any of the case if we want to rename a datafile we have multiple approaches.
a. Taking Database Down
b. Taking Tablespace offline
c. Taking datafile offline