Untuk masuk ke rman lebih baik kita mengenal recovery dan bagaimana membuatnya
Recovery catalog adalah schema yang disimpan didatabase yang berfungsi untuk mentrack backup dan menyimpan script yang digunakan untuk RMAN backup dan situasi recovery. Jadi semacam log.
Cara membuat Recovery Catalog :
1. Anda masuk sebagai system
SQL> conn sys/admindb@cdb1 AS sysdba
Connected.
2. Buatlah tablespace tools terlebih dahulu
SQL> CREATE TABLESPACE tools DATAFILE
2 '/u01/app/oracle/oradata/cdb1/tools01.dbf'
3 SIZE 15M AUTOEXTEND ON NEXT 1M;
Tablespace created.
3. Lalu buat schema dan user untuk recovery catalog
SQL> CREATE USER rman IDENTIFIED BY cat
2 TEMPORARY TABLESPACE temp
3 DEFAULT TABLESPACE tools
4 QUOTA UNLIMITED ON tools;
User created.
4. Lalu beri grant recovery catalog ke user
SQL> GRANT RECOVERY_CATALOG_OWNER TO rman;
Grant succeeded.
5. Lalu coba masuk rman dengan recovery catalognya
-bash-4.1$ rman CATALOG rman/cat@cdb1
Recovery Manager: Release 12.1.0.2.0 - Production on Fri Nov 10 14:47:29 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
6. atau dengan rman utility prompt
RMAN> CONNECT CATALOG rman/cat@cdb1
connected to recovery catalog database
7. Lalu buatlah catalog dengan “Create Catalog”, tunggu beberapa waktu hingga proses selesai
RMAN> CREATE CATALOG
recovery catalog created
Registrasi database ke RMAN
1. Melakukan koneksi ke rman dengan parameter database dan recovery catalog
-bash-4.1$ rman TARGET sys/admindb@cdb1 CATALOG rman/cat@cdb1
Recovery Manager: Release 12.1.0.2.0 - Production on Fri Nov 10 14:51:13 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=932551793)
connected to recovery catalog database
2. Jika database belum start
RMAN> STARTUP;
database is already started
3. Lalu registrasikan database
RMAN> REGISTER DATABASE;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete