ERROR -- ISSUED

-
ERROR --1 

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

SOLUTIUON::

alter system set "_no_recovery_through_resetlogs"=TRUE scope=both;

System altered.

SQL>  shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 3206836224 bytes
Fixed Size                  2232640 bytes
Variable Size            1140854464 bytes
Database Buffers         2046820352 bytes
Redo Buffers               16928768 bytes
Database mounted.
SQL> alter database open resetlogs;

Database altered.





 ERROR 

IN CASE OF FULL DB RESTORATION ON  STANDBY WE ARE GETTING 

RMAN RESTORE ends with ORA-01180: can not create datafile

creating datafile fno=1 name=/u01/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/01/2010 00:00:01
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/u01/system01.dbf'

SOLUTION-

run 
{
crosscheck archivelog all;
delete noprompt expireD archivelog all;
}

DELETE EXPIRED BACKUP

RMAN> list incarnation of database;
RMAN> list backup of datafile 1;
RMAN> list copy of datafile 1;
RMAN> list backup summary;




RMAN> list backup of datafile 1;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
138 

 RMAN> crosscheck backupset 138;


RMAN> list backup of datafile 1;

 RMAN> list incarnation of database;
 RMAN> reset database to incarnation 11;

 NOW RESTORE DATABASE 








Comments

Post a Comment

Popular posts from this blog

ORACLE GOLDENGATE

-
Image
1)  GoldenGate Setup & Configuration On Source & Target Hosts Perform the Following On Source: Unzip the GG Software and Perform the installation & Configuration [oracle@targethost]/data # unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip [oracle@targethost]/data # tar -xvf ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip [oracle@sourcehost]/data/ggate # ./ggsci GGSCI (targethost) 1> create subdirs 1. Ensure The database is in archive log mode 2. Create Necessary tablespace and goldengate user in database SQL> create tablespace ggs_data datafile '/data/GGS/Base/ggs_data01.dbf' size 200m; SQL> create user ggs_owner identified by ggs_owner default tablespace ggs_data temporary tablespace temp; SQL> grant connect,resource to ggs_owner; SQL> grant select any dictionary, select any table to ggs_owner; SQL> grant create table to ggs_owner; SQL> grant flashback any table to ggs_owner; SQL> grant execute on dbms_flashback to...
Read more

ORACLE RAC QUESTION

-
Image
                                  RAC               What   is   Cluster ? A cluster provides an optional method of storing table data. A cluster is made up of a group of tables that share the same data blocks. The tables are grouped together because they share common columns and are often used together          OR Two or more computers that share resources and work together to form a larger logical computing unit. RAC and Oracle Parallel Server can be used to access Oracle from multiple nodes of a clustered system. What is   oracle clusterware ? Oracle Clusterware is software that enables servers to operate together as if they are one server. Each server looks like any standalone server. H...
Read more

CREATING SCHEDULER JOBS

-
DBA_SCHEDULER_JOB_RUN_DETAILS DBA_SCHEDULER_JOBS exec dbms_scheduler.disable('"ETCSSP"."CUSTOMER_UNIFIED_JOB2"'); EXEC DBMS_SCHEDULER.DROP_PROGRAM(program_name=>'"ETCSSP"."SP_UNVERIFIEDLOANS_MAPPED_JOB1"',FORCE=>TRUE); EXEC DBMS_SCHEDULER.DROP_JOB (job_name => 'CUSTOMER_UNIFIED_JOB2'); SELECT OWNER,JOB_NAME,STATUS,ERROR# FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME='CUSTOMER_UNIFIED_JOB2'; BEGIN sys.dbms_scheduler.create_job( job_name => '"ETCSSP"."SP_UNVERIFIEDLOANS_MAPPED_JOB1"', job_type => 'STORED_PROCEDURE', job_action => '"ETCSSP"."SP_UNVERIFIEDLOANS_MAPPED"', repeat_interval => 'FREQ=DAILY; BYHOUR=22; BYMINUTE=30; BYSECOND=0;', start_date => systimestamp at time zone 'Asia/Calcutta', job_class => '"DEFAULT_JOB_CLASS"', comments => 'UNVERIFIED LOAN MAPPE...
Read more