NOARCHIVELOG DATABASE RECOVERY VIA RMAN

Your database is running in No Archive log mode and you have daily/weekly RMAN backup configured.

One fine day, your server crashed and you lose one of the disks or all the disks.

You have no other option but to restore the whole database backup to point of last valid backup.

rman target / catalog rman10/rman10@rman10s

Recovery Manager: Release 10.1.0.3.0 - Production

Connected to target database (not started)

Connected to recovery catalog database

RMAN>

RUN

{

STARTUP NOMOUNT FORCE;

ALLOCATE CHANNEL CH1 DEVICE TYPE 'SBT_TAPE'

PARMS 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.orcld.opt)';

RESTORE SPFILE;

SHUTDOWN IMMEDIATE;

STARTUP NOMOUNT;

RESTORE CONTROLFILE;

ALTER DATABASE MOUNT;

RESTORE DATABASE;

ALTER DATABASE OPEN RESETLOGS;

}

Startup failed: ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/freespace/ORACLE/OCM/prod10gr1/dbs/initorcl.ora'

Trying to start the Oracle instance without parameter files...

Oracle instance started

Total System Global Area 142606336 bytes

Fixed Size 778072 bytes

Variable Size 70525096 bytes

Database Buffers 67108864 bytes

Redo Buffers 4194304 bytes

Allocated channel: CH1

Channel CH1: Sid=28 devtype=DISK

Starting restore at 11-FEB-07

Channel CH1: starting datafile backupset restore

Channel CH1: restoring SPFILE

Output filename=/freespace/ORACLE/OCM/prod10gr1/dbs/spfileorcl.ora

Channel CH1: restored backup piece 1

Piece handle=/freespace/ORACLE/OCM/orcl/ORCL.20070211.8.1.1.614285217 tag=TAG20070211T184641

Channel CH1: restore complete

Finished restore at 11-FEB-07

Oracle instance shut down

connected to target database (not started)

Oracle instance started

Total System Global Area 1241513984 bytes

Fixed Size 778896 bytes

Variable Size 347348336 bytes

Database Buffers 889192448 bytes

Redo Buffers 4194304 bytes

Starting restore at 11-FEB-07

allocated channel: ORA_DISK_1

Channel ORA_DISK_1: Sid=159 devtype=DISK

Channel ORA_DISK_1: starting datafile backupset restore

Channel ORA_DISK_1: restoring controlfile

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/freespace/ORACLE/OCM/orcl/ORCL.20070211.8.1.1.614285217 tag=TAG20070211T184641

Channel ORA_DISK_1: restore complete

Output filename=/freespace/ORACLE/OCM/orcl/control01.ctl

Output filename=/freespace/ORACLE/OCM/orcl/control02.ctl

Output filename=/freespace/ORACLE/OCM/orcl/control03.ctl

Finished restore at 11-FEB-07

Database mounted

Released channel: ORA_DISK_1

Starting restore at 11-FEB-07

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: Sid=159 devtype=DISK

Channel ORA_DISK_1: starting datafile backupset restore

Channel ORA_DISK_1: specifying datafile(s) to restore from backup set

Restoring datafile 00001 to /freespace/ORACLE/OCM/orcl/system01.dbf

Restoring datafile 00002 to /freespace/ORACLE/OCM/orcl/undotbs01.dbf

Restoring datafile 00003 to /freespace/ORACLE/OCM/orcl/sysaux01.dbf

Restoring datafile 00004 to /freespace/ORACLE/OCM/orcl/users01.dbf

Channel ORA_DISK_1: restored backup piece 1

Piece handle=/freespace/ORACLE/OCM/orcl/ORCL.20070211.7.1.1.614285202 tag=TAG20070211T184641

Channel ORA_DISK_1: restore complete

Finished restore at 11-FEB-07

Database opened

New incarnation of database registered in recovery catalog

Starting full resync of recovery catalog

Full resync complete

ORA-65139: Mismatch between XML metadata file and data file

Error: CDB$ROOT@EBTUPRDC> CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse; CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse * ERROR at line 1: ORA-65139: Mismatch between XML metadata file and data file /u05/odb/ORADATA_1/EBTUSPRDC/datafile/system.1531.807800993 for value of fcpsb (2230502002 in the plug XML file, 2230505492 in the data file) Fix: Don't open Non-CDB database until we complete pdb creation other wise we will get above error. Shutdown immediate; startup mount; alter database open read only; create xml file. shutdown immediate; Connect to CDB and Create Pluggable database .

Useful OEM Queries to get Target details from OEM Repository

List Targets with TNS Listener ports configured : SELECT mgmt$target.host_name , mgmt$target.target_name , mgmt$target.target_type , mgmt$target_properties.property_name , mgmt$target_properties.property_value FROM mgmt$target , mgmt$target_properties WHERE ( mgmt$target.target_name = mgmt$target_properties.target_name ) AND ( mgmt$target.target_type = mgmt$target_properties.target_type ) and ( mgmt$target.target_type = 'oracle_listener' ) and ( mgmt$target_properties.property_name = 'Port' ); Devora02 LISTENER_ora02 oracle_listener Port 1529 Devora01 LISTENER_ora01 oracle_listener Port 1529 Devora04 LISTENE...

TFA-00002 : Oracle Trace File Analyzer (TFA) is not running

TFA Failed to start listening for commands on one of the Rac Node : As a root user /etc/init.d/init.tfa start Starting TFA.. start: Job is already running: oracle-tfa Waiting up to 100 seconds for TFA to be started.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Successfully started TFA Process.. . . . . . TFA-00002 : Oracle Trace File Analyzer (TFA) is not running TFA Failed to start listening for commands Solution : run synctfanodes.sh if you have root password . if no root password copy below files to TFA Failed node and try to restart TFA .. Please check whether these 4 files exist on all nodes are similar. TFA_HOME/server.jks TFA_HOME/client.jks TFA_HOME/internal/ssl.properties TFA_HOME/internal/ portmapping.txt If not similar just copy these files to TFA Failing node and try TFA Restart ..It Worked for me . [root@host01]# ./tfactl -v "debug" start Starting TFA...

ORACLE DATABASE

Search This Blog