Oracle RMAN – Is Backup Platform Independent?

oraclerman

I have RMAN backup from AIX server and want to restore on Linux OS. Could you please let me know if there is a way to do it?

Thanks a lot for help in this regard.

Best Answer

Query this table in order for you to see the platforms to which rman can convert your

SYS@EMR> select * from V$DB_TRANSPORTABLE_PLATFORM;

PLATFORM_ID PLATFORM_NAME                                                                                         ENDIAN_FORMAT
----------- ----------------------------------------------------------------------------------------------------- --------------
          7 Microsoft Windows IA (32-bit)                                                                         Little
         10 Linux IA (32-bit)                                                                                     Little
          5 HP Tru64 UNIX                                                                                         Little
         11 Linux IA (64-bit)                                                                                     Little
         15 HP Open VMS                                                                                           Little
          8 Microsoft Windows IA (64-bit)                                                                         Little
         13 Linux x86 64-bit                                                                                      Little
         12 Microsoft Windows x86 64-bit                                                                          Little
         17 Solaris Operating System (x86)                                                                        Little
         19 HP IA Open VMS                                                                                        Little
         20 Solaris Operating System (x86-64)                                                                     Little
         21 Apple Mac OS (x86-64)                                                                                 Little

Step by Step restore

Connect to the target database using rman and backup the database - Source Node/ System
copy following files to the Destination node ( backup pieces , control file backup and parameter file)
Perform the modificaiton on destionation node to parameter file - PFILE
Once the pfile is ready, set the environment parameter and connect to rman
connect to target - start up the db no mount mode
now restore the controlfile from the backup on destination node (which copied from source db )

Example :

restore controlfile from '/backup/file name';

once the restore is complete - mount the db.

now main step is backup prices which you copied from the source db to destination db catalog themcatalog the backup pieces.
Now, you need to recover the db - find he sequence number

list backup of archivelog all;
Rename the Redologfiles

alter database rename file
Now final step is you need to recover the db to the last sequence number

Execute this series of statements:
set until sequence 123456; -- sequence which you go previous. set newname for datafile 1 to '/node2/database/db1/system01.dbf'; -- data file paths modified
```
restore database; 
switch datafile all; 
recover database; 
alter database open resetlogs;
```

2 As a second approach this can be done using the Oracle Transportable Database - follow the link for great article form IBM guys !

Related Solutions

Exadata RMAN vs. Non-Exadata RMAN – any differences

There are no architecture differences in RMAN itself. The difference is in the speed of the backups if written to the Exadata on-board storage. So the advantages that Exadata brings in terms of hardware would also translate to advantages in backup speed and MTR (mean time to recovery). But none of those advantages are the result of changes to RMAN.

Oracle RMAN Backup – What Exactly Does It Do?

In the simplest case, when you restore a database, you tell RMAN to recover it to the most recent point in time by applying all the redo (archived and online) that is available. That will re-apply any statements that were executed during normal database operations including things like dropping tables and deleting data. If you want to restore a database to a point in time before something bad happened, you'd need to do a point-in-time recovery with something like

RUN
{ 
    SET UNTIL SCN 1000;    
  # Alternatives:
  # SET UNTIL TIME 'Nov 15 2004 09:00:00';
  # SET UNTIL SEQUENCE 9923;  
  RESTORE DATABASE;
  RECOVER DATABASE;
}

Normally, you'd specify an UNTIL TIME or UNTIL SCN that was just before the first erroneous command.

In general, though, you would try to avoid using RMAN to recover from human errors. Generally, doing a full database restore is a last resort and generally there are other transactions going on that you don't want to lose. If a DBA inadvertently drops a table, for example, you don't want to restore the database and lose all the transactions that other people had made after the table was dropped. You would generally do a FLASHBACK DROP

FLASHBACK TABLE table_I_should_not_have_dropped
       TO BEFORE DROP

to restore the table from the recycle bin (which is almost instantaneous). If you deleted

Best Answer

Step by Step restore

Related Solutions

Exadata RMAN vs. Non-Exadata RMAN – any differences

Oracle RMAN Backup – What Exactly Does It Do?

Related Question