Alok Giri Oracle

Steps below. 1) Backup the database. 2) Shut down and startup the database in nomount mode. $ sqlplus SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 1 12:52:44 2010 Copyright (c) 1982, 2008, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 1.6034E+10 bytes Fixed Size 2127408 bytes Variable Size 1610615248 bytes Database Buffers 1.4361E+10 bytes Redo Buffers 60174336 bytes SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options $ 3) Copy the non-asm files to asm diskgroup. [oracle]$ rman nocatalog Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jan 1 12:57:14 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. RMAN> connect target RMAN> sql 'alter database mount...

Solution To Flashback primary database execute following steps : 1. Shutdown primary database . SQL> SHUTDOWN IMMEDIATE 2. Start primary database in mount stage SQL> STARTUP MOUNT 3. Flashback primary database to specified scn SQL> FLASHBACK DATABASE TO SCN <scn_number>; 4. Open primary database with reset logs. SQL> ALTER DATABASE OPEN RESETLOGS; 5. Cancel media recovery on the standby database. SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; 6. Check current_scn on the standby database, If flashback scn is greater then current_scn then skip next step (step 7). SQL> SELECT CURRENT_SCN FROM V$DATABASE; 7. Flashback Standby database SQL> FLASHBACK STANDBY DATABASE TO SCN <scn_number -2>; (on standby database) 8. Start managed recovery on the standby database . SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

There are performance issues associated with incremental backups as the whole of each datafile must be scanned to identify changed blocks. In Oracle 10g it is possible to track changed blocks using a change tracking file. Enabling change tracking does produce a small overhead, but it greatly improves the performance of incremental backups. The current change tracking status can be displayed using the following query. SELECT status FROM v$block_change_tracking; Change tracking is enabled using the   ALTER DATABASE   command. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; By default the change tracking file is created as an Oracle Managed File (OMF) in the location pointed to by the   DB_CREATE_FILE_DEST   parameter. An alternate location can be specified using the following command. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING    USING FILE '/u01/oradata/MYSID/rman_change_track.f' REUSE; The tracking file is created with a minumum size of 10M and grows in 1...

General RAC Is rcp and/or rsh required for normal Oracle RAC operation ? What is Cache Fusion and how does this affect applications? Is it difficult to transition (migrate) from Single Instance to Oracle RAC? What are the dependencies between OCFS and ASM in Oracle Database 10g ? Do we have to have Oracle Database on all nodes? What software is necessary for Oracle RAC? Does it have a separate installation CD to order? What Application Design considerations should I be aware of when moving to Oracle RAC? What kind of HW components do you recommend for the interconnect? How can a NAS storage vendor certify their storage solution for Oracle RAC ? My customer has an XA Application with a Oracle RAC Database, can I do Load Balancing across the Oracle RAC instances? Should the SCSI-3 reservation bit be set for our Oracle Clusterware only installation? How do I determine which node in the cl...