RMAN Full Backup and Restore to New Server (Live)

New Server Install Software Only, 

Required

---------

1. Password file Backup

2. SPFILE or PFILE backup

3. Cotrolfile Backup

4. Database Full Backup ( if want to sync copy the archive also)

START 

Step-1. 

Copy All Backup files from your production to Newly created server.

Check Directory Structure 

Step-2. 

Check Directory structure of your production, In my case as. 

Datafile Location/u01/app/oracle/oradata/db11g/

Controlfile Location: 

/u01/app/oracle/oradata/db11g/control01.ctl 

/u01/app/oracle/fast_recovery_area/db11g/control02.ctl 

/u01/app/oracle/control03.ctl 

DB Name: dbl9c

Step-3. 

Start Restoration 

1. Copy Password file on Location. 

2. Start database at nomount using spfile or pfile. 

3. Restore controlfile using controlfile backup. 

4. Restore Database. 

5. Recover Database. 

6. Open Database.

# Full Backup

RMAN> backup database;

Starting backup at 18-FEB-25

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=38 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/DB19C/system01.dbf

input datafile file number=00003 name=/u01/app/oracle/oradata/DB19C/sysaux01.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/DB19C/undotbs01.dbf

input datafile file number=00007 name=/u01/app/oracle/oradata/DB19C/users01.dbf

channel ORA_DISK_1: starting piece 1 at 18-FEB-25

channel ORA_DISK_1: finished piece 1 at 18-FEB-25

piece handle=/u01/app/oracle/fast_recovery_area/DB19C/backupset/2025_02_18/o1_mf_nnndf_TAG20250218T154256_mv8ok14o_.bkp tag=TAG20250218T154256 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15

Finished backup at 18-FEB-25

Starting Control File and SPFILE Autobackup at 18-FEB-25

piece handle=/u01/app/oracle/fast_recovery_area/DB19C/autobackup/2025_02_18/o1_mf_s_1193413452_mv8omglx_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 18-FEB-25

RMAN> exit

192.168.50.204

----------------------------------------------

# chown oracle:oracle /u02/backup

# chmod 755 /u02/backup

$ scp o1_mf_nnndf_TAG20250218T154256_mv8ok14o_.bkp oracle@192.168.50.204:/u02/backup

$ cd /u01/app/oracle/fast_recovery_area/DB19C/autobackup/2025_02_18

$ scp o1_mf_s_1193413452_mv8omglx_.bkp oracle@192.168.50.204:/u02/backup

$ cd $ORACLE_HOME/dbs

$ ls -lrt

$ scp orapwdb19c spfiledb19c.ora oracle@192.168.50.204:/u02/backup

$ cp orapwdb19c spfiledb19c.ora /u01/app/oracle/product/19.0.0/dbhome_1/dbs/

# Create and Create directory viewing PFILE  

SQL> create pfile='/u02/backup/init.ora' from spfile;

[oracle@db19c ~]$ cat /u02/backup/init.ora

db19c.__data_transfer_cache_size=0

db19c.__db_cache_size=1258291200

db19c.__inmemory_ext_roarea=0

db19c.__inmemory_ext_rwarea=0

db19c.__java_pool_size=0

db19c.__large_pool_size=16777216

db19c.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

db19c.__pga_aggregate_target=603979776

db19c.__sga_target=1778384896

db19c.__shared_io_pool_size=83886080

db19c.__shared_pool_size=402653184

db19c.__streams_pool_size=0

db19c.__unified_pga_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/db19c/adump'

*.audit_trail='db'

*.compatible='19.0.0'

*.control_files='/u01/app/oracle/oradata/DB19C/control01.ctl','/u01/app/oracle/fast_recovery_area/DB19C/control02.ctl'

*.db_block_size=8192

*.db_name='db19c'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=8256m

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=db19cXDB)'

*.nls_language='AMERICAN'

*.nls_territory='AMERICA'

*.open_cursors=300

*.pga_aggregate_target=562m

*.processes=300

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=1686m

*.undo_tablespace='UNDOTBS1'

[oracle@db19c ~]$

# mkdir -p /u01/app/oracle/admin/db19c/adump

# mkdir -p /u01/app/oracle/oradata/DB19C

# mkdir -p /u01/app/oracle/fast_recovery_area/DB19C

# chown -R oracle:oinstall /u01/app/oracle/admin/db19c/adump

# chown -R oracle:oinstall /u01/app/oracle/oradata/DB19C

# chown -R oracle:oinstall /u01/app/oracle/fast_recovery_area/DB19C

# chown -R oracle:oinstall /u02/backup/

# chmod 770 /u02/backup/

$ rman target /

RMAN> restore controlfile from '/u02/backup/o1_mf_s_1193413452_mv8omglx_.bkp';

RMAN> alter database mount

RMAN> catalog start with '/u02/backup/';

RMAN> recover database;

RMAN> exit

$ sqlplus / as sysdba

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

Database altered.

SQL> select count(*) from tab;

  COUNT(*)

----------

      8281