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
1 answer

Back up Oracle db gives error

Here is my command to backup database : RMAN> backup as backupset database plus archivelog; Here are the errors I get : Starting backup at 18-APR-17 ORACLE error from target database: ORA-00258: manual archiving in NOARCHIVELOG mode must identify…
jason
  • 6,962
  • 36
  • 117
  • 198
0
votes
1 answer

Oracle started failed, how to connect RMAN?

Currently, my Oracle cannot be started up successfully. I executed startup mount, it is OK. Then I executed startup open. It said Unable to Creating archive log file to '+DGARCH' ARCH: Error 19504 Creating archive log file '+DGARCH' I got some…
Wendy
  • 73
  • 2
  • 15
0
votes
1 answer

Difference between archivelog options in rman

What is the difference betweeen those two commands regarding archivelogs: BACKUP DATABASE PLUS ARCHIVELOG; and BACKUP ARCHIVELOG ALL;
Marcin Nowakowski
  • 11
0
votes
1 answer

Restoring from Oracle RMAN backup fails about 60% of the time (noarchivelog mode)

I have a strange case where restoring a recently created Oracle RMAN backup sometimes works and at other times does not. We use Oracle 12c. The database is running in noarchivelog mode. Full story: We have a large CI setup, where a node can pick up…
rednax
  • 225
  • 1
  • 2
  • 13
0
votes
0 answers

Oracle OCI API RMAN Commands

When I try to execute the "delete noprompt archivelog until time ‘SYSDATE-1’;" command using "OCIStmtExecute" function , I am getting an error like "ORA-00933: SQL command not properly ended" Is this the correct command to delete ARCHIVE logs?…
AishwaryaKasi
  • 83
  • 7
0
votes
2 answers

Add database name to the output of V$RMAN_BACKUP_JOB_DETAILS

I am using the below command to get a single row output and my requirement is to have a first column as DB NAME followed by the selected columns below. How do I achieve it? select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy…
Arun N
  • 1
0
votes
1 answer

Backup Oracle Physical Standby through DBMS_SCHEDULER job

Friends! We have a lot of primary databases with their physical standby databases in Data Guard configurations on servers. Each primary database on single server and each physical standby on single server. In EM12c we've configured scheduler jobs…
Sergey
  • 157
  • 1
  • 6
  • 19
0
votes
2 answers

oracle rman duplicate database

I'm trying to duplicate from active database. I have configured everything according to oracle docs. still in the middle of the process I get the error RMAN-06025: no backup of archived log for thread 1 with sequence 58 and starting SCN of 2001221…
Mani Shirvani
  • 188
  • 1
  • 8
0
votes
0 answers

How can I backup an Oracle Tablespace and restore it as another tablespace in the same Schema

I am very new to oracle, I have an Oracle Schema (ORCL) that has two table spaces TBS_PROD TBS_TEST I want to backup TBS_PROD and then restore it into or as TBS_TEST. Is there a script or a tool that I can use? Regards Brian
Brian Honde
  • 1
  • 1
0
votes
0 answers

Issuing commands to command-line utility through .bat file

I'm trying to issue commands to RMAN (oracle's backup manager utility) through a .bat file (though I hope the syntax is similar.) I'm very new to RMAN and even newer to .bat files, but copying the format I've found from examples online, I made: rman…
Edward Peters
  • 3,623
  • 2
  • 16
  • 39
0
votes
1 answer

How to view content of +DATA, +FRA in RAC environment Oracle

I am trying to restore oracle RAC RAMN backup to another RAC where only software is installed. I am able to restore control files some how on "+DATA/..." I have some doubt about RAC setup. Que 1) What are +DATA, +FRA. Que 2) I am so curious about…
Dipak
  • 672
  • 3
  • 9
  • 26
0
votes
1 answer

Which SCN should i refer if there are two thread# in v$archive_log oracle

I am taking oracle backup using RMAN and saving current scn number i am getting scn number from below command select max(next_change#) from v$archived_log where archived = 'YES' group by thread#; It gives outut as below…
Dipak
  • 672
  • 3
  • 9
  • 26
0
votes
1 answer

unable to startup database to free up space from recovery area:

when i am trying to connect with database I faced this error--- 'ORA-19815: WARNING: db_recovery_file_dest_size of 4102029312 bytes is 100.00% used, and has 0 remaining bytes available.' so to delete obsolete file from flash recovery area i need…
Mou
  • 3
  • 1
  • 4
0
votes
1 answer

Lost Redologs and Archivelogs

I am using Oracle XE 11g R2 and due to a mistake all the archivelogs where deleted by running delete archivelog all; command on RMAN. Also one set of redo logs were deleted i.e. redo_g02a.log, redo_g02b.log and redo_g02c.log Other redolog are…
Zulqarnain Habib
  • 3
  • 3
0
votes
1 answer

Oracle 12c - Post upgrade attempt to restoreBackupPiece fails

I've recently upgraded my database software from Oracle 11.2.0.4 to Oracle 12c, it was a clean without any instances or database on it. The machine is Windows Server R2 2012. The process itself was: Install Oracle 11.2.0.4 and upgrade (software…
David Faizulaev
  • 4,651
  • 21
  • 74
  • 124
1 2 3
…
10 11