Category Archives: rman

Rman restore problem

I took rman backup from RAC server to restore to another (new) RAC server. I faced some problem while restoring database. Steps are follows RMAN> restore database; Starting restore at 30-OCT-12 using target database control file instead of recovery catalog … Continue reading

Posted in rman | Leave a comment

vipca error

Vipca is not opening new configuration window and is giving error [root@node1 bin]# ./vipca Error 0(Native: listNetInterfaces:[3]) [Error 0(Native: listNetInterfaces:[3])]   To resolve this issue Perform two steps [root@node1 bin]# ./oifcfg setif -global bond0/192.168.0.0:public [root@node1 bin]# ./oifcfg setif -global eth2/192.168.1.0:cluster_interconnect … Continue reading

Posted in Oracle RAC, rman | Tagged | Leave a comment

How to Check/Validate That RMAN Backups Are Good

I Want to restore and recover the database till time ‘9:00, 22-October-2012 Step 1: The below command just gives the report of backups that are used to do the ┬árestore and recover : RMAN> run { set until time “to_date(‘2012-22-10:9:00:00′,’yyyy-dd-mm:hh24:mi:ss’)”; … Continue reading

Posted in rman | Leave a comment

HOW TO CONVERT SCN TO DATE AND DATE INTO SCN

Database SCN number some time is very important 1) particularly when you are doing rman recovery 2) Filling gaps of archive logs between primary server and Physical standby server. Below SQL queries will give SCN for particular date and date … Continue reading

Posted in rman | 1 Comment

Rman backup from production and restore in test machine

We want to make a test database from production database. And our production database is on ASM and our test machine was linux file sysetm. see the steps how we restored it. 1) Start the test database in nomount mode … Continue reading

Posted in rman | Leave a comment

delete expired archive logs

If archive logs are deleted by OS level, these archive logs information will be still in controlfile. So to remove these information from controlfile, you need to crosscheck archive logs and then execute delete expired archive logs. Note: this command … Continue reading

Posted in rman | 2 Comments

RMAN BACKUP SCRIPT

RMAN BACKUP SCRIPT rman backup script which I have scheduled on Oracle RAC of node1 and is working perfectly. backup is taking in compressed mode and after completing the backup will re-schedule for next day and next command will load … Continue reading

Posted in rman | Leave a comment