Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Restore database to a different directory on the same host

Hi.
I have a database (name appdev) of size 200G. we are using ASM. (+DATA/appdev)
i want to restore the database as app2dev on the same diskgroup to a different directory.(+DATA/APP2DEV)
I am planning to do this:
I want to use backup and restore(not duplicate). while restoring i will stop appdev database and restore appdev database to new directory. after restore i will use nid to change the db name.
can i use logfile_name_convert and db_file_name_convert to specify restore to a different directory? if not, can anybody please point me to the right direction?
I appreciate everybody's time.
Answers
-
Hi,
Do the following:
- Set DB ID using RMAN for the new instance
- Take a backup of the Source database
- Create the spfile and password file for the new instance
- Start the DB nomount stage
- Catalog the controlfile
- Restore the Controlfile
- Catalog the all the required backup sets
- Mount the DB
- Restore DB
- Recover DB
- Set new DBID and newname as per requirement.
Thanks &
Best Regards,
-
Ensure that you set DB_UNIQUE_NAME to APPDEV before the RMAN RESTORE.
Hemant K Chitale
-
See Oracle Support Note "How to use rman to restore the Database to a different directory in ASM? (Doc ID 1467481.1)"
Hemant K Chitale
-
Yes. For OMF, the path entirely depends on the db_unique_name of the database. Just a tip
Read below:
Administering Oracle ASM Files, Directories, and Templates
Every file created in Oracle ASM is provided a filename generated by Oracle Managed Files, known as a fully qualified filename (or system-generated filename).
Fully qualified filename
You can use a fully qualified form for referencing existing Oracle ASM files in Oracle ASM operations, except for disk group creation. This form is the Oracle ASM file name that Oracle ASM automatically generates when an Oracle ASM file is created.
A fully qualified file name has the following form:
<span class="codeinlineitalic">+diskgroup/dbname/filetype/filetypetag.file.incarnation</span>
Where:
<span class="codeinlineitalic">+diskgroup</span>
is the disk group name preceded by a plus sign. You can think of the plus sign (+
) as the root directory of the Oracle ASM file system, similar to the slash (/
) on UNIX or Linux computers.<span class="codeinlineitalic">dbname</span>
is theDB_UNIQUE_NAME
of the database to which the file belongs.<span class="codeinlineitalic">filetype</span>
is the Oracle file type and can be one of the file types shown in Table 7-3.<span class="codeinlineitalic">filetypetag</span>
is type-specific information about the file and can be one of the tags shown in Table 7-3.<span class="codeinlineitalic">file.incarnation</span>
is the file/incarnation pair, used to ensure uniqueness.
Abhishek
-
Hi,
What is your database version?
If you database version >=11, then you can use RMAN DUPLICATE command FROM ACTIVE database,
Regards
Mahir M. Quluzade