OPS backup

Printable View

08-11-2003, 05:41 PM
rommel

OPS backup

Hi All,

I have an Oracle 8i OPS on AIX 4.3.2. I also have 2 intances running
against the DB. My question is, if I shutdown intance1 and perform a cold backup while instance2 is actively performing DMLs, how can I apply changes (archive logs of instance2) to intance1 during recovery?
I have coppied instance1 and the DB to a test server and started it up.

Thanks in advance friends, :)
08-12-2003, 04:28 AM
oddster

Rommel,

You cannot take a 'cold' backup if an instance is writing to the database files.
You must stop both instances to do this.

Secondly, all 'changes' are made in the database files eventually anyway, and are logged in thread-specific archive logs. Why do you need to 'recover' instance 1? Just restart it and away you go.

Brgds,

Andy
08-12-2003, 02:13 PM
rommel

Thanks Friend, I'm quite puzzled.
So, If I have a hot backup on instance1 and supposing my database crashed, Do you mean I will just restore instance1 and apply its archive logs and no need to bother on instance2?
08-12-2003, 08:54 PM
rommel

Hi Friends,

Sorry for being redundant (dumb) :), but I still can't make a right db recovery.

If I'm going to have an online backup, which files should I backup first, or what is the right sequence? My understanding are the ff:
1. datafiles (with alter tablespace begin/end backup)
2. control files (backup to file)
3. redo logs files (online?)
4. archived logs

I always get an error of unsync time stamp between files esp
system.dbf

Am i right? Why is that the docs says not to include the redo logs files? Online redo logs refers to the current physical redo logs, right? How can I start a database without the physical redo logs? Do
I have to create a new one?

Thanks a lot.
08-13-2003, 01:30 AM
julian

Quote:

Originally posted by rommel
Hi Friends,

Sorry for being redundant (dumb) :), but I still can't make a right db recovery.

If I'm going to have an online backup, which files should I backup first, or what is the right sequence? My understanding are the ff:
1. datafiles (with alter tablespace begin/end backup)
2. control files (backup to file)
3. redo logs files (online?)
4. archived logs

I always get an error of unsync time stamp between files esp
system.dbf

Am i right? Why is that the docs says not to include the redo logs files? Online redo logs refers to the current physical redo logs, right? How can I start a database without the physical redo logs? Do
I have to create a new one?

Thanks a lot.

How about learning some RMAN, right?