We can use RMAN incremental backup to roll forward the physical standby database in the following situations: 1. when an archive sequence is missing 2. when lots of archives needs to be applied
Steps:
1. Take the current SCN of the standby database
SQL> select to_char(current_scn) scn from v$database; [...]
Archive for the ‘Standby Database’ Category
Applying RMAN Incremental Backup To Standby Database
Posted in Standby Database on September 20, 2008 | Leave a Comment »
Standby Database Creation
Posted in Standby Database on March 21, 2008 | Leave a Comment »
Steps to create the physical standby database:1. Take the backup of production database2. Create standby controlfile3. Copy the backup, standy controfile and init.ora files to standby box4. Create necessary directories5. Edit the init.ora file6. Mount the database7. Restore the database8. Start the recovery
1. Take the backup of production databaserman> run {allocate channel c1 type disk [...]
Managing Standby Database
Posted in Standby Database on January 12, 2008 | Leave a Comment »
Start the standby database
startup nomount;alter database mount standby database;alter database recover managed standby database disconnect;
Shutdown the standby database
alter database recover managed standby database cancel;shutdown immediate;Registering the archive logs manualy
alter database register or replace logfile ‘/opt/oracle/archive/oradb_1_1234_48540.arc’;
Opening standby database in READ ONLY modealter database recover managed standby database cancel;
alter database open read only;
From READ ONLY mode to [...]
STANDBY DB ISSUES
Posted in Standby Database on November 22, 2007 | Leave a Comment »
These are some of the issues which i have faced while managing the physical standby database:
1. ORA-00368: Checksum error 2. ORA-01119: Error in creating database file
1. ORA-00368: Checksum error ORA-00368: checksum error in redo log blockORA-00353: log corruption near block 10241 change 2700 time 11/22/2007 ORA-00334: archived log: ‘/archivelog/oradb1_arc_10444_596803436.arc’
Reason for the above error:If checksum of [...]
Create Read-Write copy from Standby database.
Posted in Standby Database on October 20, 2007 | Leave a Comment »
Step by step procedure to Create a Read-Write copy from the Standby database on the same box.
Steps are devided into three parts
Part 1: Create new database
Part 2 : Rename the database
Part 3 : Start the standby database
Standby database name : stbydb
Read-Write copy database name : rwdb
Part 1: Create new database
1. Identify all the datafiles, redo [...]
