How to Move datafile from ASM to ASM

Today got archiver error issue due to our FRA is full. reason for that is some datafile are created inside the +FRA.
My Task now is to move the datafiles from +FRA to +DATA since we already increased it.

Got permission from application to take below datafiles offline for a short period of time.

 
   FILE_ID TABLESPACE_NAME                FILE_NAME
---------- ------------------------------ --------------------------------------------------
       151 DATA_XXX                       +FRA/xxxclpt2/datafile/data_xxx.1410.908245675
       152 DATA_XXX                       +FRA/xxxclpt2/datafile/data_xxx.1451.908245731
       153 DATA_XXX                       +FRA/xxxclpt2/datafile/data_xxx.1487.908245783
       154 DATA_XXX                       +FRA/xxxclpt2/datafile/data_xxx.380.908245805
       102 OPDB_DATA                      +FRA/xxxclpt2/datafile/opdb_data.1938.911645643
       155 DATA_XXX                       +FRA/xxxclpt2/datafile/data_xxx.2026.916987355
       156 DATA_XXX                       +FRA/xxxclpt2/datafile/data_xxx.1457.916987395
       157 DATA_XXX                       +FRA/xxxclpt2/datafile/data_xxx.1363.916987403
       158 DATA_XXX                       +FRA/xxxclpt2/datafile/data_xxx.1862.916987409
       159 DATA_RGN                       +FRA/xxxclpt2/datafile/data_rgn.2063.916987425
       160 DATA_RGN                       +FRA/xxxclpt2/datafile/data_rgn.1822.916987437
       161 DATA_RGN                       +FRA/xxxclpt2/datafile/data_rgn.2077.916987509
       162 DATA_RGN                       +FRA/xxxclpt2/datafile/data_rgn.1848.916987523
       163 INDEX_KYC                      +FRA/xxxclpt2/datafile/index_kyc.1900.916987543
       164 INDEX_KYC                      +FRA/xxxclpt2/datafile/index_kyc.2035.916987549

15 rows selected.

Continue reading

ORA-17628: Oracle error 19505 returned by remote Oracle server

I have colleague of mine handed over a failed RMAN duplication issue…
after fixing the issue i started again the active duplicate.

but when its almost done… i got below error

 
input datafile file number=00023 name=+DATA/cxxxxsit/datafile/oxxx_data.357.873341887
RMAN-03009: failure of backup command on c8 channel at 03/25/2016 06:57:03
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run

checking the alert log… ASM was exhausted. seems the old files from previous failed Active Duplication was not remove.
my mistake.. 😦

lessons learned… before doing any activity.. do the pre checks… 🙂
and below note is very helpful.

 
Known issues on ORA-17628: Oracle error 19505 returned by remote Oracle server Reported in Rman Active Duplicate (Doc ID 1401333.1)

Thanks!

ORA-00245: control file backup failed; target is likely on a local file system

Basically one day at work, my colleague handed over an issue related to RMAN.

 
Starting backup at 14-FEB-2016 06:02:44
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1444 instance=CXXXEU22 device type=DISK channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/14/2016 06:02:46
ORA-00245: control file backup failed; target is likely on a local file system
 Continue reading 

RMAN Restore from Tape to Diff Host DBName on ASM

A little bit busy this week … my boss ask me to validate the RMAN tape backup if we can really restore it.

Note : restore database validate is not an option 🙂

Source and target are both clustered database.

Source DB: CNCXXU
Source Server : ncxxdsmwu01/ncxxdsmwu02

Target DB: NCXX2PT
Target Server : ncxxdsgtu21/ncxxdsgtu22

1. Shutdown the target database and delete all files in ASM
2. Start the database in nomount and restore the spfile.
– spfile and controlfile backup is going to disk.
– no rman catalog
Continue reading

RMAN-20020: database incarnation not set

usually it happens when you do alter database open resetlogs..

RMAN> resync catalog;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 04/04/2014 05:25:29
RMAN-20020: database incarnation not set

RMAN> reset database;

database incarnation already registered
starting full resync of recovery catalog
full resync complete

RMAN>

Resync Physical standby using RMAN Incremental backup

Just another day at the office, our production database has 2 physical standby and it lagging for more that 1000 archives.
the reason is the password was changed and the password file was not copied to standby.

below are the steps i did to resync the standby. for the first standby i tried to restore archive but its taking time .

NOTE:
– Primay and Standby filesystem is the same.
– Shared NFS is mounted on both server.

Continue reading