This is an old revision of the document!
Table of Contents
SMU
Oracle Snap Management Utility (SMU)
can be accessed via command line Interface (CLI) as well as the standard Browser User Interface (BUI)
0@@
locate the line “sshd.port=<ssh port>” and use this with the root user and password
1@@
Create a clone database from an RMAN backup using SMU
Copied from frankdba in case his website goes down. This is too useful to lose!<br /> Source database PRD1S1<br /> Target database ACC1<br /> Two NFS mounts in /etc/fstab
2@@
Make sure these mount points exist
3@@
Mount them as user root
4@@
Ensure the export directories on the ZFS have the correct permissions. Apparently they can be exported as user nobody instead of the oracle database owner.
5@@
Backup the database with RMAN
6@@
Note: for this procedure to work, the database has to be backed up using 'as copy' Ensure we have all the redo necessary for the recover by sending some more archivelogs over and backing them up.<br /> On the primary database…
7@@
8@@
From SMU, deprovision (drop) any existing database of same name just in case
9@@
Create an application for the database creation
10@@
Create the database
11@@
Watch the progress using the task id from the import above
12@@