Stack Overflow
Stack Overflow

Questions tagged [rman]

rman or Recovery Manager is a CLI tool for performing backups and recoveries on an Oracle Database.

rman or Recovery Manager is a CLI tool for performing backups and recoveries on an Oracle Database.

Oracle Recovery Manager (RMAN) is available as a command-line tool and can be accessed from Oracle Enterprise Manager. It simplifies the tasks of restoring a database from backups due to disk/hardware errors, user errors, and for managing replication. It supports restoring to a point in time, or tablespace, data file, or complete database recovery.

Recommended reading on rman basics:

153 questions
1
vote
3 answers

Backup & Recovery Vs Flashback in Oracle

In Oracle, Flashback is used to recover the database to a particular point. If it is so, what is the need for backup and recovery? Since flashback itself can achieve the recovery of database what is the need for backup and recovery feature of RMAN…
Avinash
  • 37
  • 4
1
vote
2 answers

Oracle RAC RMAN Backup not writing to NFS Share

run { SET nocfau; ALLOCATE CHANNEL CH0 DEVICE TYPE DISK FORMAT '/nfs/datafile/%U_%T'; ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '/nfs/datafile/%U_%T'; ALLOCATE CHANNEL CH2 DEVICE TYPE DISK FORMAT '/nfs/datafile/%U_%T'; …
AAB
  • 1,594
  • 2
  • 25
  • 40
1
vote
0 answers

Oracle 18c XE installation failure - [FATAL] Error while cataloging RMAN Backups on Ubuntu 18.04

Prepare for db operation 7% complete Copying database files 8% complete [WARNING] ORA-12547: TNS:lost contact 29% complete 100% complete [FATAL] Error while cataloging RMAN Backups 7% complete 0% complete Look at the log file…
Geek Favour
  • 9
  • 5
1
vote
1 answer

How do i create a backup in SQL plus

I granted the user SYSBACKUP privileges and followed the steps in this link: https://blog.toadworld.com/2017/05/29/sysbackup-and-sysdg-permissions-in-oracle-12c However, after further analysis, it is clear that he makes a user, grants him SYSBACKUP…
Annon
  • 123
  • 1
  • 9
1
vote
1 answer

How to login as root user to Oracle's rman

I am trying to login rman as the root user: rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Wed Jan 8 21:40:47 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. RMAN-00571:…
Rajshree Rai
  • 533
  • 7
  • 14
1
vote
2 answers

RMAN backup into Google Cloud Storage

I want to take Oracle database backup using RMAN directly into the Google Cloud Storage I am unable to find the plugin to use to take the RMAN backups into Cloud Storage. We have a plugin for Amazon S3 and am looking for one such related to Google…
The Owl
  • 89
  • 7
1
vote
1 answer

RMAN commands not executing in .sh file

I have been trying to implement .sh file which opens the RMAN promt and shows the backup summary of last database backups. Script [apex@idmhost ~]$ cat b1.sh ls rman target / catalog rman/rman123@apexdb list backup summary; Output sh b1.sh 0 …
SKuser
  • 35
  • 1
  • 4
  • 9
1
vote
1 answer

RMAN Backup - different output using same command

I see a different output or behaviour of RMAN 'backup database' command using "format keyword" when I keep the part of the syntax once in the middle and the other in the end it stores backup at different location as mentioned in the below cases In…
Mohammeddba
  • 41
  • 5
1
vote
0 answers

Oracle 12c Cloning PDBs from disk

In Oracle 12c is it possible to clone/duplicate a PDB into a different CDB using a disk backup? So if I take a backup to disk as follows, can I then clone from this backup into a new PDB in a different CDB? RMAN> connect target…
Franco
  • 23
  • 1
  • 8
1
vote
2 answers

Oracle Backup and recovery

new to oracle, I am having a oracle DB which we don't use anymore(version : 8.1.7.4). I want to take a backup and keep it for few more years(we don't know if we may need something later on) 1 >> What is the best way to take a backup ? 2 >> Can I…
Jack
  • 101
  • 1
  • 6
1
vote
2 answers

RMAN backup restore in a different node with datafiles and redolog files to a different directory

I can't restore the datafiles and redolog files from backup. In RMAN I wrote, run{ set newname for datafile 1 to '/u02/data_redo/system01.dbf'; set newname for datafile 2 to '/u02/data_redo/sysaux01.dbf'; set newname for datafile 3 to…
Somadder Abhijit
  • 85
  • 1
  • 3
  • 9
1
vote
1 answer

Oracle Backup with RMAN take a long time

I have Oracle Database 11g Release 11.2.0.3.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management. OS is Linux Red Hat 2.6.18-348.12.1.el5. Database name: dbname Database size is approx 92 GB. The execution of…
user2048092
  • 37
  • 1
  • 5
1
vote
1 answer

What happens to not commited transaction in oracle RMAN backup

I have written script for oracle backup and restore using RMAN. Note i took backup database + archive logs Now, I did some sql statement in oracle but not commited transaction then it may be somewhere in redo logs i am not sure about it. Now, In…
Dipak
  • 672
  • 3
  • 9
  • 26
1
vote
1 answer

Restore Oracle Database From Oradata Folder

I have lost my database on the server because the computer has been formatted on drive C. But the oracle folder was located on Drive E, like oradata, etc. Can I restore oracle database like before?
Melkikun
  • 46
  • 1
  • 7
1
vote
0 answers

How to repair or ignore corrupted blocks in oracle in noarchivelog mode

I have a table with partitioned by date. Today when I run query for entire month I get following error: SQL Error [1578] [72000]: ORA-01578: ORACLE data block corrupted (file # 10, block # 19007437) ORA-01110: data file 10: '\UDR'' unfortunately…
hi4ppl
  • 595
  • 1
  • 6
  • 21
1
2
3
…
10 11