Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [rman]

11 questions
3
votes
1 answer

Oracle RMAN Full Database Recovery

I want to restore a full database backup of a database in noarchivelog, but not the last backup. How can I select the full backup to restore?
Guille
  • 131
  • 1
2
votes
2 answers

Disable RMAN backups in Oracle 11g

Recently I tinkered around with RMAN to see how it works, and somehow managed to get a regularly scheduled backup going. I don't really have the disk space or the need for RMAN to run, but I can't figure out how to stop it from creating backup sets.…
nw.
  • 723
  • 2
  • 8
  • 12
2
votes
1 answer

oracle database move current server to another machine problem

these day i really stress because of oracle server, im quite new to oracle. i have one old windows 2003 server which installed oracle 10.2.0 version. and i want to full backup of this oracle then want to install same database to another new windows…
paul
1
vote
2 answers

Oracle VSS Writer vs. RMAN

I am unable to find any literature to evaluate which solution to use when backing up my Oracle 11g DB. The attempt is to perform online backups by enabling ARCHIVELOG mode. Edit: I have gone through individual documentation for RMAN and VSS Writer.…
publicRavi
  • 33
  • 9
1
vote
1 answer

Oracle 10gR2 RMAN: Channel allocation

Oracle 10gR2, Win2003. I know enough about RMAN to perform basic functions. I'm trying to learn more. We have an RMAN backup process that is used to duplicate a database nightly. The backup is generated on a single disk. The script allocates 2…
DCookie
  • 2,098
  • 17
  • 18
0
votes
1 answer

Oracle RMAN full backup due to gaps in ARCHIVE LOGs

I've recently recovered a Data Guard configuration. Simple setup that syncs from primary to standby using Data Guard. Because it's been on-line for a sustained period, some logs are missing and I need to do a full export. From what I understand, a…
sambomartin
  • 151
  • 1
  • 1
  • 11
0
votes
1 answer

Transfer enterprise data - tiny volumes - to AWS S3 for Heroku app

What would you suggest is the best option to get "enterprise" data from a client into AWS S3 so we can provide Heroku hosted SaaS? The data volumes are tiny, it's just daily spreadsheet/csv records. But to provide a SaaS solution we need to get the…
rigyt
  • 53
  • 1
  • 5
0
votes
1 answer

Does Oracle database need to be restarted to use Rman?

We have an Oracle database which uses Rman. The server hosting Rman repositories crashed. We've put the Rman server back online, but do we need to bounce the Oracle database to get it to start using Rman again?
ybe32
  • 1
  • 1
0
votes
1 answer

Common use cases of RMAN restore/recovery

To test our Oracle backup & recovery process, I would like to simulate some common fail case scenarios. Any suggestions?
publicRavi
  • 33
  • 9
-1
votes
1 answer

Symantec Netbackup : Oracle restore fails "exited with status 13: file read failed"

I am restoring Oracle datafile size of 1200GB. Datafile is read from backup piece size of 4000GB(4TB). Note: As I monitored 4TB is processed totaly to read all blocks of my datafile. I had several problems during restore: Situation 1. There was…
kupa
  • 381
  • 2
  • 8
  • 18
-1
votes
1 answer

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).
publicRavi
  • 33
  • 9