Contents
How do I migrate an ASM disk to another server?
From all nodes Copy the pfiles from the existing system for ASM and the database to new server. Dismount diskgroups from old server and mount the physical devices on the new server. Verify that you can see the disks on the new server. Startup ASM on new server.
How do I restore my ASM?
Step 4: Restore database
- Start instance using the local copy of your pfile from step 1.
- Use RMAN to restore the controlfiles and database.
- Connect to the ASM instance and get the controlfile name.
- Edit the init[sid].
- Re-create the spfile.
- Shutdown and restart the instance to use the newly created spfile.
How do I copy a Spfile?
Making a Back Up Copy of an Oracle ASM SPFILE in a Disk Group
- Locate the Oracle ASM SPFILE using the ASMCMD spget command.
- Copy the Oracle ASM SPFILE to another disk group with spcopy command.
- List all the copies of the Oracle ASM SPFILE file contained in the FRA disk group using the ASMCMD ls command.
How to RMAN database restore from ASM to ASM?
RMAN Database Restore from ASM (NON-RAC) TO ASM (NON-RAC) 1 Step 1: Backup database w148p – source. 2 Step 2: Create pfile from spfile. 3 Step 3: Push backup files/pfile to target server. 4 Step 4: Edit pfile initprpt.ora. 5 Step 5: Create Required Folders [oracle@rac1 ~]$ mkdir -p /u01/app/oracle/admin/prpt/adump [oracle@rac1 ~]$.
How can I restore my database from RMAN?
1. Backup the database in target database server. We can also use recent L0 backup in the tape. 2. FTP the RMAN backups and password file to auxiliary server 3. Restore the SPFILE, 4. Start the instance with nomount mode 5. Restore the control file 6. Mount the database 7. Restore the database 8.
How to restore database to a different host?
Step 12 Verify all the files and make sure all files are moved to ASM disk. Also watch out the alert log for a while. Create the listener and make sure able to connect outside the database server. Now the database is successfully restored in different host. The database is also migrated to ASM disk as part of restore.
How to copy RMAN backup files to auxiliary server?
Step 2 Copy the RMAN backup files to auxiliary server. Create the file system directories on auxiliary server. Here i am using the ASM disk. Hence, the file system directories are not needed. I created the directory in ASM disk. The RMAN backup files are coped to auxiliary server as below.