smu
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| smu [2018/12/08 12:49] – created 0.0.0.0 | smu [2019/01/30 11:32] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== SMU ====== | + | ==== Oracle Snap Management Utility (SMU) ==== |
| - | + | ||
| - | =====Oracle Snap Management Utility (SMU)===== | + | |
| can be accessed via command line Interface (CLI) as well as the standard Browser User Interface (BUI) | can be accessed via command line Interface (CLI) as well as the standard Browser User Interface (BUI) | ||
| - | < | + | < |
| + | cat / | ||
| + | </ | ||
| locate the line " | locate the line " | ||
| - | < | + | < |
| - | =====Create a clone database from an RMAN backup using SMU===== | + | ssh -p <ssh port> < |
| - | Copied from [[https:// | + | </ |
| - | Source database PRD1S1<br /> | + | ==== Create a clone database from an RMAN backup using SMU ==== |
| - | Target database ACC1<br /> | + | Copied from [[https:// |
| + | Source database PRD1S1\\ | ||
| + | Target database ACC1\\ | ||
| Two NFS mounts in /etc/fstab | Two NFS mounts in /etc/fstab | ||
| - | < | + | < |
| + | 10.60.30.10:/ | ||
| + | 10.66.30.10:/ | ||
| + | </ | ||
| Make sure these mount points exist | Make sure these mount points exist | ||
| - | < | + | < |
| + | mkdir -p / | ||
| + | mkdir -p / | ||
| + | </ | ||
| Mount them as user root | Mount them as user root | ||
| - | < | + | < |
| + | mount / | ||
| + | mount / | ||
| + | </ | ||
| 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. | 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. | ||
| - | < | + | < |
| + | zfs01:> shares | ||
| + | zfs01:> list #this will show project names | ||
| + | ACC01 | ||
| + | ACC02 | ||
| + | zfs01:> select ACC01 | ||
| + | zfs01:> show | ||
| + | .. | ||
| + | .. | ||
| + | Filesystems: | ||
| + | NAME SIZE | ||
| + | acc1-ctl | ||
| + | acc1-dbf | ||
| + | zfs01: | ||
| + | default_user = 1001 #UID of user oracle on compute node | ||
| + | zfs01: | ||
| + | default_group = 1002 #GID of dba group on compute node | ||
| + | - To adjust use: | ||
| + | zfs01: | ||
| + | </ | ||
| Backup the database with RMAN | Backup the database with RMAN | ||
| - | < | + | < |
| + | run { | ||
| + | set nocfau; # NO Control File AUto backup (we take a specific backup of control file) | ||
| + | backup as copy database format '/ | ||
| + | backup as copy archivelog all format '/ | ||
| + | backup as copy current controlfile format '/ | ||
| + | } | ||
| + | </ | ||
| Note: for this procedure to work, the database has to be backed up using 'as copy' | 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 /> | + | Ensure we have all the redo necessary for the recover by sending some more archivelogs over and backing them up.\\ |
| On the primary database... | On the primary database... | ||
| - | < | + | < |
| - | < | + | SQL> alter system switch logfile; |
| + | SQL> alter system switch logfile; | ||
| + | SQL> alter system checkpoint; | ||
| + | </ | ||
| + | < | ||
| + | run { | ||
| + | set nocfau; | ||
| + | backup as copy archivelog all format '/ | ||
| + | } | ||
| + | </ | ||
| From SMU, deprovision (drop) any existing database of same name just in case | From SMU, deprovision (drop) any existing database of same name just in case | ||
| - | < | + | < |
| + | smu> tasks add -F deprovision acc1 | ||
| + | </ | ||
| Create an application for the database creation | Create an application for the database creation | ||
| - | < | + | < |
| + | smu> accounts add -t APPLICATION -p ORACLE_DATABASE -o cluster_database=false -o host=db01 -o oracle_sid=ACC1 -o password=***** -o port=1521 -o storage=zfs01 ACC1 | ||
| + | </ | ||
| Create the database | Create the database | ||
| - | < | + | < |
| + | smu> tasks add -F import -o oracle_home=/ | ||
| + | </ | ||
| Watch the progress using the task id from the import above | Watch the progress using the task id from the import above | ||
| - | < | + | < |
| + | smu> tasks tail -f 455 | ||
| + | Getting storage appliance node name | ||
| + | Getting network interface address(s) | ||
| + | Verifying target appliance instance does not already exist | ||
| + | Creating snapshots of backup shares | ||
| + | Finding share(s) | ||
| + | Taking snapshots of share(s) | ||
| + | Cloning snapshot(s) | ||
| + | Finding share(s) | ||
| + | Cloning share snapshot(s) | ||
| + | Mounting the clone share(s) | ||
| + | Mounting the backup | ||
| + | Scanning files in the backup | ||
| + | Getting the backup block size | ||
| + | Starting temporary instance in nomount stage | ||
| + | Shutting down instance | ||
| + | Creating revised temporary pfile | ||
| + | Starting temporary instance in mount stage | ||
| + | Calculating the max SCN and FRA size | ||
| + | Getting backup configuration | ||
| + | Dismounting the backup | ||
| + | Shutting down temporary instance | ||
| + | Configuring and starting clone instance | ||
| + | Adding entry to oratab | ||
| + | Creating the required database directories | ||
| + | Creating the password file | ||
| + | Creating the pfile | ||
| + | Starting the database in nomount stage | ||
| + | Creating the control file | ||
| + | Recovering the database | ||
| + | Opening the database and resetting the logs | ||
| + | Adding the temp file(s) | ||
| + | Dropping the cluster views | ||
| + | Dropping extra undo tablespaces | ||
| + | --- TASK SUCCEEDED --- | ||
| + | </ | ||
smu.1544273361.txt.gz · Last modified: 2018/12/08 12:49 by 0.0.0.0