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
0
votes
2 answers

can not prepare primary database for standby database creation (for RMAN)

i was trying to prepare a primary database for standby database creation. while executing set_log_params.sql, we struck with an error "ORA-32017 failure in updating SPFILE" and "ORA-00439 feature not enabled: managed standby". from the detailed…
Jayalaxmi
  • 1
0
votes
2 answers

Connect with RMAN to database by ip address

After rman target / I am connected to my local database, however I would like to connect to database to which I have credentials - ip, port, username, password (in general to which I can connect via SQLDeveloper). Is it possible through RMAN?
Michu93
  • 5,058
  • 7
  • 47
  • 80
0
votes
1 answer

How to restore oracle database in docker from RMAN backup outside container

I was looking for a solution but unfortunately I couldn't find the right answer. I have docker container with oracle database (database-enterprise:12:2:0.1) and I have rman backup (archivelogs, controlfile, spfile) on Windows. How can I upload this…
treekt
  • 147
  • 1
  • 12
0
votes
1 answer

Error backup online database,archivelog,control file using two channel

I need to Backup your online database, archivelog and control file using two channel but I have some problem with it. My code: run{ allocate channel c1 device type desk controlfile 1; allocate channel c2 device type desk controlfile 1; …
Mamoun Mamoun
  • 1
0
votes
2 answers

Oracle 12c - RMAN report unrecoverable

I am having trouble checking my Oracle backups with RMAN. The "report need backup" command does not display anything, which means that there is no problem ; but the command "report unrecoverable" asks me to do another backup : RMAN> report need…
Tony92
  • 91
  • 7
0
votes
1 answer

Oracle Database Backup Through RMAN

I'm looking for methods to backup my Oracle Database. It is hosted at a Windows server. Currently, I used Oracle SQL Developer to establish connection with the database and make changes to it. I am now considering 2 methods to backup the…
DeadIsFree
  • 11
  • 2
0
votes
0 answers

Oracle Archivelog specification does not match any archived log in the repository

I'm not be able execute any RMAN's command as like as below: RMAN>list archivelog all RMAN>delete archivelog until time 'sysdate-0' RMAN>delete archivelog all RMAN>crosscheck archivelog all for all above command I this error has apeared: released…
ali yousef
  • 87
  • 2
  • 6
  • 15
0
votes
2 answers

RMAN connecting to wrong target

When I run rman target / @mydb nocatalog cmdfile=%commands% msglog=%logfile%, I see connected to target database: OTHERDB (DBID=3786352837, not open). Help!
publicRavi
  • 2,657
  • 8
  • 28
  • 34
0
votes
0 answers

Not able to implementing RMAN Script (Backup)

I have been trying to take backup of database by using following script. But it is unable to finish (complete) backup. It is only initiating the backup but I can't see it at a particular…
SKuser
  • 35
  • 1
  • 4
  • 9
0
votes
1 answer

RMAN online full backup without archivelogs

I need to take oracle database full backup (online) which is in archivelog mode. My current archive redo log partition space is very less, so i backup and delete archived redo log files then and there to manage the space. My question if i take rman…
knkarthick24
  • 3,106
  • 15
  • 21
0
votes
1 answer

Script Python connects and runs queries RMAN (ORACLE) commands

I want to write code in python to run RMAN (ORACLE) commands. Do you have any samples or tutorials ?
Flochon
  • 31
  • 1
  • 8
0
votes
1 answer

Which is the fastest way to replicate oracle database deployed in RDS?

For example: Lets say i have two database DB1 and DB2. Now my requirement is to refresh data from DB1 to DB2 every night. DB1 is live database and DB2 is for non business users for data analysis. My questions: 1) What must be the tool i should use…
Vivek
  • 4,452
  • 10
  • 27
  • 45
0
votes
1 answer

RMAN ORA-19913: unable to decrypt backup

I have been sent a RMAN backup, which is dual encrypted, wallet and password. The Oracle version is 11.1.0.7. I am trying to restore the database on a new server. I performed the following steps: Create database with ORACLE_SID THEDB using a…
TenG
  • 3,843
  • 2
  • 25
  • 42
0
votes
0 answers

Unable to get any rows back from V$RMAN_BACKUP_JOB_DETAILS in 12c

I have got a user MONITOR thru which i am running a SQL script select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_BKUP_START_TIME, to_char(END_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_BKUP_END_TIME, …
pahariayogi
  • 1,073
  • 1
  • 7
  • 18
0
votes
1 answer

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

I'm trying to restore an spfile as the first step in a cloning procedure from a Simpana backup of a 12c DB (TEST44) to it's duplicate (TEST15). The Source DB has been successfully backed up using Simpana. Autobackup has been set: CONFIGURE…
Franco
  • 23
  • 1
  • 8
1 2 3
…
10 11