Rman at work

Connecting to RMAN with "NOCATALOG" and "CATALOG"

"rman" client application can be opened directly from command prompt

c:\Oracle\bin>set ORACLE_SID=srinivas

c:\Oracle\bin>echo %ORACLE_SID%
srinivas

c:\Oracle\bin>rman

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Dec 8 12:43:47 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target

connected to target database: SRINIVAS (DBID=3234594012)

RMAN

If you use catalog hosted in a separate in stance as a separate database, connect to that catalog database using TCP protocol. 

set ORACLE_SID=srinivas

Oracle 12c family introduces case sensitivity. And also introduced SYSBACKUP role which is to be granted to that backup user/s. 
WHEN you UPGRADE  a database from 11gR2 to 12c family this SYSBACKUP role is granted internally. When a user is granted that administrative role (or any administrative role that user can not be dropped unless unless the parameter "_oracle_script" is disabled at least at the session level. 

SQL> drop user "cat_srinivas" cascade;
drop user "cat_srinivas" cascade
*
ERROR at line 1:
ORA-28014: cannot drop administrative user or role


SQL> alter session set "_oracle_script"=true;

Session altered.

SQL> drop user "cat_srinivas" cascade;

User dropped.

SQL> create user cat_srinivas 
identified by  
default tablespace users 
temporary tablespace temp 
profile default 
quota unlimited on users;

User created.

SQL> grant recovery_catalog_owner to cat_srinivas;

Grant succeeded.

SQL> grant sysbackup to cat_srinivas;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

c:\Oracle\bin>rman

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Dec 8 16:05:08 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target

connected to target database: ACHARYA (DBID=576297196)

RMAN> exit


Recovery Manager complete.

c:\Oracle\bin>set ORACLE_SID=srinivas

c:\Oracle\bin>rman

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Dec 8 16:06:24 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target

connected to target database: SRINIVAS (DBID=3234594012)

RMAN> connect catalog cat_srinivas/S19it20A@acharya

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> backup database;

Starting backup at 08-DEC-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/08/2020 16:08:55
RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode

RMAN> shutdown immediate

database closed
database dismounted
Oracle instance shut down

RMAN> startup mount

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area    2550133384 bytes

Fixed Size                     9269896 bytes
Variable Size                570425344 bytes
Database Buffers            1962934272 bytes
Redo Buffers                   7503872 bytes

RMAN> alter database archivelog;

Statement processed

RMAN> archive log list;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release"
RMAN-01008: the bad identifier was: archive
RMAN-01007: at line 1 column 1 file: standard input

RMAN> alter database open
2> ;

Statement processed

RMAN> backup database;

Starting backup at 08-DEC-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=149 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\DATAFILE\O1_MF_SYSTEM_HVM0QCX5_.DBF
input datafile file number=00003 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\DATAFILE\O1_MF_SYSAUX_HVM0RH9S_.DBF
input datafile file number=00004 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\DATAFILE\O1_MF_UNDOTBS1_HVM0RYO8_.DBF
input datafile file number=00007 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\DATAFILE\O1_MF_USERS_HVM0RZTY_.DBF
channel ORA_DISK_1: starting piece 1 at 08-DEC-20
channel ORA_DISK_1: finished piece 1 at 08-DEC-20
piece handle=C:\APP\ACHARYA\FAST_RECOVERY_AREA\SRINIVAS\BACKUPSET\2020_12_08\O1_MF_NNNDF_TAG20201208T161451_HWZV6DPN_.BKP tag=TAG20201208T161451 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\3A65A868DCD84034BB4A095B9D757DB8\DATAFILE\O1_MF_SYSAUX_HVM1TR5J_.DBF
input datafile file number=00009 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\3A65A868DCD84034BB4A095B9D757DB8\DATAFILE\O1_MF_SYSTEM_HVM1TQPO_.DBF
input datafile file number=00011 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\3A65A868DCD84034BB4A095B9D757DB8\DATAFILE\O1_MF_UNDOTBS1_HVM1TR5Z_.DBF
input datafile file number=00012 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\3A65A868DCD84034BB4A095B9D757DB8\DATAFILE\O1_MF_USERS_HVM1WQK2_.DBF
channel ORA_DISK_1: starting piece 1 at 08-DEC-20
channel ORA_DISK_1: finished piece 1 at 08-DEC-20
piece handle=C:\APP\ACHARYA\FAST_RECOVERY_AREA\SRINIVAS\3A65A868DCD84034BB4A095B9D757DB8\BACKUPSET\2020_12_08\O1_MF_NNNDF_TAG20201208T161451_HWZV7T47_.BKP tag=TAG20201208T161451 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\DATAFILE\O1_MF_SYSAUX_HVM12OYZ_.DBF
input datafile file number=00005 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\DATAFILE\O1_MF_SYSTEM_HVM12OXN_.DBF
input datafile file number=00008 name=C:\APP\ACHARYA\ORADATA\SRINIVAS\DATAFILE\O1_MF_UNDOTBS1_HVM12P0W_.DBF
channel ORA_DISK_1: starting piece 1 at 08-DEC-20
channel ORA_DISK_1: finished piece 1 at 08-DEC-20
piece handle=C:\APP\ACHARYA\FAST_RECOVERY_AREA\SRINIVAS\CD1B29022B7447E8AF222EF6195D8DAC\BACKUPSET\2020_12_08\O1_MF_NNNDF_TAG20201208T161451_HWZV89K8_.BKP tag=TAG20201208T161451 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 08-DEC-20

Starting Control File and SPFILE Autobackup at 08-DEC-20
piece handle=C:\APP\ACHARYA\FAST_RECOVERY_AREA\SRINIVAS\AUTOBACKUP\2020_12_08\O1_MF_S_1058631370_HWZV8VK7_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 08-DEC-20

RMAN>

Related Posts: