"Monitor tables which are filled with nologging ", version 9ir2
Olaf mueller, June 13, 2007 - 2:58 am UTC
Hi,
I know of the use of force logging, the question was , if I can monitor tables which were load in nologging mode.
Perhaps I have told you that I dont want to set the db in force logging mode. I only want to get an information when nologging is used.
Regards Olaf
June 13, 2007 - 8:11 am UTC
but, I told you how to monitor it. did you see that?
.... Short of that, a job to query v$datafile looking for the unrecoverable change time to appear and email you (using utl_smtp) .....
it is tracked at the datafile level, and you would simply check for it periodically.
rman REPORT UNRECOVERABLE
Mwakuye, June 13, 2007 - 11:09 am UTC
Hi Olaf,
i think there's rman command, if you are using rman.
REPORT UNRECOVERABLE
but this lists only Datafiles and not Tables.
Regards,
Mwakuye
NO DATA RESTORE
HUSSEN, August 29, 2007 - 6:26 am UTC
HI TOM :
PLEASE I NEDD HELP
I WANT TO USE RMAN TO DO BACKUP
I DO THIS STEPS:
CONNECT sys/oracle AS SYSDBA
drop TABLESPACE "RMAN" INCLUDING CONTENTS;
drop user rman cascade;
CREATE TABLESPACE "RMAN"
DATAFILE 'C:\temp\RMAN01.DBF' SIZE 6208K REUSE
AUTOEXTEND ON NEXT 64K MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman;
GRANT connect, resource, recovery_catalog_owner TO rman;
rman catalog=rman/rman@orcl
create catalog tablespace "RMAN";
------------------------------
exit
------------------------------
rman catalog=rman/rman@orcl target=sys/oracle@orcl
------------------------------
register database;
RMAN> configure retention policy to recovery window of 7 days;
RMAN> configure default device type to disk;
RMAN> configure controlfile autobackup on;
RMAN> configure channel device type disk format 'C:\temp\Backup%d_DB_%u_%s_%p';
------------------------------
sql > shutdown immediate;
sql > startup mount;
sql > alter database archivelog;
sql > alter database open;
---------------------------------
RMAN>
run {
backup database plus archivelog;
delete noprompt obsolete;
}
------------------------------------
RMAN> resync catalog;
------------------------------------
run
{
sql 'ALTER TABLESPACE users OFFLINE IMMEDIATE';
#SET UNTIL TIME "TO_DATE('2007-29-08:13:25:00','yyyy-dd-mm:hh24:mi:ss')";
restore tablespace users;
#recover tablespace users;
RECOVER TABLESPACE users;
sql 'ALTER TABLESPACE users ONLINE';
}
BUT IF I EXEC DML COMMAND
THE CHAMGES DOS'NT RESTORE
EXPMPLE :
1- I DO BUCKUP
2- I CREATE TABLE EMPLOYEE
AND I INSERT INTO THE TABLE;
3- I I RESTORE THE LAST BACKUP MUST THE TABLE DOS'NT EXEIST
PLESE GIVE ME ACOORECT SCRIPT;
OR TELL ME WHERE THE INCORRECT
MORE THANKS TOMM
September 04, 2007 - 3:55 pm UTC
SHIFT LOCK - use it.
You don't give us a full example here. You don't show the rman output, there is so much missing from this description.