Posts

Showing posts from November, 2021

RMAN Database Restore from ASM (NON-RAC) TO File System (NON-RAC)

RMAN Database Restore from ASM to File System RMAN Database Restore from ASM (NON-RAC) TO File System (NON-RAC) 0. Environment On Source Server 1. Backup database 2. Create pfile from spfile 3. Push backup files/pfile to target server On Target Server 4. Edit pfile 5. Create Required Folders 6. Add the entry in oratab 7. Startup Nomount 8. Restore controlfile 9. Mount database 10. Catalog backup pieces 11. Restore/recover database 12. Change dbname/DBID uisng NID 13. Modify DB_NAME in init file and start the database 14. Add TNS entry 15. Verify 0. Environment Source: DB: SBPROD, Diskgroup: DATA Node: YesBrac1, DB Version: 11.2.0.3 Target: DB: YESBTEST, File System: /u01 Node: YesBrac2, DB Version: 11.2.0.3 On Source SERVER ================== Step 1: Backup database w148p – source [oracle@YesBrac1 ~]$ cat open0.rcv run { allocate channel t1 type disk; backup incremental level 0 database format '/u01/share/backup/database_%d_%u_%s'; release channel t1; } sql '