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. I think the original commands I used were:
$ rman target=/
RMAN> configure retention policy to redundancy 2;
RMAN> configure controlfile autobackup on;
RMAN> backup database plus archivelog delete input;
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. I am looking for comparative analysis.
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 channels for that backup, both pointing to the same directory. It works fine, generating 2 backupsets (backupsets? I think. I'm a bit confused about terminology: a backup consists of one or more backupsets?). Anyway, the duplicate process picks up these backupsets and restores a copy of the database from them. I noticed today that it allocates 3 channels, but only two appear to be used. Is that because the backup process only used 2? Which brings me to the major point: given my configuration, is there any advantage to allocating more channels for backup and restore? This is an 80GB database, and the restores takes over 2 hours to complete which seems slow to me - I can do a hot backup in that amount of time, and I thought RMAN had performance advantages over simple scripted backups.
To summarize my questions:
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 2003 server ,this windows 2003 server is all different server, computer
name and other thing.
and i was cold backuped from old 2003 server then i was copy all this file
to new 2003 server and startup but failed to startup
how can i restore in this situation?
what is exact procedure to full restore from my old windows 2003 to new 2003 machine.
or maybe how about if i copy whole oracle folder from old machine then
paste it to new machine?
is it possible ? Thanks a lot sorry my english
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?